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.ARP_RW_ICR_REMIT_PKG dependencies on AR_CASH_REMIT_REFS_ALL

Line 29: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,

25: +===========================================================================*/
26:
27:
28: PROCEDURE update_row(
29: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
30: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
31: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
32: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
33: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

Line 30: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,

26:
27:
28: PROCEDURE update_row(
29: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
30: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
31: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
32: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
33: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
34: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

Line 31: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,

27:
28: PROCEDURE update_row(
29: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
30: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
31: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
32: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
33: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
34: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
35: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

Line 32: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,

28: PROCEDURE update_row(
29: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
30: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
31: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
32: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
33: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
34: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
35: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
36: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

Line 33: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

29: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
30: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
31: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
32: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
33: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
34: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
35: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
36: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
37: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

Line 34: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

30: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
31: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
32: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
33: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
34: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
35: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
36: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
37: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
38: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

Line 35: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

31: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
32: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
33: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
34: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
35: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
36: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
37: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
38: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
39: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

Line 36: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

32: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
33: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
34: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
35: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
36: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
37: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
38: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
39: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
40: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

Line 37: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

33: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
34: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
35: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
36: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
37: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
38: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
39: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
40: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
41: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

Line 38: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

34: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
35: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
36: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
37: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
38: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
39: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
40: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
41: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
42: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

Line 39: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

35: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
36: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
37: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
38: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
39: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
40: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
41: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
42: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
43: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

Line 40: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

36: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
37: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
38: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
39: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
40: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
41: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
42: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
43: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
44: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

Line 41: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

37: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
38: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
39: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
40: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
41: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
42: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
43: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
44: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
45: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

Line 42: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

38: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
39: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
40: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
41: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
42: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
43: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
44: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
45: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
46: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

Line 43: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

39: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
40: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
41: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
42: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
43: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
44: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
45: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
46: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
47: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

Line 44: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

40: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
41: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
42: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
43: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
44: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
45: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
46: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
47: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
48: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

Line 45: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

41: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
42: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
43: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
44: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
45: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
46: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
47: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
48: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
49: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

Line 46: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

42: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
43: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
44: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
45: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
46: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
47: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
48: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
49: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
50: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

Line 47: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

43: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
44: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
45: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
46: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
47: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
48: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
49: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
50: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
51: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

Line 48: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

44: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
45: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
46: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
47: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
48: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
49: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
50: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
51: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
52: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

Line 49: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

45: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
46: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
47: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
48: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
49: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
50: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
51: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
52: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
53: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

Line 50: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

46: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
47: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
48: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
49: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
50: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
51: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
52: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
53: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
54: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

Line 51: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

47: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
48: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
49: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
50: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
51: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
52: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
53: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
54: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
55: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

Line 52: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

48: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
49: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
50: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
51: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
52: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
53: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
54: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
55: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
56: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

Line 53: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

49: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
50: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
51: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
52: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
53: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
54: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
55: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
56: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
57: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

Line 54: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

50: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
51: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
52: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
53: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
54: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
55: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
56: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
57: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
58: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE ) IS

Line 55: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

51: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
52: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
53: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
54: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
55: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
56: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
57: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
58: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE ) IS
59: --

Line 56: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

52: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
53: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
54: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
55: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
56: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
57: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
58: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE ) IS
59: --
60: l_icr_rec ar_interim_cash_receipts%ROWTYPE;

Line 57: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

53: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
54: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
55: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
56: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
57: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
58: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE ) IS
59: --
60: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
61: BEGIN

Line 58: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE ) IS

54: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
55: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
56: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
57: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
58: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE ) IS
59: --
60: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
61: BEGIN
62: IF PG_DEBUG in ('Y', 'C') THEN

Line 66: UPDATE AR_CASH_REMIT_REFS_ALL

62: IF PG_DEBUG in ('Y', 'C') THEN
63: arp_util.debug( 'arp_rw_icr_remit_pkg.update_row()+' );
64: END IF;
65:
66: UPDATE AR_CASH_REMIT_REFS_ALL
67: SET
68: REMIT_REFERENCE_ID = P_REMIT_REFERENCE_ID,
69: AUTOMATCH_SET_ID = P_AUTOMATCH_SET_ID,
70: CASH_RECEIPT_ID = P_CASH_RECEIPT_ID,

Line 119: | insert_row - Inserts a row into the AR_CASH_REMIT_REFS_ALL table |

