DBA Data[Home] [Help]

APPS.ARRX_C_TRX dependencies on FND_DATE

Line 162: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);

158: l_set_of_books_id := FND_NUMBER.CANONICAL_TO_NUMBER(argument3);
159: l_chart_of_accounts_id := FND_NUMBER.CANONICAL_TO_NUMBER(argument4);
160: l_company_segment_low := argument5;
161: l_company_segment_high := argument6;
162: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);
163: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);
164: l_account_low := argument9;
165: l_account_high := argument10;
166: l_currency_code_low := argument11;

Line 163: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);

159: l_chart_of_accounts_id := FND_NUMBER.CANONICAL_TO_NUMBER(argument4);
160: l_company_segment_low := argument5;
161: l_company_segment_high := argument6;
162: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);
163: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);
164: l_account_low := argument9;
165: l_account_high := argument10;
166: l_currency_code_low := argument11;
167: l_currency_code_high := argument12;

Line 172: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument17);

168: l_batch_source_name := argument13;
169: l_transaction_type_low := argument14;
170: l_transaction_type_high := argument15;
171: l_invoice_class := argument16;
172: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument17);
173: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument18);
174: l_doc_sequence_name := argument19;
175: l_doc_sequence_num_from := argument20;
176: l_doc_sequence_num_to := argument21;

Line 173: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument18);

169: l_transaction_type_low := argument14;
170: l_transaction_type_high := argument15;
171: l_invoice_class := argument16;
172: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument17);
173: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument18);
174: l_doc_sequence_name := argument19;
175: l_doc_sequence_num_from := argument20;
176: l_doc_sequence_num_to := argument21;
177:

Line 395: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument5);

391: l_set_of_books_id := FND_NUMBER.CANONICAL_TO_NUMBER(argument1);
392: l_chart_of_accounts_id := FND_NUMBER.CANONICAL_TO_NUMBER(argument2);
393: l_completed_flag := argument3;
394: l_posted_flag := argument4;
395: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument5);
396: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument6);
397: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);
398: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);
399: l_transaction_type_low := argument9;

Line 396: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument6);

392: l_chart_of_accounts_id := FND_NUMBER.CANONICAL_TO_NUMBER(argument2);
393: l_completed_flag := argument3;
394: l_posted_flag := argument4;
395: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument5);
396: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument6);
397: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);
398: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);
399: l_transaction_type_low := argument9;
400: l_transaction_type_high := argument10;

Line 397: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);

393: l_completed_flag := argument3;
394: l_posted_flag := argument4;
395: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument5);
396: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument6);
397: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);
398: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);
399: l_transaction_type_low := argument9;
400: l_transaction_type_high := argument10;
401: l_currency_code_low := argument11;

Line 398: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);

394: l_posted_flag := argument4;
395: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument5);
396: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument6);
397: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);
398: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);
399: l_transaction_type_low := argument9;
400: l_transaction_type_high := argument10;
401: l_currency_code_low := argument11;
402: l_currency_code_high := argument12;

Line 414: l_start_update_date := FND_DATE.CANONICAL_TO_DATE(argument20);

410:
411: --
412: -- Plug In Parameter
413: --
414: l_start_update_date := FND_DATE.CANONICAL_TO_DATE(argument20);
415: l_end_update_date := FND_DATE.CANONICAL_TO_DATE(argument21);
416: IF argument22 is not null THEN
417: select user_id
418: into l_last_updated_by

Line 415: l_end_update_date := FND_DATE.CANONICAL_TO_DATE(argument21);

411: --
412: -- Plug In Parameter
413: --
414: l_start_update_date := FND_DATE.CANONICAL_TO_DATE(argument20);
415: l_end_update_date := FND_DATE.CANONICAL_TO_DATE(argument21);
416: IF argument22 is not null THEN
417: select user_id
418: into l_last_updated_by
419: from fnd_user

Line 606: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument5);

