eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_BR_REMIT_IMPORT_API_PUB dependencies on AR_BATCHES

Line 22: p_media_reference OUT NOCOPY AR_BATCHES.media_reference%TYPE);

18:
19: PROCEDURE Check_BR_and_Batch_Status (p_internal_reference IN RA_CUSTOMER_TRX.Customer_trx_id%TYPE,
20: p_reserved_value OUT NOCOPY AR_PAYMENT_SCHEDULES.reserved_value%TYPE,
21: p_payment_schedule_id OUT NOCOPY AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
22: p_media_reference OUT NOCOPY AR_BATCHES.media_reference%TYPE);
23:
24: PROCEDURE compare_old_versus_new_values (
25: p_media_reference IN ar_batches.media_reference%TYPE,
26: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,

Line 25: p_media_reference IN ar_batches.media_reference%TYPE,

21: p_payment_schedule_id OUT NOCOPY AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
22: p_media_reference OUT NOCOPY AR_BATCHES.media_reference%TYPE);
23:
24: PROCEDURE compare_old_versus_new_values (
25: p_media_reference IN ar_batches.media_reference%TYPE,
26: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
27: p_remittance_method IN ar_batches.remit_method_code%TYPE,
28: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
29: p_payment_method IN ar_receipt_methods.name%TYPE,

Line 26: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,

22: p_media_reference OUT NOCOPY AR_BATCHES.media_reference%TYPE);
23:
24: PROCEDURE compare_old_versus_new_values (
25: p_media_reference IN ar_batches.media_reference%TYPE,
26: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
27: p_remittance_method IN ar_batches.remit_method_code%TYPE,
28: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
29: p_payment_method IN ar_receipt_methods.name%TYPE,
30: p_remittance_date IN ar_batches.batch_date%TYPE,

Line 27: p_remittance_method IN ar_batches.remit_method_code%TYPE,

23:
24: PROCEDURE compare_old_versus_new_values (
25: p_media_reference IN ar_batches.media_reference%TYPE,
26: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
27: p_remittance_method IN ar_batches.remit_method_code%TYPE,
28: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
29: p_payment_method IN ar_receipt_methods.name%TYPE,
30: p_remittance_date IN ar_batches.batch_date%TYPE,
31: p_Currency_code IN ar_batches.currency_code%TYPE,

Line 28: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

24: PROCEDURE compare_old_versus_new_values (
25: p_media_reference IN ar_batches.media_reference%TYPE,
26: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
27: p_remittance_method IN ar_batches.remit_method_code%TYPE,
28: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
29: p_payment_method IN ar_receipt_methods.name%TYPE,
30: p_remittance_date IN ar_batches.batch_date%TYPE,
31: p_Currency_code IN ar_batches.currency_code%TYPE,
32: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,

Line 30: p_remittance_date IN ar_batches.batch_date%TYPE,

26: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
27: p_remittance_method IN ar_batches.remit_method_code%TYPE,
28: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
29: p_payment_method IN ar_receipt_methods.name%TYPE,
30: p_remittance_date IN ar_batches.batch_date%TYPE,
31: p_Currency_code IN ar_batches.currency_code%TYPE,
32: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
33: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
34: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE

Line 31: p_Currency_code IN ar_batches.currency_code%TYPE,

27: p_remittance_method IN ar_batches.remit_method_code%TYPE,
28: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
29: p_payment_method IN ar_receipt_methods.name%TYPE,
30: p_remittance_date IN ar_batches.batch_date%TYPE,
31: p_Currency_code IN ar_batches.currency_code%TYPE,
32: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
33: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
34: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE
35: );

Line 33: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,

29: p_payment_method IN ar_receipt_methods.name%TYPE,
30: p_remittance_date IN ar_batches.batch_date%TYPE,
31: p_Currency_code IN ar_batches.currency_code%TYPE,
32: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
33: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
34: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE
35: );
36:
37:

Line 34: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE

30: p_remittance_date IN ar_batches.batch_date%TYPE,
31: p_Currency_code IN ar_batches.currency_code%TYPE,
32: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
33: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
34: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE
35: );
36:
37:
38: PROCEDURE existing_remittance (

Line 39: p_media_reference IN ar_batches.media_reference%TYPE,

35: );
36:
37:
38: PROCEDURE existing_remittance (
39: p_media_reference IN ar_batches.media_reference%TYPE,
40: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
41: p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
42: p_remittance_method IN ar_batches.remit_method_code%TYPE,
43: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

Line 40: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,

36:
37:
38: PROCEDURE existing_remittance (
39: p_media_reference IN ar_batches.media_reference%TYPE,
40: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
41: p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
42: p_remittance_method IN ar_batches.remit_method_code%TYPE,
43: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
44: p_payment_method IN ar_receipt_methods.name%TYPE,

Line 42: p_remittance_method IN ar_batches.remit_method_code%TYPE,

38: PROCEDURE existing_remittance (
39: p_media_reference IN ar_batches.media_reference%TYPE,
40: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
41: p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
42: p_remittance_method IN ar_batches.remit_method_code%TYPE,
43: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
44: p_payment_method IN ar_receipt_methods.name%TYPE,
45: p_remittance_date IN ar_batches.batch_date%TYPE,
46: p_currency_code IN ar_batches.currency_code%TYPE,

Line 43: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

39: p_media_reference IN ar_batches.media_reference%TYPE,
40: p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
41: p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
42: p_remittance_method IN ar_batches.remit_method_code%TYPE,
43: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
44: p_payment_method IN ar_receipt_methods.name%TYPE,
45: p_remittance_date IN ar_batches.batch_date%TYPE,
46: p_currency_code IN ar_batches.currency_code%TYPE,
47: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,

Line 45: p_remittance_date IN ar_batches.batch_date%TYPE,

41: p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
42: p_remittance_method IN ar_batches.remit_method_code%TYPE,
43: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
44: p_payment_method IN ar_receipt_methods.name%TYPE,
45: p_remittance_date IN ar_batches.batch_date%TYPE,
46: p_currency_code IN ar_batches.currency_code%TYPE,
47: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
48: x_return_status IN OUT NOCOPY VARCHAR2
49: );

Line 46: p_currency_code IN ar_batches.currency_code%TYPE,

42: p_remittance_method IN ar_batches.remit_method_code%TYPE,
43: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
44: p_payment_method IN ar_receipt_methods.name%TYPE,
45: p_remittance_date IN ar_batches.batch_date%TYPE,
46: p_currency_code IN ar_batches.currency_code%TYPE,
47: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
48: x_return_status IN OUT NOCOPY VARCHAR2
49: );
50:

Line 53: p_media_reference IN ar_batches.media_reference%TYPE,

49: );
50:
51:
52: PROCEDURE new_remittance(
53: p_media_reference IN ar_batches.media_reference%TYPE,
54: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
55: p_remittance_Date IN ar_batches.batch_date%TYPE,
56: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
57: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

Line 54: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,

50:
51:
52: PROCEDURE new_remittance(
53: p_media_reference IN ar_batches.media_reference%TYPE,
54: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
55: p_remittance_Date IN ar_batches.batch_date%TYPE,
56: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
57: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
58: p_currency_code IN ar_batches.currency_code%TYPE,

Line 55: p_remittance_Date IN ar_batches.batch_date%TYPE,

51:
52: PROCEDURE new_remittance(
53: p_media_reference IN ar_batches.media_reference%TYPE,
54: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
55: p_remittance_Date IN ar_batches.batch_date%TYPE,
56: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
57: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
58: p_currency_code IN ar_batches.currency_code%TYPE,
59: p_remittance_method IN ar_batches.remit_method_code%TYPE,

Line 57: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

53: p_media_reference IN ar_batches.media_reference%TYPE,
54: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
55: p_remittance_Date IN ar_batches.batch_date%TYPE,
56: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
57: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
58: p_currency_code IN ar_batches.currency_code%TYPE,
59: p_remittance_method IN ar_batches.remit_method_code%TYPE,
60: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
61: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,

Line 58: p_currency_code IN ar_batches.currency_code%TYPE,

54: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
55: p_remittance_Date IN ar_batches.batch_date%TYPE,
56: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
57: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
58: p_currency_code IN ar_batches.currency_code%TYPE,
59: p_remittance_method IN ar_batches.remit_method_code%TYPE,
60: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
61: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
62: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,

Line 59: p_remittance_method IN ar_batches.remit_method_code%TYPE,

55: p_remittance_Date IN ar_batches.batch_date%TYPE,
56: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
57: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
58: p_currency_code IN ar_batches.currency_code%TYPE,
59: p_remittance_method IN ar_batches.remit_method_code%TYPE,
60: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
61: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
62: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
63: p_payment_method IN ar_receipt_methods.name%TYPE,

Line 64: x_batch_name OUT NOCOPY ar_batches.name%TYPE,

60: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
61: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
62: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
63: p_payment_method IN ar_receipt_methods.name%TYPE,
64: x_batch_name OUT NOCOPY ar_batches.name%TYPE,
65: x_return_status IN OUT NOCOPY VARCHAR2
66: );
67:
68:

Line 69: FUNCTION Remittance_Exists (p_media_reference AR_BATCHES.media_reference%TYPE) return boolean;

65: x_return_status IN OUT NOCOPY VARCHAR2
66: );
67:
68:
69: FUNCTION Remittance_Exists (p_media_reference AR_BATCHES.media_reference%TYPE) return boolean;
70: /*#
71: * Use this procedure to import a remittance and call corresponding
72: * packages to create data. It is the main procedure for the Remittance Import API.
73: * @param p_api_version API version

Line 104: p_media_reference IN ar_batches.media_reference%TYPE,

100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
102: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
103: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
104: p_media_reference IN ar_batches.media_reference%TYPE,
105: p_remittance_method IN ar_batches.remit_method_code%TYPE,
106: -- 'STANDARD' , 'FACTORING' etc.
107: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
108: p_payment_method IN ar_receipt_methods.name%TYPE,

Line 105: p_remittance_method IN ar_batches.remit_method_code%TYPE,

101: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
102: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
103: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
104: p_media_reference IN ar_batches.media_reference%TYPE,
105: p_remittance_method IN ar_batches.remit_method_code%TYPE,
106: -- 'STANDARD' , 'FACTORING' etc.
107: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
108: p_payment_method IN ar_receipt_methods.name%TYPE,
109: p_remittance_date IN ar_batches.batch_date%TYPE,

Line 107: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,

103: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
104: p_media_reference IN ar_batches.media_reference%TYPE,
105: p_remittance_method IN ar_batches.remit_method_code%TYPE,
106: -- 'STANDARD' , 'FACTORING' etc.
107: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
108: p_payment_method IN ar_receipt_methods.name%TYPE,
109: p_remittance_date IN ar_batches.batch_date%TYPE,
110: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
111: p_currency_code IN ar_batches.currency_code%TYPE,

Line 109: p_remittance_date IN ar_batches.batch_date%TYPE,

105: p_remittance_method IN ar_batches.remit_method_code%TYPE,
106: -- 'STANDARD' , 'FACTORING' etc.
107: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
108: p_payment_method IN ar_receipt_methods.name%TYPE,
109: p_remittance_date IN ar_batches.batch_date%TYPE,
110: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
111: p_currency_code IN ar_batches.currency_code%TYPE,
112: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
113: p_org_id IN Number default null,

Line 110: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,

106: -- 'STANDARD' , 'FACTORING' etc.
107: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
108: p_payment_method IN ar_receipt_methods.name%TYPE,
109: p_remittance_date IN ar_batches.batch_date%TYPE,
110: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
111: p_currency_code IN ar_batches.currency_code%TYPE,
112: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
113: p_org_id IN Number default null,
114: p_remittance_name OUT NOCOPY ar_batches.name%TYPE

Line 111: p_currency_code IN ar_batches.currency_code%TYPE,

107: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
108: p_payment_method IN ar_receipt_methods.name%TYPE,
109: p_remittance_date IN ar_batches.batch_date%TYPE,
110: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
111: p_currency_code IN ar_batches.currency_code%TYPE,
112: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
113: p_org_id IN Number default null,
114: p_remittance_name OUT NOCOPY ar_batches.name%TYPE
115: );

Line 114: p_remittance_name OUT NOCOPY ar_batches.name%TYPE

110: p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
111: p_currency_code IN ar_batches.currency_code%TYPE,
112: p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
113: p_org_id IN Number default null,
114: p_remittance_name OUT NOCOPY ar_batches.name%TYPE
115: );
116:
117: END AR_BR_REMIT_IMPORT_API_PUB;
118: