Estou precisando usar essa API, encontrei um código no metalink ( abaixo ), mas quando executo dá erro de numero errado de argumentos, alguém saberia o modo certo de usá-la, de como passar os parâmetros.
Grato
Ricardo
Código:
declare
v_msg_count number;
v_msg_data varchar2(240);
v_return_status varchar2(1);
v_new_adj_num number;
v_new_adj_id number;
v_count number;
Type adj_rec IS Record
(
p_last_updated_by number := -1,
p_last_update_date date := trunc(sysdate),
p_last_update_login number := -1,
p_created_by number := -1,
p_creation_date date := trunc(sysdate),
p_amount number := 30.00,
p_apply_date date := trunc(sysdate),
p_gl_date date := trunc(sysdate),
p_set_of_books_id number := 1001,
p_code_combination_id number := 1138,
p_type varchar2(10) := 'LINE',
p_adjustment_type varchar2(1) := 'M',
p_status varchar2(1) := 'w',
p_associated_cash_receipt_id number := 21296,
p_customer_trx_id number := 147599,
p_payment_schedule_id number := 123624,
p_receivables_trx_id number := 1019,
p_created_from varchar2(10) := 'ARXTWADJ',
p_postable varchar2(1) := 'N',
p_posting_control_id number := -3,
p_acctd_amount number := 30.00,
p_program_application_id number := -1,
p_program_id number := -1,
p_program_update_date date := trunc(sysdate),
p_org_id number := 91
);
v_adj_rec adj_rec;
begin
dbms_output.put_line('Start API');
AR_ADJUST_PUB.create_adjustment
(
p_api_name => 'AR_ADJUST_PUB',
p_api_version => 1.0,
p_msg_count => v_msg_count,
p_msg_data => v_msg_data,
p_return_status => v_return_status,
p_adj_rec => v_adj_rec,
p_new_adjust_number => v_new_adj_num,
p_new_adjust_id => v_new_adj_id
);
dbms_output.put_line('Adjust Number: '||v_new_adj_num);
dbms_output.put_line('Adjust Id: '||v_new_adj_id);
end;
/