115: --
116:
117: /*===========================================================================+
118: | PROCEDURE |
119: | insert_row - Inserts a row into the AR_CASH_REMIT_REFS_ALL table |
120: | |
121: | |
122: | DESCRIPTION |
123: | |

Line 133: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,

129: | |
130: | MODIFICATION HISTORY - |
131: +===========================================================================*/
132: PROCEDURE insert_row(
133: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
134: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
135: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
136: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
137: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

Line 134: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,

130: | MODIFICATION HISTORY - |
131: +===========================================================================*/
132: PROCEDURE insert_row(
133: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
134: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
135: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
136: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
137: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
138: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

Line 135: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,

131: +===========================================================================*/
132: PROCEDURE insert_row(
133: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
134: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
135: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
136: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
137: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
138: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
139: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

Line 136: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,

132: PROCEDURE insert_row(
133: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
134: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
135: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
136: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
137: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
138: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
139: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
140: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

Line 137: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

133: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
134: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
135: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
136: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
137: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
138: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
139: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
140: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
141: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

Line 138: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

134: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
135: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
136: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
137: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
138: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
139: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
140: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
141: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
142: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

Line 139: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

135: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
136: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
137: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
138: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
139: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
140: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
141: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
142: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
143: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

Line 140: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

136: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
137: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
138: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
139: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
140: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
141: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
142: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
143: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
144: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

Line 141: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

137: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
138: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
139: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
140: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
141: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
142: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
143: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
144: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
145: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

Line 142: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

138: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
139: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
140: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
141: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
142: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
143: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
144: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
145: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
146: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

Line 143: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

139: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
140: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
141: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
142: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
143: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
144: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
145: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
146: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
147: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

Line 144: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

140: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
141: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
142: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
143: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
144: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
145: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
146: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
147: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
148: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

Line 145: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

141: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
142: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
143: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
144: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
145: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
146: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
147: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
148: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
149: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

Line 146: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

142: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
143: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
144: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
145: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
146: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
147: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
148: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
149: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
150: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

Line 147: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

143: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
144: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
145: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
146: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
147: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
148: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
149: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
150: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
151: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

Line 148: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

144: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
145: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
146: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
147: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
148: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
149: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
150: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
151: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
152: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

Line 149: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

145: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
146: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
147: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
148: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
149: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
150: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
151: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
152: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
153: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

Line 150: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

146: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
147: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
148: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
149: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
150: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
151: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
152: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
153: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
154: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

Line 151: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

147: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
148: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
149: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
150: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
151: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
152: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
153: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
154: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
155: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

Line 152: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

148: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
149: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
150: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
151: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
152: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
153: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
154: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
155: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
156: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

Line 153: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

149: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
150: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
151: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
152: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
153: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
154: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
155: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
156: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
157: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

Line 154: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

150: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
151: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
152: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
153: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
154: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
155: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
156: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
157: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
158: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

Line 155: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

151: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
152: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
153: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
154: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
155: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
156: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
157: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
158: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
159: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

Line 156: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

152: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
153: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
154: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
155: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
156: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
157: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
158: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
159: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
160: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

Line 157: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

153: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
154: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
155: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
156: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
157: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
158: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
159: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
160: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
161: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

Line 158: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

154: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
155: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
156: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
157: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
158: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
159: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
160: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
161: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
162: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,

Line 159: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

155: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
156: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
157: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
158: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
159: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
160: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
161: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
162: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,
163: P_BATCH_ID IN NUMBER DEFAULT NULL) IS

Line 160: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

156: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
157: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
158: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
159: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
160: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
161: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
162: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,
163: P_BATCH_ID IN NUMBER DEFAULT NULL) IS
164: --

Line 161: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

157: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
158: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
159: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
160: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
161: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
162: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,
163: P_BATCH_ID IN NUMBER DEFAULT NULL) IS
164: --
165: l_rr_id NUMBER;

Line 162: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,

158: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
159: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
160: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
161: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
162: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,
163: P_BATCH_ID IN NUMBER DEFAULT NULL) IS
164: --
165: l_rr_id NUMBER;
166: l_line_num NUMBER;

