DBA Data[Home] [Help]

APPS.ARP_PROCESS_BR_REMIT dependencies on RA_CUST_TRX_TYPES

Line 83: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

79: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
80: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
81: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
82: p_unsigned_flag IN varchar2,
83: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
84: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
85: p_include_unpaid_flag IN varchar2,
86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

Line 84: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

80: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
81: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
82: p_unsigned_flag IN varchar2,
83: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
84: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
85: p_include_unpaid_flag IN varchar2,
86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
88: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

Line 381: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

377: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
378: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
379: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
380: p_unsigned_flag IN varchar2,
381: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
382: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
383: p_include_unpaid_flag IN varchar2,
384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

Line 382: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

378: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
379: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
380: p_unsigned_flag IN varchar2,
381: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
382: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
383: p_include_unpaid_flag IN varchar2,
384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
386: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

Line 573: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

569: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
570: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
571: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
572: p_unsigned_flag IN varchar2,
573: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
574: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
575: p_br_sort_criteria IN varchar2,
576: p_br_order IN varchar2,
577: p_drawee_sort_criteria IN varchar2,

Line 574: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

570: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
571: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
572: p_unsigned_flag IN varchar2,
573: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
574: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
575: p_br_sort_criteria IN varchar2,
576: p_br_order IN varchar2,
577: p_drawee_sort_criteria IN varchar2,
578: p_drawee_order IN varchar2,

Line 749: 'RA_CUST_TRX_TYPES TRX_TYPE, ' ||

745: 'FROM AR_PAYMENT_SCHEDULES PS, ' ||
746: 'AR_TRANSACTION_HISTORY HS, ' ||
747: 'HZ_CUST_ACCOUNTS CUST, ' ||
748: 'HZ_PARTIES PARTY, ' ||
749: 'RA_CUST_TRX_TYPES TRX_TYPE, ' ||
750: 'RA_CUSTOMER_TRX TRX, ' ||
751: 'AP_BANK_ACCOUNTS ACC, ' ||
752: 'CE_BANK_BRANCHES_V BRANCH, ' ||
753: 'AR_TRANSACTION_HISTORY HS1 ' ||

Line 811: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

807: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
808: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
809: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
810: p_unsigned_flag IN varchar2,
811: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
812: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
813: p_include_unpaid_flag IN varchar2,
814: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
815: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

Line 812: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

808: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
809: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
810: p_unsigned_flag IN varchar2,
811: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
812: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
813: p_include_unpaid_flag IN varchar2,
814: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
815: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
816: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

Line 1037: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

1033: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1034: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1035: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1036: p_unsigned_flag IN varchar2,
1037: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
1038: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1039: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1040: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1041: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

Line 1038: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

1034: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1035: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1036: p_unsigned_flag IN varchar2,
1037: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
1038: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1039: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1040: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1041: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1042: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,

Line 1370: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

1366: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1367: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1368: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1369: p_unsigned_flag IN varchar2,
1370: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
1371: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1372: p_include_unpaid_flag IN varchar2,
1373: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1374: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

Line 1371: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

1367: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1368: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1369: p_unsigned_flag IN varchar2,
1370: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
1371: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1372: p_include_unpaid_flag IN varchar2,
1373: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1374: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1375: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,