DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on FND_DATE

Line 521: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);

517: IF PG_DEBUG in ('Y','C') THEN
518: arp_debug.debug( 'converting the parameters');
519: END IF;
520:
521: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
522: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
523: l_receipt_class_id := to_number(p_receipt_class_id);
524: l_receipt_method_id := to_number(p_payment_method_id);
525: l_currency_code := p_batch_currency;

Line 522: l_batch_date := fnd_date.canonical_to_date(p_batch_date);

518: arp_debug.debug( 'converting the parameters');
519: END IF;
520:
521: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
522: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
523: l_receipt_class_id := to_number(p_receipt_class_id);
524: l_receipt_method_id := to_number(p_payment_method_id);
525: l_currency_code := p_batch_currency;
526: l_create_flag := p_create_flag;

Line 582: fnd_date.canonical_to_date(p_exchange_date),

578: l_currency_code,
579: l_approve_flag,
580: l_format_flag,
581: l_create_flag,
582: fnd_date.canonical_to_date(p_exchange_date),
583: to_number(p_exchange_rate),
584: p_exchange_rate_type,
585: o_batch_id
586: );

Line 689: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),

685: arp_debug.debug ( ' Calling select_valid_invoices..');
686: END IF;
687:
688: select_valid_invoices
689: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
690: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
691: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
692: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
693: p_trx_num_l =>p_trx_num_l,

Line 690: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),

686: END IF;
687:
688: select_valid_invoices
689: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
690: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
691: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
692: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
693: p_trx_num_l =>p_trx_num_l,
694: p_trx_num_h => p_trx_num_h,

Line 691: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),

687:
688: select_valid_invoices
689: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
690: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
691: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
692: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
693: p_trx_num_l =>p_trx_num_l,
694: p_trx_num_h => p_trx_num_h,
695: p_doc_num_l =>p_doc_num_l,

Line 692: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),

688: select_valid_invoices
689: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
690: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
691: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
692: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
693: p_trx_num_l =>p_trx_num_l,
694: p_trx_num_h => p_trx_num_h,
695: p_doc_num_l =>p_doc_num_l,
696: p_doc_num_h => p_doc_num_h,

Line 1100: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);

1096: IF PG_DEBUG in ('Y', 'C') THEN
1097: arp_debug.debug('ar_autorec_api.submit_autorec_parallel()+');
1098: END IF;
1099:
1100: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
1101: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
1102: l_receipt_class_id := to_number(p_receipt_class_id);
1103: l_receipt_method_id := to_number(p_payment_method_id);
1104: l_currency_code := p_batch_currency;

Line 1101: l_batch_date := fnd_date.canonical_to_date(p_batch_date);

1097: arp_debug.debug('ar_autorec_api.submit_autorec_parallel()+');
1098: END IF;
1099:
1100: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
1101: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
1102: l_receipt_class_id := to_number(p_receipt_class_id);
1103: l_receipt_method_id := to_number(p_payment_method_id);
1104: l_currency_code := p_batch_currency;
1105: l_create_flag := p_create_flag;

Line 1153: fnd_date.canonical_to_date(p_exchange_date),

1149: l_currency_code,
1150: l_approve_flag,
1151: l_format_flag,
1152: l_create_flag,
1153: fnd_date.canonical_to_date(p_exchange_date),
1154: to_number(p_exchange_rate),
1155: p_exchange_rate_type,
1156: o_batch_id
1157: );

Line 1211: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),

1207: process_incomplete_receipts( o_batch_id );
1208: END IF;
1209:
1210: select_valid_invoices
1211: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
1212: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
1213: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
1214: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
1215: p_trx_num_l =>p_trx_num_l,

Line 1212: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),

1208: END IF;
1209:
1210: select_valid_invoices
1211: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
1212: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
1213: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
1214: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
1215: p_trx_num_l =>p_trx_num_l,
1216: p_trx_num_h => p_trx_num_h,

Line 1213: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),

1209:
1210: select_valid_invoices
1211: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
1212: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
1213: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
1214: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
1215: p_trx_num_l =>p_trx_num_l,
1216: p_trx_num_h => p_trx_num_h,
1217: p_doc_num_l =>p_doc_num_l,

Line 1214: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),

1210: select_valid_invoices
1211: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
1212: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
1213: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
1214: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
1215: p_trx_num_l =>p_trx_num_l,
1216: p_trx_num_h => p_trx_num_h,
1217: p_doc_num_l =>p_doc_num_l,
1218: p_doc_num_h => p_doc_num_h,