Line 180: INSERT INTO AR_CASH_REMIT_REFS_ALL (

176: --
177:
178:
179:
180: INSERT INTO AR_CASH_REMIT_REFS_ALL (
181: REMIT_REFERENCE_ID,
182: AUTOMATCH_SET_ID,
183: CASH_RECEIPT_ID,
184: RECEIPT_REFERENCE_STATUS,

Line 277: | delete_row - Deletes a row from the AR_CASH_REMIT_REFS_ALL table |

273: END insert_row;
274: --
275: /*===========================================================================+
276: | PROCEDURE |
277: | delete_row - Deletes a row from the AR_CASH_REMIT_REFS_ALL table |
278: | |
279: | |
280: | DESCRIPTION |
281: | This function deletes a row from AR_CASH_REMIT_REFS_ALL. |

Line 281: | This function deletes a row from AR_CASH_REMIT_REFS_ALL. |

277: | delete_row - Deletes a row from the AR_CASH_REMIT_REFS_ALL table |
278: | |
279: | |
280: | DESCRIPTION |
281: | This function deletes a row from AR_CASH_REMIT_REFS_ALL. |
282: | |
283: | |
284: | SCOPE - PUBLIC |
285: | |

Line 293: p_rr_id IN ar_cash_remit_refs_all.remit_reference_id%TYPE

289: | |
290: | MODIFICATION HISTORY - 08/08/95 - Created by Ganesh Vaidee |
291: +===========================================================================*/
292: PROCEDURE delete_row(
293: p_rr_id IN ar_cash_remit_refs_all.remit_reference_id%TYPE
294: ) IS
295: BEGIN
296: IF PG_DEBUG in ('Y', 'C') THEN
297: arp_util.debug( 'arp_rw_icr_remit_pkg.delete_row()+' );

Line 305: DELETE FROM ar_cash_remit_refs_all

301: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
302: APP_EXCEPTION.raise_exception;
303: END IF;
304:
305: DELETE FROM ar_cash_remit_refs_all
306: WHERE remit_reference_id = p_rr_id;
307:
308: IF PG_DEBUG in ('Y', 'C') THEN
309: arp_util.debug( 'arp_rw_icr_remit_pkg.delete_row(-)' );

Line 323: | lock_row - Lock a row in the AR_CASH_REMIT_REFS_ALL table |

319: END delete_row;
320: --
321: /*===========================================================================+
322: | PROCEDURE |
323: | lock_row - Lock a row in the AR_CASH_REMIT_REFS_ALL table |
324: | |
325: | DESCRIPTION |
326: | |
327: | SCOPE - PUBLIC |

Line 340: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,

336: | |
337: | MODIFICATION HISTORY - 08/08/95 - Created by Ganesh Vaidee |
338: +===========================================================================*/
339: PROCEDURE lock_row(
340: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
341: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
342: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
343: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
344: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

Line 341: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,

337: | MODIFICATION HISTORY - 08/08/95 - Created by Ganesh Vaidee |
338: +===========================================================================*/
339: PROCEDURE lock_row(
340: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
341: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
342: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
343: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
344: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
345: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

Line 342: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,

338: +===========================================================================*/
339: PROCEDURE lock_row(
340: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
341: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
342: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
343: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
344: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
345: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
346: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

Line 343: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,

339: PROCEDURE lock_row(
340: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
341: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
342: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
343: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
344: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
345: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
346: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
347: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

Line 344: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

340: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
341: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
342: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
343: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
344: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
345: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
346: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
347: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
348: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

Line 345: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

341: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
342: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
343: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
344: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
345: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
346: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
347: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
348: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
349: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

Line 346: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

342: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
343: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
344: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
345: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
346: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
347: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
348: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
349: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
350: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

Line 347: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

343: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
344: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
345: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
346: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
347: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
348: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
349: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
350: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
351: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

Line 348: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

344: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
345: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
346: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
347: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
348: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
349: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
350: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
351: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
352: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

Line 349: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

345: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
346: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
347: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
348: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
349: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
350: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
351: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
352: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
353: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

Line 350: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

346: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
347: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
348: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
349: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
350: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
351: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
352: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
353: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
354: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

Line 351: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

347: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
348: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
349: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
350: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
351: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
352: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
353: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
354: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
355: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

Line 352: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

348: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
349: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
350: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
351: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
352: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
353: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
354: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
355: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
356: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

Line 353: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

349: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
350: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
351: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
352: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
353: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
354: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
355: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
356: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
357: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

Line 354: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

350: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
351: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
352: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
353: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
354: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
355: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
356: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
357: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
358: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

Line 355: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

351: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
352: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
353: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
354: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
355: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
356: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
357: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
358: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
359: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

Line 356: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

352: --P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
353: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
354: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
355: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
356: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
357: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
358: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
359: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
360: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

Line 357: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

353: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
354: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
355: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
356: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
357: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
358: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
359: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
360: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
361: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

Line 358: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

354: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
355: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
356: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
357: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
358: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
359: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
360: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
361: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
362: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

Line 359: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

355: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
356: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
357: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
358: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
359: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
360: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
361: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
362: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
363: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

Line 360: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

356: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
357: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
358: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
359: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
360: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
361: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
362: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
363: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
364: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

Line 361: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

357: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
358: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
359: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
360: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
361: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
362: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
363: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
364: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
365: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

Line 362: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

358: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
359: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
360: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
361: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
362: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
363: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
364: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
365: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
366: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

Line 363: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

359: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
360: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
361: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
362: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
363: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
364: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
365: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
366: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
367: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

Line 364: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

360: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
361: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
362: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
363: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
364: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
365: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
366: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
367: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
368: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

Line 365: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

361: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
362: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
363: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
364: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
365: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
366: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
367: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
368: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
369: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE

Line 366: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

362: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
363: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
364: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
365: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
366: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
367: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
368: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
369: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE
370: ) IS

Line 367: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

363: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
364: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
365: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
366: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
367: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
368: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
369: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE
370: ) IS
371: CURSOR C IS

Line 368: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

364: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
365: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
366: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
367: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
368: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
369: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE
370: ) IS
371: CURSOR C IS
372: SELECT *

Line 369: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE

365: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
366: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
367: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
368: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
369: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE
370: ) IS
371: CURSOR C IS
372: SELECT *
373: FROM ar_cash_remit_refs_all

Line 373: FROM ar_cash_remit_refs_all

369: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE
370: ) IS
371: CURSOR C IS
372: SELECT *
373: FROM ar_cash_remit_refs_all
374: WHERE remit_reference_id = P_REMIT_REFERENCE_ID
375: FOR UPDATE of REMIT_REFERENCE_ID NOWAIT;
376: Recinfo C%ROWTYPE;
377: --