602: l_set_of_books_id := FND_NUMBER.CANONICAL_TO_NUMBER(argument1);
603: l_chart_of_accounts_id := FND_NUMBER.CANONICAL_TO_NUMBER(argument2);
604: l_completed_flag := argument3;
605: l_posted_flag := argument4;
606: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument5);
607: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument6);
608: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);
609: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);
610: l_transaction_type_low := argument9;

Line 607: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument6);

603: l_chart_of_accounts_id := FND_NUMBER.CANONICAL_TO_NUMBER(argument2);
604: l_completed_flag := argument3;
605: l_posted_flag := argument4;
606: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument5);
607: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument6);
608: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);
609: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);
610: l_transaction_type_low := argument9;
611: l_transaction_type_high := argument10;

Line 608: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);

604: l_completed_flag := argument3;
605: l_posted_flag := argument4;
606: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument5);
607: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument6);
608: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);
609: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);
610: l_transaction_type_low := argument9;
611: l_transaction_type_high := argument10;
612: l_currency_code_low := argument11;

Line 609: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);

605: l_posted_flag := argument4;
606: l_gl_date_low := FND_DATE.CANONICAL_TO_DATE(argument5);
607: l_gl_date_high := FND_DATE.CANONICAL_TO_DATE(argument6);
608: l_transaction_date_low := FND_DATE.CANONICAL_TO_DATE(argument7);
609: l_transaction_date_high := FND_DATE.CANONICAL_TO_DATE(argument8);
610: l_transaction_type_low := argument9;
611: l_transaction_type_high := argument10;
612: l_currency_code_low := argument11;
613: l_currency_code_high := argument12;

Line 625: l_start_due_date := FND_DATE.CANONICAL_TO_DATE(argument23);

621:
622: --
623: -- Plug In Parameter
624: --
625: l_start_due_date := FND_DATE.CANONICAL_TO_DATE(argument23);
626: l_end_due_date := FND_DATE.CANONICAL_TO_DATE(argument24);
627:
628: --
629: -- Run report

Line 626: l_end_due_date := FND_DATE.CANONICAL_TO_DATE(argument24);

622: --
623: -- Plug In Parameter
624: --
625: l_start_due_date := FND_DATE.CANONICAL_TO_DATE(argument23);
626: l_end_due_date := FND_DATE.CANONICAL_TO_DATE(argument24);
627:
628: --
629: -- Run report
630: arrx_tx.artx_rep_forecast(

Line 832: l_start_gl_date := FND_DATE.CANONICAL_TO_DATE(argument4);

828: l_end_invoice_num := argument10;
829: l_doc_sequence_name := argument11;
830: l_start_doc_sequence_value := FND_NUMBER.CANONICAL_TO_NUMBER(argument12);
831: l_end_doc_sequence_value := FND_NUMBER.CANONICAL_TO_NUMBER(argument13);
832: l_start_gl_date := FND_DATE.CANONICAL_TO_DATE(argument4);
833: l_end_gl_date := FND_DATE.CANONICAL_TO_DATE(argument5);
834: l_start_company_segment := argument14;
835: l_end_company_segment := argument15;
836: l_start_rec_nat_acct := argument16;

Line 833: l_end_gl_date := FND_DATE.CANONICAL_TO_DATE(argument5);

829: l_doc_sequence_name := argument11;
830: l_start_doc_sequence_value := FND_NUMBER.CANONICAL_TO_NUMBER(argument12);
831: l_end_doc_sequence_value := FND_NUMBER.CANONICAL_TO_NUMBER(argument13);
832: l_start_gl_date := FND_DATE.CANONICAL_TO_DATE(argument4);
833: l_end_gl_date := FND_DATE.CANONICAL_TO_DATE(argument5);
834: l_start_company_segment := argument14;
835: l_end_company_segment := argument15;
836: l_start_rec_nat_acct := argument16;
837: l_end_rec_nat_acct := argument17;