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_PROCESS_APPLICATION dependencies on AR_RECEIVABLE_APPLICATIONS

Line 21: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

17:
18: NULL_VAR ar_payment_schedules%ROWTYPE; /* Added for Bug 460959 for Oracle 8 */
19: --
20: FUNCTION check_reversable (
21: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
22: p_module_name IN VARCHAR2,
23: p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
24: --
25: PROCEDURE reverse_action(

Line 26: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

22: p_module_name IN VARCHAR2,
23: p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
24: --
25: PROCEDURE reverse_action(
26: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
27: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
28: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
29: p_reversal_gl_date IN DATE
30: , p_reversal_date IN DATE,

Line 36: P_RA_ID IN AR_RECEIVABLE_APPLICATIONS.RECEIVABLE_APPLICATION_ID%TYPE,

32: P_MODULE_NAME IN VARCHAR2,
33: P_MODULE_VERSION IN VARCHAR2 );
34: --
35: PROCEDURE VALIDATE_ARGS(
36: P_RA_ID IN AR_RECEIVABLE_APPLICATIONS.RECEIVABLE_APPLICATION_ID%TYPE,
37: P_REVERSAL_GL_DATE IN DATE,
38: P_REVERSAL_DATE IN DATE,
39: P_MODULE_NAME IN VARCHAR2 );
40: --

Line 42: p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE

38: P_REVERSAL_DATE IN DATE,
39: P_MODULE_NAME IN VARCHAR2 );
40: --
41: PROCEDURE reversal_insert_oppos_ra_recs (
42: p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE
43: , p_app_rec_trx_type IN VARCHAR
44: , p_reversal_gl_date IN DATE
45: , p_reversal_date IN DATE
46: , p_module_name IN VARCHAR2

Line 52: , p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE

48: , p_rec_app_id OUT NOCOPY NUMBER); /* jrautiai BR implementation */
49:
50: PROCEDURE reversal_update_old_ra_rec(
51: p_reversal_gl_date DATE
52: , p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE
53: );
54:
55: PROCEDURE reversal_update_ps_recs (
56: p_ra_rec IN ar_receivable_applications%ROWTYPE

Line 56: p_ra_rec IN ar_receivable_applications%ROWTYPE

52: , p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE
53: );
54:
55: PROCEDURE reversal_update_ps_recs (
56: p_ra_rec IN ar_receivable_applications%ROWTYPE
57: , p_app_rec_trx_type IN VARCHAR
58: , p_reversal_gl_date IN DATE
59: , p_reversal_date IN DATE);
60: --

Line 62: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

58: , p_reversal_gl_date IN DATE
59: , p_reversal_date IN DATE);
60: --
61: PROCEDURE validate_reverse_action_args(
62: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
63: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
64: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
65: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
66: p_select_flag IN BOOLEAN );

Line 69: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE );

65: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
66: p_select_flag IN BOOLEAN );
67: --
68: PROCEDURE validate_args_appdel(
69: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE );
70: --
71: PROCEDURE validate_receipt_appln_args(
72: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
73: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 74: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

70: --
71: PROCEDURE validate_receipt_appln_args(
72: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
73: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
74: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
75: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
76: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
77: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
78: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 75: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,

71: PROCEDURE validate_receipt_appln_args(
72: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
73: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
74: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
75: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
76: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
77: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
78: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
79: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,

Line 76: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,

72: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
73: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
74: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
75: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
76: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
77: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
78: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
79: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
80: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,

Line 79: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,

75: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
76: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
77: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
78: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
79: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
80: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
81: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
82: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
83: --

Line 80: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,

76: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
77: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
78: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
79: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
80: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
81: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
82: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
83: --
84: PROCEDURE validate_cm_appln_args(

Line 81: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

77: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
78: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
79: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
80: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
81: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
82: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
83: --
84: PROCEDURE validate_cm_appln_args(
85: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 82: p_gl_date IN ar_receivable_applications.gl_date%TYPE );

78: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
79: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
80: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
81: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
82: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
83: --
84: PROCEDURE validate_cm_appln_args(
85: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
86: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 88: ar_receivable_applications.amount_applied%TYPE,

84: PROCEDURE validate_cm_appln_args(
85: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
86: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
87: p_amount_applied IN
88: ar_receivable_applications.amount_applied%TYPE,
89: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
90: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
91: --
92: PROCEDURE validate_on_account_args(

Line 89: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

85: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
86: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
87: p_amount_applied IN
88: ar_receivable_applications.amount_applied%TYPE,
89: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
90: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
91: --
92: PROCEDURE validate_on_account_args(
93: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 90: p_gl_date IN ar_receivable_applications.gl_date%TYPE );

86: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
87: p_amount_applied IN
88: ar_receivable_applications.amount_applied%TYPE,
89: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
90: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
91: --
92: PROCEDURE validate_on_account_args(
93: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
94: p_amount_applied IN

Line 95: ar_receivable_applications.amount_applied%TYPE,

91: --
92: PROCEDURE validate_on_account_args(
93: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
94: p_amount_applied IN
95: ar_receivable_applications.amount_applied%TYPE,
96: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
97: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
98:
99: PROCEDURE validate_activity_args(

Line 96: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

92: PROCEDURE validate_on_account_args(
93: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
94: p_amount_applied IN
95: ar_receivable_applications.amount_applied%TYPE,
96: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
97: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
98:
99: PROCEDURE validate_activity_args(
100: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 97: p_gl_date IN ar_receivable_applications.gl_date%TYPE );

93: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
94: p_amount_applied IN
95: ar_receivable_applications.amount_applied%TYPE,
96: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
97: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
98:
99: PROCEDURE validate_activity_args(
100: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
101: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

Line 101: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

97: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
98:
99: PROCEDURE validate_activity_args(
100: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
101: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
102: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
103: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
104: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
105: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 102: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,

98:
99: PROCEDURE validate_activity_args(
100: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
101: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
102: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
103: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
104: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
105: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
106: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE);

Line 103: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

99: PROCEDURE validate_activity_args(
100: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
101: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
102: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
103: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
104: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
105: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
106: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE);
107:

Line 104: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

100: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
101: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
102: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
103: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
104: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
105: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
106: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE);
107:
108: PROCEDURE validate_activity(

Line 105: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

101: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
102: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
103: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
104: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
105: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
106: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE);
107:
108: PROCEDURE validate_activity(
109: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

Line 106: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE);

102: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
103: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
104: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
105: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
106: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE);
107:
108: PROCEDURE validate_activity(
109: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
110: p_activity_type IN ar_receivables_trx.type%TYPE);

Line 109: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

105: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
106: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE);
107:
108: PROCEDURE validate_activity(
109: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
110: p_activity_type IN ar_receivables_trx.type%TYPE);
111:
112: PROCEDURE reverse_action_receipt_cb(
113: p_chargeback_customer_trx_id IN ar_receivable_applications.application_ref_id%TYPE,

Line 113: p_chargeback_customer_trx_id IN ar_receivable_applications.application_ref_id%TYPE,

109: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
110: p_activity_type IN ar_receivables_trx.type%TYPE);
111:
112: PROCEDURE reverse_action_receipt_cb(
113: p_chargeback_customer_trx_id IN ar_receivable_applications.application_ref_id%TYPE,
114: p_reversal_gl_date IN DATE,
115: p_reversal_date IN DATE,
116: p_module_name IN VARCHAR2,
117: p_module_version IN VARCHAR2);

Line 126: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,

122: , p_claim_number IN VARCHAR2
123: , p_flag IN VARCHAR2);
124:
125:
126: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,
127: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN;
128:
129: PROCEDURE reverse_action_misc_receipt(
130: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,

Line 127: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN;

123: , p_flag IN VARCHAR2);
124:
125:
126: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,
127: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN;
128:
129: PROCEDURE reverse_action_misc_receipt(
130: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,
131: p_reversal_gl_date IN DATE,

Line 130: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,

126: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,
127: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN;
128:
129: PROCEDURE reverse_action_misc_receipt(
130: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,
131: p_reversal_gl_date IN DATE,
132: p_reversal_date IN DATE,
133: p_reversal_comments IN VARCHAR2 DEFAULT NULL,
134: p_called_from IN VARCHAR2 DEFAULT NULL);

Line 166: | AR_RECEIVABLE_APPLICATIONS table |

162: | SCOPE - PUBLIC |
163: | |
164: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
165: | arp_app_pkg.fetch_p - Fetch a record from |
166: | AR_RECEIVABLE_APPLICATIONS table |
167: | arp_app_pkg.lock_p - lock a record in |
168: | AR_RECEIVABLE_APPLICATIONS table |
169: | |
170: | ARGUMENTS : IN: |

Line 168: | AR_RECEIVABLE_APPLICATIONS table |

164: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
165: | arp_app_pkg.fetch_p - Fetch a record from |
166: | AR_RECEIVABLE_APPLICATIONS table |
167: | arp_app_pkg.lock_p - lock a record in |
168: | AR_RECEIVABLE_APPLICATIONS table |
169: | |
170: | ARGUMENTS : IN: |
171: | p_ra_id - Id of application to be reversed |
172: | p_reversal_gl_date - Reversal GL date |

Line 209: l_ra_rec ar_receivable_applications%ROWTYPE;

205: , p_module_version IN VARCHAR2
206: , p_bal_due_remaining OUT NOCOPY NUMBER
207: , p_called_from IN VARCHAR2) IS /* jrautiai BR implementation */
208:
209: l_ra_rec ar_receivable_applications%ROWTYPE;
210: l_return_code VARCHAR2(20);
211: l_ps_rec ar_payment_schedules%ROWTYPE;
212: ln_batch_id NUMBER;
213: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

Line 231: -- Populate the ar_receivable_applications record from

227: validate_args( p_ra_id,
228: p_reversal_gl_date,
229: p_reversal_date, p_module_name );
230:
231: -- Populate the ar_receivable_applications record from
232: -- ar_receivable_applications table.
233:
234: --Bug:4068781
235: BEGIN

Line 232: -- ar_receivable_applications table.

228: p_reversal_gl_date,
229: p_reversal_date, p_module_name );
230:
231: -- Populate the ar_receivable_applications record from
232: -- ar_receivable_applications table.
233:
234: --Bug:4068781
235: BEGIN
236: arp_app_pkg.lock_p( p_ra_id );

Line 390: -- Update the current ar_receivable_applications record.

386: end if;
387: END IF;
388:
389: ----------------------------------------------------------
390: -- Update the current ar_receivable_applications record.
391: -- Set reversal_gl_date and display_flag to 'N'.
392: --
393: ----------------------------------------------------------
394: reversal_update_old_ra_rec( p_reversal_gl_date, l_ra_rec );

Line 399: update ar_receivable_applications

395:
396: /* Bug fix 2877224
397: Update the UNAPP record which is paired with the APP record being reversed.
398: The reversal_gl_date needs to be populated */
399: update ar_receivable_applications
400: set reversal_gl_date = p_reversal_gl_date,
401: include_in_accumulation = 'N' -- bug 6924942 --> setting accumulation flag to 'N'
402: where receivable_application_id = (select source_id
403: from ar_distributions

Line 424: update ar_receivable_applications

420: arp_debug.debug( 'gl_date = '||to_char(l_ra_rec.gl_date,'DD-MON-YYYY'));
421: arp_debug.debug( 'apply_date = '||to_char(l_ra_rec.apply_date,'DD-MON-YYYY'));
422: END IF;
423: IF l_ra_rec.trans_to_receipt_rate is NOT NULL THEN
424: update ar_receivable_applications
425: set reversal_gl_date = p_reversal_gl_date
426: where receivable_application_id = (select /*+ INDEX (AR_RECEIVABLE_APPLICATIONS_ALL AR_RECEIVABLE_APPLICATIONS_N1) */
427: max(receivable_application_id)
428: from ar_receivable_applications

Line 426: where receivable_application_id = (select /+ INDEX (AR_RECEIVABLE_APPLICATIONS_ALL AR_RECEIVABLE_APPLICATIONS_N1) /

422: END IF;
423: IF l_ra_rec.trans_to_receipt_rate is NOT NULL THEN
424: update ar_receivable_applications
425: set reversal_gl_date = p_reversal_gl_date
426: where receivable_application_id = (select /*+ INDEX (AR_RECEIVABLE_APPLICATIONS_ALL AR_RECEIVABLE_APPLICATIONS_N1) */
427: max(receivable_application_id)
428: from ar_receivable_applications
429: where cash_receipt_id = l_ra_rec.cash_receipt_id
430: and status ='UNAPP'

Line 428: from ar_receivable_applications

424: update ar_receivable_applications
425: set reversal_gl_date = p_reversal_gl_date
426: where receivable_application_id = (select /*+ INDEX (AR_RECEIVABLE_APPLICATIONS_ALL AR_RECEIVABLE_APPLICATIONS_N1) */
427: max(receivable_application_id)
428: from ar_receivable_applications
429: where cash_receipt_id = l_ra_rec.cash_receipt_id
430: and status ='UNAPP'
431: and posting_control_id = l_ra_rec.posting_control_id
432: and nvl(gl_posted_date,sysdate) = nvl(l_ra_rec.gl_posted_date, sysdate)

Line 444: update ar_receivable_applications

440: and gl_date = l_ra_rec.gl_date
441: and apply_date = l_ra_rec.apply_date
442: and reversal_gl_date is NULL);
443: ELSE
444: update ar_receivable_applications
445: set reversal_gl_date = p_reversal_gl_date
446: where receivable_application_id = (select /*+ INDEX (AR_RECEIVABLE_APPLICATIONS_ALL AR_RECEIVABLE_APPLICATIONS_N1) */
447: max(receivable_application_id)
448: from ar_receivable_applications

Line 446: where receivable_application_id = (select /+ INDEX (AR_RECEIVABLE_APPLICATIONS_ALL AR_RECEIVABLE_APPLICATIONS_N1) /

442: and reversal_gl_date is NULL);
443: ELSE
444: update ar_receivable_applications
445: set reversal_gl_date = p_reversal_gl_date
446: where receivable_application_id = (select /*+ INDEX (AR_RECEIVABLE_APPLICATIONS_ALL AR_RECEIVABLE_APPLICATIONS_N1) */
447: max(receivable_application_id)
448: from ar_receivable_applications
449: where cash_receipt_id = l_ra_rec.cash_receipt_id
450: and status ='UNAPP'

Line 448: from ar_receivable_applications

444: update ar_receivable_applications
445: set reversal_gl_date = p_reversal_gl_date
446: where receivable_application_id = (select /*+ INDEX (AR_RECEIVABLE_APPLICATIONS_ALL AR_RECEIVABLE_APPLICATIONS_N1) */
447: max(receivable_application_id)
448: from ar_receivable_applications
449: where cash_receipt_id = l_ra_rec.cash_receipt_id
450: and status ='UNAPP'
451: and posting_control_id = l_ra_rec.posting_control_id
452: and nvl(gl_posted_date,sysdate) = nvl(l_ra_rec.gl_posted_date, sysdate)

Line 498: , ar_receivable_applications ra

494: INTO
495: ln_batch_id
496: FROM
497: ar_cash_receipt_history crh
498: , ar_receivable_applications ra
499: WHERE
500: ra.receivable_application_id = p_ra_id
501: AND ra.cash_receipt_id = crh.cash_receipt_id
502: AND crh.current_record_flag = 'Y';

Line 580: AR_RECEIVABLE_APPLICATIONS table. |

576: | Reverse a credit memo application. |
577: | The algorithm for reversing an cm application is |
578: 1. Reverse existing application using opposite |
579: amounts. This is done by creating a new row into |
580: AR_RECEIVABLE_APPLICATIONS table. |
581: 2. Update applied transaction row in AR_PAYMENT_SCHEDULES |
582: | |
583: | SCOPE - PUBLIC |
584: | |

Line 587: | AR_RECEIVABLE_APPLICATIONS table

583: | SCOPE - PUBLIC |
584: | |
585: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
586: | arp_app_pkg.fetch_p - Fetch a record from
587: | AR_RECEIVABLE_APPLICATIONS table
588: | |
589: | ARGUMENTS : IN: |
590: | pn_ra_id Id of application to be reversed
591: | pd_reversal_gl_date Reversal GL date

Line 615: lr_ra_rec ar_receivable_applications%ROWTYPE;

611: , pc_module_name IN VARCHAR2
612: , pc_module_version IN VARCHAR2
613: , p_called_from IN VARCHAR2 ) IS
614:
615: lr_ra_rec ar_receivable_applications%ROWTYPE;
616: l_rec_app_id NUMBER;
617: l_trx_type VARCHAR2(20);
618:
619: -- added for unapplication of regular CM

Line 631: -- Get ready to insert application row into ar_receivable_applications.

627: arp_debug.debug( 'arp_process_application.reverse_cm_app()+' );
628: END IF;
629:
630: -- -------------------------------------------------------------------
631: -- Get ready to insert application row into ar_receivable_applications.
632: -- We use table handler to insert the record.
633: -- -------------------------------------------------------------------
634:
635: -- Populate the ar_receivable_applications record from

Line 635: -- Populate the ar_receivable_applications record from

631: -- Get ready to insert application row into ar_receivable_applications.
632: -- We use table handler to insert the record.
633: -- -------------------------------------------------------------------
634:
635: -- Populate the ar_receivable_applications record from
636: -- ar_receivable_applications table. Use ar_receivable_application_id
637: -- for selection.
638:
639: --Bug:4068781

Line 636: -- ar_receivable_applications table. Use ar_receivable_application_id

632: -- We use table handler to insert the record.
633: -- -------------------------------------------------------------------
634:
635: -- Populate the ar_receivable_applications record from
636: -- ar_receivable_applications table. Use ar_receivable_application_id
637: -- for selection.
638:
639: --Bug:4068781
640: BEGIN

Line 697: -- If status of ar_receivable_applications record is 'APP', then

693: p_inv_cust_trx_id => lr_ra_rec.applied_customer_trx_id);
694:
695: END IF;
696:
697: -- If status of ar_receivable_applications record is 'APP', then
698: -- reverse the application by updating ar_payment_schedule of the
699: -- invoice, also set actual date closed and gl_date_closed.
700:
701: IF ( NVL( lr_ra_rec.confirmed_flag, 'Y' ) = 'Y' ) THEN

Line 722: -- Update the current ar_receivable_applications record and set

718: END IF;
719:
720:
721:
722: -- Update the current ar_receivable_applications record and set
723: -- reversal_gl_date and display_flag to 'N'.
724:
725: reversal_update_old_ra_rec( pd_reversal_gl_date, lr_ra_rec );
726:

Line 727: -- Insert opposing application in ar_receivable_applications.

723: -- reversal_gl_date and display_flag to 'N'.
724:
725: reversal_update_old_ra_rec( pd_reversal_gl_date, lr_ra_rec );
726:
727: -- Insert opposing application in ar_receivable_applications.
728: -- NOTE: We are passing module name ARREREVB to simulate same effect
729: -- as reversing the receipt would cause. We are not doing the same kind
730: -- of reversing as normal application reverse is doing.
731:

Line 913: lr_ra_rec ar_receivable_applications%ROWTYPE;

909: p_global_attribute18 IN VARCHAR2,
910: p_global_attribute19 IN VARCHAR2,
911: p_global_attribute20 IN VARCHAR2 ) IS
912:
913: lr_ra_rec ar_receivable_applications%ROWTYPE;
914: functional_curr VARCHAR2(100);
915:
916: ln_amount_change NUMBER;
917: ln_cash_receipt_id NUMBER;

Line 920: l_app_ra_rec ar_receivable_applications%ROWTYPE;

916: ln_amount_change NUMBER;
917: ln_cash_receipt_id NUMBER;
918: ln_unapp_ra_id NUMBER;
919:
920: l_app_ra_rec ar_receivable_applications%ROWTYPE;
921:
922: BEGIN
923: IF PG_DEBUG in ('Y', 'C') THEN
924: arp_debug.debug( 'arp_process_application.update_selected_transaction()+');

Line 970: -- Populate the ar_receivable_applications record from

966: , 'pn_receipt_exchange_rate'
967: , 'NULL');
968: END IF;
969:
970: -- Populate the ar_receivable_applications record from
971: -- ar_receivable_applications table. Use ar_receivable_application_id
972: -- for selection.
973:
974: --Bug:4068781

Line 971: -- ar_receivable_applications table. Use ar_receivable_application_id

967: , 'NULL');
968: END IF;
969:
970: -- Populate the ar_receivable_applications record from
971: -- ar_receivable_applications table. Use ar_receivable_application_id
972: -- for selection.
973:
974: --Bug:4068781
975: BEGIN

Line 1074: from ar_receivable_applications ra

1070:
1071: -- Get the receivable application id for the UNAPP row.
1072: select ra.receivable_application_id
1073: into ln_unapp_ra_id
1074: from ar_receivable_applications ra
1075: where ra.cash_receipt_id = ln_cash_receipt_id
1076: and ra.status = 'UNAPP';
1077:
1078: --Bug:4068781

Line 1170: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

1166: | to APP_EXCEPTION.INVALID_ARGUMENT).
1167: | 2/2/1996 Harri Kaukovuo Fixed procedure to pass module name
1168: +===========================================================================*/
1169: PROCEDURE validate_args(
1170: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
1171: p_reversal_gl_date IN DATE,
1172: p_reversal_date IN DATE,
1173: p_module_name IN VARCHAR2 ) IS
1174: BEGIN

Line 1284: p_ra_rec IN ar_receivable_applications%ROWTYPE,

1280: | remaining amounts in the payment schedule
1281: | package.
1282: +===========================================================================*/
1283: PROCEDURE reversal_update_ps_recs (
1284: p_ra_rec IN ar_receivable_applications%ROWTYPE,
1285: -- Trx type is either
1286: -- AR_APP meaning that it is a cash receipt reversal
1287: -- AR_CM meaning that it is a credit memo reversal
1288: p_app_rec_trx_type IN VARCHAR,

Line 1464: | ar_receivable_applications table. |

1460: | |
1461: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1462: | ARCIAPPS.pls |
1463: | arp_app_pkg.insert_p Table handler to insert into |
1464: | ar_receivable_applications table. |
1465: | |
1466: | ARGUMENTS : IN: |
1467: | p_ra_rec Receivables application record |
1468: | p_reversal_gl_date Reversal GL date |

Line 1481: | Added second ar_receivable_applications

Line 1521: p_ra_rec IN OUT NOCOPY AR_RECEIVABLE_APPLICATIONS%ROWTYPE

1517: | 19-Dec-03 Jyoti Pandey Bug 2729626 Unapplied Amount is zero, but the
1518: | status of receipt is 'UNAPP'.
1519: +===========================================================================*/
1520: PROCEDURE reversal_insert_oppos_ra_recs (
1521: p_ra_rec IN OUT NOCOPY AR_RECEIVABLE_APPLICATIONS%ROWTYPE
1522: , p_app_rec_trx_type IN VARCHAR
1523: , p_reversal_gl_date DATE
1524: , p_reversal_date DATE
1525: , p_module_name IN VARCHAR2

Line 2094: -- They were fetched from AR_RECEIVABLE_APPLICATIONS table

2090: AND rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)
2091: AND rma.unedisc_receivables_trx_id = uned.receivables_trx_id (+);
2092:
2093: -- Remember that record fields have values already.
2094: -- They were fetched from AR_RECEIVABLE_APPLICATIONS table
2095: -- earlier in fetch_p(), in reverse procedure.
2096:
2097: -- Note that amount applied from is used if not null as this indicates
2098: -- that it is a cross currency application. For cross currency

Line 2249: from ar_receivable_applications ra

2245: considered of determining status */
2246:
2247: select nvl(sum(ra.amount_applied),0)
2248: into l_on_account_total
2249: from ar_receivable_applications ra
2250: where ra.cash_receipt_id = p_ra_rec.cash_receipt_id
2251: and ra.status IN ('ACC','OTHER ACC');
2252:
2253: IF (l_amount_due_remaining + l_on_account_total < 0)

Line 2290: | ar_receivable_applications table |

2286: | SCOPE - PUBLIC |
2287: | |
2288: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2289: | arp_app_pkg.update_p - table handler to update |
2290: | ar_receivable_applications table |
2291: | |
2292: | ARGUMENTS : IN: |
2293: | p_ra_rec - Receivables application record |
2294: | OUT: |

Line 2306: p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS

2302: | 21-Jul-97 Karen Lawrance Release 11.
2303: | Renamed procedure from modify_update_old_ra_rec
2304: +===========================================================================*/
2305: PROCEDURE reversal_update_old_ra_rec( p_reversal_gl_date DATE,
2306: p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
2307: BEGIN
2308: IF PG_DEBUG in ('Y', 'C') THEN
2309: arp_debug.debug( 'arp_process_application.reversal_update_old_ra_rec()+' );
2310: END IF;

Line 2377: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

2373: | 02-Jun-01 S.Nambiar Bug 1808020 -Modified the routine to handle |
2374: | Activity and receipt chargeback |
2375: +===========================================================================*/
2376: FUNCTION check_reversable (
2377: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2378: p_module_name IN VARCHAR2,
2379: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
2380: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2381: l_ass_cr_id ar_adjustments.associated_cash_receipt_id%TYPE;

Line 2397: l_ra_rec ar_receivable_applications%ROWTYPE;

2393: l_adj_amount NUMBER;
2394: --
2395: l_cb_count NUMBER DEFAULT 0;
2396: l_over_appln_flag CHAR(1);
2397: l_ra_rec ar_receivable_applications%ROWTYPE;
2398: l_dummy NUMBER;
2399: l_adj_amount_twb NUMBER;
2400:
2401: BEGIN

Line 2431: FROM ar_receivable_applications ra,

2427: l_bal,
2428: l_status,
2429: l_over_appln_flag,
2430: l_bal_org
2431: FROM ar_receivable_applications ra,
2432: ar_payment_schedules ps,
2433: ra_cust_trx_types ctt
2434: WHERE ra.receivable_application_id = p_ra_id
2435: AND ps.payment_schedule_id(+) = ra.applied_payment_schedule_id

Line 2469: FROM ar_receivable_applications ra,

2465: l_bal,
2466: l_status,
2467: l_over_appln_flag,
2468: l_bal_org
2469: FROM ar_receivable_applications ra,
2470: ar_payment_schedules ps,
2471: ra_cust_trx_types ctt
2472: WHERE ra.receivable_application_id = p_ra_id
2473: AND ps.customer_trx_id(+) = ra.application_ref_id

Line 2726: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS

2722: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
2723: | |
2724: +===========================================================================*/
2725: PROCEDURE validate_args_appdel(
2726: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
2727: BEGIN
2728: IF PG_DEBUG in ('Y', 'C') THEN
2729: arp_debug.debug( 'arp_process_application.validate_args_appdel()+' );
2730: END IF;

Line 2787: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

2783: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
2784: | |
2785: +===========================================================================*/
2786: PROCEDURE reverse_action(
2787: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2788: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2789: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2790: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
2791: p_select_flag IN BOOLEAN,

Line 2862: FROM ar_receivable_applications

2858: SELECT cash_receipt_id,
2859: applied_payment_schedule_id
2860: INTO l_ass_cr_id,
2861: l_ps_id
2862: FROM ar_receivable_applications
2863: WHERE receivable_application_id = p_ra_id;
2864: EXCEPTION
2865: WHEN NO_DATA_FOUND THEN
2866: IF PG_DEBUG in ('Y', 'C') THEN

Line 3099: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

3095: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
3096: | |
3097: +===========================================================================*/
3098: PROCEDURE validate_reverse_action_args(
3099: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
3100: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3101: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3102: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
3103: p_select_flag IN BOOLEAN ) IS

Line 3256: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

3252: +===========================================================================*/
3253: PROCEDURE receipt_application(
3254: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3255: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3256: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
3257: p_amount_applied_from IN
3258: ar_receivable_applications.amount_applied_from%TYPE,
3259: p_trans_to_receipt_rate IN
3260: ar_receivable_applications.trans_to_receipt_rate%TYPE,

Line 3258: ar_receivable_applications.amount_applied_from%TYPE,

3254: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3255: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3256: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
3257: p_amount_applied_from IN
3258: ar_receivable_applications.amount_applied_from%TYPE,
3259: p_trans_to_receipt_rate IN
3260: ar_receivable_applications.trans_to_receipt_rate%TYPE,
3261: p_invoice_currency_code IN
3262: ar_payment_schedules.invoice_currency_code%TYPE,

Line 3260: ar_receivable_applications.trans_to_receipt_rate%TYPE,

3256: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
3257: p_amount_applied_from IN
3258: ar_receivable_applications.amount_applied_from%TYPE,
3259: p_trans_to_receipt_rate IN
3260: ar_receivable_applications.trans_to_receipt_rate%TYPE,
3261: p_invoice_currency_code IN
3262: ar_payment_schedules.invoice_currency_code%TYPE,
3263: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
3264: p_earned_discount_taken IN

Line 3265: ar_receivable_applications.earned_discount_taken%TYPE,

3261: p_invoice_currency_code IN
3262: ar_payment_schedules.invoice_currency_code%TYPE,
3263: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
3264: p_earned_discount_taken IN
3265: ar_receivable_applications.earned_discount_taken%TYPE,
3266: p_unearned_discount_taken IN
3267: ar_receivable_applications.unearned_discount_taken%TYPE,
3268: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
3269: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 3267: ar_receivable_applications.unearned_discount_taken%TYPE,

3263: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
3264: p_earned_discount_taken IN
3265: ar_receivable_applications.earned_discount_taken%TYPE,
3266: p_unearned_discount_taken IN
3267: ar_receivable_applications.unearned_discount_taken%TYPE,
3268: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
3269: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
3270: p_ussgl_transaction_code IN
3271: ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 3268: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

3264: p_earned_discount_taken IN
3265: ar_receivable_applications.earned_discount_taken%TYPE,
3266: p_unearned_discount_taken IN
3267: ar_receivable_applications.unearned_discount_taken%TYPE,
3268: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
3269: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
3270: p_ussgl_transaction_code IN
3271: ar_receivable_applications.ussgl_transaction_code%TYPE,
3272: p_customer_trx_line_id IN

Line 3269: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

3265: ar_receivable_applications.earned_discount_taken%TYPE,
3266: p_unearned_discount_taken IN
3267: ar_receivable_applications.unearned_discount_taken%TYPE,
3268: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
3269: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
3270: p_ussgl_transaction_code IN
3271: ar_receivable_applications.ussgl_transaction_code%TYPE,
3272: p_customer_trx_line_id IN
3273: ar_receivable_applications.applied_customer_trx_line_id%TYPE,

Line 3271: ar_receivable_applications.ussgl_transaction_code%TYPE,

3267: ar_receivable_applications.unearned_discount_taken%TYPE,
3268: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
3269: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
3270: p_ussgl_transaction_code IN
3271: ar_receivable_applications.ussgl_transaction_code%TYPE,
3272: p_customer_trx_line_id IN
3273: ar_receivable_applications.applied_customer_trx_line_id%TYPE,
3274: p_application_ref_type IN
3275: ar_receivable_applications.application_ref_type%TYPE,

Line 3273: ar_receivable_applications.applied_customer_trx_line_id%TYPE,

3269: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
3270: p_ussgl_transaction_code IN
3271: ar_receivable_applications.ussgl_transaction_code%TYPE,
3272: p_customer_trx_line_id IN
3273: ar_receivable_applications.applied_customer_trx_line_id%TYPE,
3274: p_application_ref_type IN
3275: ar_receivable_applications.application_ref_type%TYPE,
3276: p_application_ref_id IN
3277: ar_receivable_applications.application_ref_id%TYPE,

Line 3275: ar_receivable_applications.application_ref_type%TYPE,

3271: ar_receivable_applications.ussgl_transaction_code%TYPE,
3272: p_customer_trx_line_id IN
3273: ar_receivable_applications.applied_customer_trx_line_id%TYPE,
3274: p_application_ref_type IN
3275: ar_receivable_applications.application_ref_type%TYPE,
3276: p_application_ref_id IN
3277: ar_receivable_applications.application_ref_id%TYPE,
3278: p_application_ref_num IN
3279: ar_receivable_applications.application_ref_num%TYPE,

Line 3277: ar_receivable_applications.application_ref_id%TYPE,

3273: ar_receivable_applications.applied_customer_trx_line_id%TYPE,
3274: p_application_ref_type IN
3275: ar_receivable_applications.application_ref_type%TYPE,
3276: p_application_ref_id IN
3277: ar_receivable_applications.application_ref_id%TYPE,
3278: p_application_ref_num IN
3279: ar_receivable_applications.application_ref_num%TYPE,
3280: p_secondary_application_ref_id IN
3281: ar_receivable_applications.secondary_application_ref_id%TYPE,

Line 3279: ar_receivable_applications.application_ref_num%TYPE,

3275: ar_receivable_applications.application_ref_type%TYPE,
3276: p_application_ref_id IN
3277: ar_receivable_applications.application_ref_id%TYPE,
3278: p_application_ref_num IN
3279: ar_receivable_applications.application_ref_num%TYPE,
3280: p_secondary_application_ref_id IN
3281: ar_receivable_applications.secondary_application_ref_id%TYPE,
3282: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3283: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

Line 3281: ar_receivable_applications.secondary_application_ref_id%TYPE,

3277: ar_receivable_applications.application_ref_id%TYPE,
3278: p_application_ref_num IN
3279: ar_receivable_applications.application_ref_num%TYPE,
3280: p_secondary_application_ref_id IN
3281: ar_receivable_applications.secondary_application_ref_id%TYPE,
3282: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3283: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3284: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3285: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

Line 3282: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,

3278: p_application_ref_num IN
3279: ar_receivable_applications.application_ref_num%TYPE,
3280: p_secondary_application_ref_id IN
3281: ar_receivable_applications.secondary_application_ref_id%TYPE,
3282: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3283: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3284: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3285: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3286: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

Line 3283: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

3279: ar_receivable_applications.application_ref_num%TYPE,
3280: p_secondary_application_ref_id IN
3281: ar_receivable_applications.secondary_application_ref_id%TYPE,
3282: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3283: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3284: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3285: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3286: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3287: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

Line 3284: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

3280: p_secondary_application_ref_id IN
3281: ar_receivable_applications.secondary_application_ref_id%TYPE,
3282: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3283: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3284: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3285: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3286: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3287: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3288: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

Line 3285: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

3281: ar_receivable_applications.secondary_application_ref_id%TYPE,
3282: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3283: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3284: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3285: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3286: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3287: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3288: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3289: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

Line 3286: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

3282: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3283: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3284: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3285: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3286: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3287: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3288: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3289: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3290: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

Line 3287: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

3283: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3284: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3285: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3286: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3287: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3288: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3289: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3290: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3291: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

Line 3288: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

3284: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3285: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3286: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3287: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3288: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3289: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3290: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3291: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3292: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

Line 3289: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

3285: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3286: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3287: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3288: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3289: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3290: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3291: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3292: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3293: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

Line 3290: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

3286: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3287: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3288: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3289: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3290: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3291: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3292: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3293: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3294: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

Line 3291: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

3287: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3288: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3289: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3290: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3291: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3292: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3293: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3294: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3295: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

Line 3292: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

3288: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3289: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3290: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3291: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3292: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3293: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3294: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3295: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3296: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

Line 3293: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

3289: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3290: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3291: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3292: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3293: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3294: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3295: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3296: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3297: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

Line 3294: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

3290: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3291: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3292: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3293: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3294: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3295: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3296: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3297: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3298: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

Line 3295: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

3291: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3292: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3293: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3294: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3295: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3296: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3297: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3298: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3299: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

Line 3296: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

3292: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3293: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3294: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3295: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3296: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3297: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3298: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3299: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3300: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

Line 3297: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

3293: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3294: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3295: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3296: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3297: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3298: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3299: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3300: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3301: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

Line 3298: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

3294: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3295: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3296: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3297: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3298: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3299: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3300: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3301: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3302: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

Line 3299: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

3295: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3296: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3297: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3298: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3299: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3300: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3301: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3302: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3303: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

Line 3300: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

3296: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3297: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3298: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3299: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3300: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3301: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3302: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3303: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3304: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

Line 3301: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

3297: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3298: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3299: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3300: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3301: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3302: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3303: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3304: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3305: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

Line 3302: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

3298: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3299: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3300: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3301: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3302: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3303: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3304: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3305: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3306: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

Line 3303: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

3299: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3300: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3301: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3302: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3303: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3304: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3305: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3306: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3307: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

Line 3304: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

3300: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3301: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3302: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3303: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3304: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3305: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3306: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3307: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3308: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

Line 3305: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

3301: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3302: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3303: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3304: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3305: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3306: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3307: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3308: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3309: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

Line 3306: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

3302: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3303: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3304: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3305: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3306: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3307: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3308: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3309: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3310: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

Line 3307: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

3303: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3304: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3305: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3306: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3307: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3308: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3309: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3310: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3311: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

Line 3308: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

3304: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3305: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3306: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3307: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3308: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3309: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3310: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3311: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3312: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

Line 3309: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

3305: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3306: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3307: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3308: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3309: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3310: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3311: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3312: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3313: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

Line 3310: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

3306: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3307: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3308: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3309: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3310: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3311: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3312: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3313: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3314: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

Line 3311: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

3307: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3308: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3309: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3310: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3311: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3312: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3313: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3314: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3315: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

Line 3312: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

3308: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3309: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3310: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3311: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3312: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3313: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3314: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3315: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3316: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

Line 3313: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

3309: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3310: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3311: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3312: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3313: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3314: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3315: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3316: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3317: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

Line 3314: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

3310: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3311: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3312: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3313: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3314: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3315: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3316: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3317: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3318: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

Line 3315: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

3311: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3312: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3313: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3314: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3315: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3316: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3317: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3318: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
3319: p_comments IN ar_receivable_applications.comments%TYPE,

Line 3316: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

3312: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3313: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3314: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3315: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3316: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3317: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3318: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
3319: p_comments IN ar_receivable_applications.comments%TYPE,
3320: p_module_name IN VARCHAR2,

Line 3317: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

3313: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3314: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3315: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3316: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3317: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3318: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
3319: p_comments IN ar_receivable_applications.comments%TYPE,
3320: p_module_name IN VARCHAR2,
3321: p_module_version IN VARCHAR2,

Line 3318: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

3314: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3315: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3316: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3317: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3318: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
3319: p_comments IN ar_receivable_applications.comments%TYPE,
3320: p_module_name IN VARCHAR2,
3321: p_module_version IN VARCHAR2,
3322: -- OUT NOCOPY

Line 3319: p_comments IN ar_receivable_applications.comments%TYPE,

3315: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3316: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3317: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3318: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
3319: p_comments IN ar_receivable_applications.comments%TYPE,
3320: p_module_name IN VARCHAR2,
3321: p_module_version IN VARCHAR2,
3322: -- OUT NOCOPY
3323: x_application_ref_id OUT NOCOPY

Line 3324: ar_receivable_applications.application_ref_id%TYPE,

3320: p_module_name IN VARCHAR2,
3321: p_module_version IN VARCHAR2,
3322: -- OUT NOCOPY
3323: x_application_ref_id OUT NOCOPY
3324: ar_receivable_applications.application_ref_id%TYPE,
3325: x_application_ref_num OUT NOCOPY
3326: ar_receivable_applications.application_ref_num%TYPE,
3327: x_return_status OUT NOCOPY VARCHAR2,
3328: x_msg_count OUT NOCOPY NUMBER,

Line 3326: ar_receivable_applications.application_ref_num%TYPE,

3322: -- OUT NOCOPY
3323: x_application_ref_id OUT NOCOPY
3324: ar_receivable_applications.application_ref_id%TYPE,
3325: x_application_ref_num OUT NOCOPY
3326: ar_receivable_applications.application_ref_num%TYPE,
3327: x_return_status OUT NOCOPY VARCHAR2,
3328: x_msg_count OUT NOCOPY NUMBER,
3329: x_msg_data OUT NOCOPY VARCHAR2,
3330: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

Line 3330: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

3326: ar_receivable_applications.application_ref_num%TYPE,
3327: x_return_status OUT NOCOPY VARCHAR2,
3328: x_msg_count OUT NOCOPY NUMBER,
3329: x_msg_data OUT NOCOPY VARCHAR2,
3330: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
3331: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
3332: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
3333: x_claim_reason_name OUT NOCOPY VARCHAR2,
3334: p_called_from IN VARCHAR2, /* jrautiai BR implementation */

Line 3331: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,

3327: x_return_status OUT NOCOPY VARCHAR2,
3328: x_msg_count OUT NOCOPY NUMBER,
3329: x_msg_data OUT NOCOPY VARCHAR2,
3330: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
3331: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
3332: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
3333: x_claim_reason_name OUT NOCOPY VARCHAR2,
3334: p_called_from IN VARCHAR2, /* jrautiai BR implementation */
3335: p_move_deferred_tax IN VARCHAR2, /* jrautiai BR implementation */

Line 3332: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

3328: x_msg_count OUT NOCOPY NUMBER,
3329: x_msg_data OUT NOCOPY VARCHAR2,
3330: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
3331: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
3332: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
3333: x_claim_reason_name OUT NOCOPY VARCHAR2,
3334: p_called_from IN VARCHAR2, /* jrautiai BR implementation */
3335: p_move_deferred_tax IN VARCHAR2, /* jrautiai BR implementation */
3336: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */

Line 3336: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */

3332: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
3333: x_claim_reason_name OUT NOCOPY VARCHAR2,
3334: p_called_from IN VARCHAR2, /* jrautiai BR implementation */
3335: p_move_deferred_tax IN VARCHAR2, /* jrautiai BR implementation */
3336: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */
3337: p_amount_due_remaining IN
3338: ar_payment_schedules.amount_due_remaining%TYPE,
3339: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3340: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,

Line 3339: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,

3335: p_move_deferred_tax IN VARCHAR2, /* jrautiai BR implementation */
3336: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */
3337: p_amount_due_remaining IN
3338: ar_payment_schedules.amount_due_remaining%TYPE,
3339: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3340: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
3341: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
3342: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
3343: from_llca_call IN VARCHAR2 DEFAULT 'N',

Line 3340: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,

3336: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */
3337: p_amount_due_remaining IN
3338: ar_payment_schedules.amount_due_remaining%TYPE,
3339: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3340: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
3341: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
3342: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
3343: from_llca_call IN VARCHAR2 DEFAULT 'N',
3344: p_gt_id IN NUMBER DEFAULT NULL

Line 3341: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,

3337: p_amount_due_remaining IN
3338: ar_payment_schedules.amount_due_remaining%TYPE,
3339: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3340: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
3341: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
3342: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
3343: from_llca_call IN VARCHAR2 DEFAULT 'N',
3344: p_gt_id IN NUMBER DEFAULT NULL
3345: ) IS

Line 3342: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,

3338: ar_payment_schedules.amount_due_remaining%TYPE,
3339: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3340: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
3341: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
3342: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
3343: from_llca_call IN VARCHAR2 DEFAULT 'N',
3344: p_gt_id IN NUMBER DEFAULT NULL
3345: ) IS
3346:

Line 3347: l_rec_ra_rec ar_receivable_applications%ROWTYPE;

3343: from_llca_call IN VARCHAR2 DEFAULT 'N',
3344: p_gt_id IN NUMBER DEFAULT NULL
3345: ) IS
3346:
3347: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
3348: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
3349:
3350: l_cr_rec ar_cash_receipts%ROWTYPE;
3351: l_amount_due_remaining NUMBER;

Line 3348: l_inv_ra_rec ar_receivable_applications%ROWTYPE;

3344: p_gt_id IN NUMBER DEFAULT NULL
3345: ) IS
3346:
3347: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
3348: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
3349:
3350: l_cr_rec ar_cash_receipts%ROWTYPE;
3351: l_amount_due_remaining NUMBER;
3352: ln_batch_id NUMBER;

Line 3491: from ar_receivable_applications rap

3487: BEGIN
3488: IF p_customer_trx_line_id IS NULL THEN
3489: select 'Y'
3490: into l_found
3491: from ar_receivable_applications rap
3492: where rap.payment_schedule_id = p_receipt_ps_id
3493: and rap.applied_payment_schedule_id = p_invoice_ps_id
3494: and rap.display = 'Y'
3495: and rap.status = 'APP';

Line 3499: from ar_receivable_applications rap

3495: and rap.status = 'APP';
3496: ELSE
3497: select 'Y'
3498: into l_found
3499: from ar_receivable_applications rap
3500: where rap.payment_schedule_id = p_receipt_ps_id
3501: and rap.applied_payment_schedule_id = p_invoice_ps_id
3502: and rap.applied_customer_trx_line_id = p_customer_trx_line_id
3503: and rap.display = 'Y'

Line 3694: from ar_receivable_applications rap

3690:
3691: BEGIN
3692: select count(*)
3693: into l_count
3694: from ar_receivable_applications rap
3695: where rap.cash_receipt_id = l_rec_ra_rec.cash_receipt_id
3696: and rap.secondary_application_ref_id =
3697: p_secondary_application_ref_id
3698: and rap.application_ref_type = 'CLAIM'

Line 3894: UPDATE ar_receivable_applications

3890: END IF;
3891:
3892: -- Bug 6924942 - Start
3893: IF l_class_var IN ('CM', 'PMT') THEN
3894: UPDATE ar_receivable_applications
3895: SET include_in_accumulation = 'N'
3896: WHERE cash_receipt_id = l_rec_ra_rec.cash_receipt_id
3897: AND status = 'UNAPP'
3898: AND include_in_accumulation <> 'N';

Line 4369: from ar_receivable_applications ra

4365: --No need to execute the SQL if the call is from Autoreceipts [Bug 6660834]
4366: IF nvl(p_called_from,'NONE') NOT IN ('AUTORECAPI','AUTORECAPI2') THEN
4367: select nvl(sum(ra.amount_applied),0)
4368: into l_on_account_total
4369: from ar_receivable_applications ra
4370: where ra.cash_receipt_id = l_rec_ra_rec.cash_receipt_id
4371: and ra.status IN ('ACC','OTHER ACC');
4372: END IF;
4373:

Line 4516: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

4512: +===========================================================================*/
4513: PROCEDURE validate_receipt_appln_args(
4514: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4515: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4516: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4517: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4518: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4519: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4520: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 4517: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,

4513: PROCEDURE validate_receipt_appln_args(
4514: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4515: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4516: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4517: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4518: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4519: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4520: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4521: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,

Line 4518: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,

4514: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4515: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4516: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4517: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4518: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4519: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4520: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4521: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4522: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,

Line 4521: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,

4517: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4518: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4519: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4520: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4521: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4522: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4523: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4524: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4525: BEGIN

Line 4522: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,

4518: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4519: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4520: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4521: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4522: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4523: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4524: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4525: BEGIN
4526: IF PG_DEBUG in ('Y', 'C') THEN

Line 4523: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

4519: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4520: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4521: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4522: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4523: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4524: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4525: BEGIN
4526: IF PG_DEBUG in ('Y', 'C') THEN
4527: arp_debug.debug( 'arp_process_application.validate_receipt_appln_args()+' );

Line 4524: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS

4520: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4521: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4522: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4523: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4524: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4525: BEGIN
4526: IF PG_DEBUG in ('Y', 'C') THEN
4527: arp_debug.debug( 'arp_process_application.validate_receipt_appln_args()+' );
4528: END IF;

Line 4632: | mrc data for ar_receivable_applications

Line 4641: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

4637: +===========================================================================*/
4638: PROCEDURE cm_application(
4639: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4640: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4641: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4642: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4643: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4644: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4645: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,

Line 4642: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

4638: PROCEDURE cm_application(
4639: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4640: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4641: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4642: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4643: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4644: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4645: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4646: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

Line 4643: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

4639: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4640: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4641: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4642: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4643: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4644: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4645: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4646: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4647: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

Line 4644: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

4640: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4641: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4642: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4643: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4644: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4645: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4646: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4647: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4648: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

Line 4645: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,

4641: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4642: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4643: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4644: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4645: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4646: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4647: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4648: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4649: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

Line 4646: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

4642: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4643: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4644: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4645: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4646: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4647: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4648: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4649: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4650: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

Line 4647: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

4643: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4644: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4645: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4646: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4647: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4648: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4649: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4650: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4651: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

Line 4648: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

4644: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4645: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4646: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4647: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4648: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4649: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4650: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4651: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4652: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

Line 4649: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

4645: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4646: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4647: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4648: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4649: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4650: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4651: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4652: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4653: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

Line 4650: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

4646: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4647: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4648: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4649: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4650: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4651: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4652: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4653: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4654: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

Line 4651: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

4647: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4648: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4649: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4650: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4651: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4652: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4653: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4654: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4655: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

Line 4652: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

4648: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4649: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4650: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4651: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4652: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4653: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4654: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4655: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4656: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

Line 4653: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

4649: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4650: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4651: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4652: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4653: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4654: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4655: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4656: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4657: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

Line 4654: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

4650: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4651: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4652: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4653: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4654: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4655: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4656: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4657: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4658: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

Line 4655: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

4651: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4652: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4653: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4654: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4655: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4656: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4657: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4658: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4659: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

Line 4656: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

4652: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4653: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4654: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4655: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4656: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4657: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4658: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4659: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4660: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

Line 4657: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

4653: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4654: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4655: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4656: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4657: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4658: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4659: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4660: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4661: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

Line 4658: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

4654: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4655: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4656: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4657: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4658: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4659: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4660: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4661: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4662: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

Line 4659: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

4655: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4656: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4657: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4658: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4659: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4660: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4661: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4662: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4663: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

Line 4660: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

4656: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4657: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4658: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4659: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4660: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4661: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4662: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4663: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4664: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

Line 4661: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

4657: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4658: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4659: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4660: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4661: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4662: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4663: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4664: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4665: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

Line 4662: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

4658: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4659: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4660: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4661: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4662: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4663: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4664: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4665: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4666: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

Line 4663: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

4659: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4660: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4661: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4662: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4663: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4664: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4665: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4666: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4667: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

Line 4664: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

4660: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4661: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4662: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4663: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4664: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4665: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4666: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4667: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4668: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

Line 4665: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

4661: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4662: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4663: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4664: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4665: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4666: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4667: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4668: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4669: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

Line 4666: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

4662: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4663: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4664: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4665: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4666: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4667: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4668: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4669: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4670: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

Line 4667: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

4663: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4664: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4665: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4666: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4667: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4668: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4669: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4670: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4671: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

Line 4668: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

4664: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4665: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4666: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4667: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4668: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4669: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4670: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4671: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4672: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

Line 4669: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

4665: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4666: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4667: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4668: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4669: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4670: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4671: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4672: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4673: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

Line 4670: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

4666: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4667: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4668: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4669: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4670: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4671: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4672: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4673: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4674: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

Line 4671: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

4667: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4668: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4669: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4670: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4671: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4672: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4673: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4674: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4675: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

Line 4672: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

4668: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4669: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4670: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4671: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4672: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4673: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4674: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4675: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4676: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

Line 4673: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

4669: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4670: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4671: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4672: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4673: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4674: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4675: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4676: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4677: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

Line 4674: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

4670: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4671: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4672: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4673: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4674: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4675: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4676: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4677: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4678: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

Line 4675: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

4671: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4672: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4673: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4674: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4675: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4676: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4677: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4678: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4679: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

Line 4676: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

4672: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4673: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4674: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4675: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4676: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4677: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4678: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4679: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4680: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

Line 4677: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

4673: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4674: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4675: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4676: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4677: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4678: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4679: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4680: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4681: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

Line 4678: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

4674: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4675: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4676: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4677: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4678: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4679: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4680: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4681: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4682: p_customer_trx_line_id IN NUMBER,

Line 4679: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

4675: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4676: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4677: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4678: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4679: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4680: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4681: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4682: p_customer_trx_line_id IN NUMBER,
4683: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --bug2662270

Line 4680: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

4676: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4677: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4678: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4679: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4680: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4681: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4682: p_customer_trx_line_id IN NUMBER,
4683: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --bug2662270
4684: p_module_name IN VARCHAR2,

Line 4681: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

4677: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4678: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4679: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4680: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4681: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4682: p_customer_trx_line_id IN NUMBER,
4683: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --bug2662270
4684: p_module_name IN VARCHAR2,
4685: p_module_version IN VARCHAR2,

Line 4683: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --bug2662270

4679: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4680: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4681: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4682: p_customer_trx_line_id IN NUMBER,
4683: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --bug2662270
4684: p_module_name IN VARCHAR2,
4685: p_module_version IN VARCHAR2,
4686: -- OUT NOCOPY
4687: p_out_rec_application_id OUT NOCOPY NUMBER,

Line 4688: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,

4684: p_module_name IN VARCHAR2,
4685: p_module_version IN VARCHAR2,
4686: -- OUT NOCOPY
4687: p_out_rec_application_id OUT NOCOPY NUMBER,
4688: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
4689: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE) IS
4690:
4691: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
4692: l_cm_ps_rec ar_payment_schedules%ROWTYPE;

Line 4689: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE) IS

4685: p_module_version IN VARCHAR2,
4686: -- OUT NOCOPY
4687: p_out_rec_application_id OUT NOCOPY NUMBER,
4688: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
4689: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE) IS
4690:
4691: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
4692: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
4693: l_ae_doc_rec ae_doc_rec_type;

Line 4691: l_inv_ra_rec ar_receivable_applications%ROWTYPE;

4687: p_out_rec_application_id OUT NOCOPY NUMBER,
4688: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
4689: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE) IS
4690:
4691: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
4692: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
4693: l_ae_doc_rec ae_doc_rec_type;
4694: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
4695: l_flag char; /* added for bug 2318048 */

Line 4745: from ar_receivable_applications rap

4741: BEGIN
4742: IF p_customer_trx_line_id IS NULL THEN
4743: select 'Y'
4744: into l_found
4745: from ar_receivable_applications rap
4746: where rap.payment_schedule_id = p_cm_ps_id
4747: and rap.applied_payment_schedule_id = p_invoice_ps_id
4748: and rap.display = 'Y'
4749: and rap.status = 'APP';

Line 4753: from ar_receivable_applications rap

4749: and rap.status = 'APP';
4750: ELSE
4751: select 'Y'
4752: into l_found
4753: from ar_receivable_applications rap
4754: where rap.payment_schedule_id = p_cm_ps_id
4755: and rap.applied_payment_schedule_id = p_invoice_ps_id
4756: and rap.applied_customer_trx_line_id = p_customer_trx_line_id
4757: and rap.display = 'Y'

Line 5091: ar_receivable_applications.amount_applied%TYPE,

5087: PROCEDURE validate_cm_appln_args(
5088: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5089: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5090: p_amount_applied IN
5091: ar_receivable_applications.amount_applied%TYPE,
5092: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5093: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
5094: BEGIN
5095: IF PG_DEBUG in ('Y', 'C') THEN

Line 5092: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

5088: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5089: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5090: p_amount_applied IN
5091: ar_receivable_applications.amount_applied%TYPE,
5092: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5093: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
5094: BEGIN
5095: IF PG_DEBUG in ('Y', 'C') THEN
5096: arp_debug.debug(

Line 5093: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS

5089: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5090: p_amount_applied IN
5091: ar_receivable_applications.amount_applied%TYPE,
5092: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5093: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
5094: BEGIN
5095: IF PG_DEBUG in ('Y', 'C') THEN
5096: arp_debug.debug(
5097: 'arp_process_application.validate_cm_appln_args()+' );

Line 5179: | inserts to ar_receivable_applications |

5175: | default value, hence all code calling this |
5176: | procedure and not passing comment is failing |
5177: | modify code to DEFAULT NULL |
5178: | 04-Sep-02 Debbie Jancis Added calls to mrc engine 3 for processing |
5179: | inserts to ar_receivable_applications |
5180: | 28-JUL-2003 Jon Beckett Bug 2821139 - added p_customer_reason. |
5181: +===========================================================================*/
5182: PROCEDURE on_account_receipts(
5183: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 5185: ar_receivable_applications.amount_applied%TYPE,

5181: +===========================================================================*/
5182: PROCEDURE on_account_receipts(
5183: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5184: p_amount_applied IN
5185: ar_receivable_applications.amount_applied%TYPE,
5186: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5187: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
5188: p_ussgl_transaction_code IN
5189: ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 5186: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

5182: PROCEDURE on_account_receipts(
5183: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5184: p_amount_applied IN
5185: ar_receivable_applications.amount_applied%TYPE,
5186: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5187: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
5188: p_ussgl_transaction_code IN
5189: ar_receivable_applications.ussgl_transaction_code%TYPE,
5190: p_attribute_category IN

Line 5187: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

5183: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5184: p_amount_applied IN
5185: ar_receivable_applications.amount_applied%TYPE,
5186: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5187: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
5188: p_ussgl_transaction_code IN
5189: ar_receivable_applications.ussgl_transaction_code%TYPE,
5190: p_attribute_category IN
5191: ar_receivable_applications.attribute_category%TYPE,

Line 5189: ar_receivable_applications.ussgl_transaction_code%TYPE,

5185: ar_receivable_applications.amount_applied%TYPE,
5186: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5187: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
5188: p_ussgl_transaction_code IN
5189: ar_receivable_applications.ussgl_transaction_code%TYPE,
5190: p_attribute_category IN
5191: ar_receivable_applications.attribute_category%TYPE,
5192: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
5193: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

Line 5191: ar_receivable_applications.attribute_category%TYPE,

5187: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
5188: p_ussgl_transaction_code IN
5189: ar_receivable_applications.ussgl_transaction_code%TYPE,
5190: p_attribute_category IN
5191: ar_receivable_applications.attribute_category%TYPE,
5192: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
5193: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
5194: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
5195: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

Line 5192: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

5188: p_ussgl_transaction_code IN
5189: ar_receivable_applications.ussgl_transaction_code%TYPE,
5190: p_attribute_category IN
5191: ar_receivable_applications.attribute_category%TYPE,
5192: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
5193: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
5194: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
5195: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
5196: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

Line 5193: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

5189: ar_receivable_applications.ussgl_transaction_code%TYPE,
5190: p_attribute_category IN
5191: ar_receivable_applications.attribute_category%TYPE,
5192: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
5193: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
5194: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
5195: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
5196: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
5197: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

Line 5194: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

5190: p_attribute_category IN
5191: ar_receivable_applications.attribute_category%TYPE,
5192: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
5193: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
5194: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
5195: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
5196: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
5197: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
5198: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

Line 5195: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

5191: ar_receivable_applications.attribute_category%TYPE,
5192: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
5193: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
5194: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
5195: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
5196: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
5197: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
5198: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
5199: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

Line 5196: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

5192: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
5193: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
5194: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
5195: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
5196: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
5197: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
5198: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
5199: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
5200: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

Line 5197: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

5193: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
5194: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
5195: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
5196: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
5197: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
5198: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
5199: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
5200: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
5201: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

Line 5198: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

5194: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
5195: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
5196: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
5197: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
5198: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
5199: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
5200: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
5201: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
5202: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

Line 5199: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

5195: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
5196: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
5197: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
5198: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
5199: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
5200: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
5201: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
5202: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
5203: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

Line 5200: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

5196: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
5197: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
5198: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
5199: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
5200: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
5201: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
5202: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
5203: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
5204: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

Line 5201: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

5197: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
5198: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
5199: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
5200: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
5201: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
5202: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
5203: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
5204: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
5205: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

Line 5202: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

5198: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
5199: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
5200: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
5201: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
5202: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
5203: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
5204: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
5205: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
5206: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

Line 5203: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

5199: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
5200: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
5201: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
5202: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
5203: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
5204: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
5205: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
5206: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
5207: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

Line 5204: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

5200: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
5201: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
5202: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
5203: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
5204: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
5205: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
5206: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
5207: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
5208: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

Line 5205: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

5201: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
5202: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
5203: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
5204: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
5205: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
5206: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
5207: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
5208: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
5209: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

Line 5206: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

5202: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
5203: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
5204: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
5205: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
5206: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
5207: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
5208: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
5209: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
5210: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

Line 5207: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

5203: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
5204: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
5205: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
5206: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
5207: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
5208: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
5209: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
5210: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
5211: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

Line 5208: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

5204: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
5205: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
5206: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
5207: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
5208: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
5209: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
5210: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
5211: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
5212: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

Line 5209: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

5205: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
5206: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
5207: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
5208: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
5209: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
5210: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
5211: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
5212: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
5213: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

Line 5210: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

5206: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
5207: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
5208: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
5209: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
5210: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
5211: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
5212: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
5213: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
5214: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

Line 5211: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

5207: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
5208: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
5209: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
5210: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
5211: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
5212: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
5213: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
5214: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
5215: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

Line 5212: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

5208: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
5209: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
5210: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
5211: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
5212: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
5213: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
5214: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
5215: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
5216: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

Line 5213: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

5209: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
5210: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
5211: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
5212: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
5213: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
5214: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
5215: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
5216: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
5217: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

Line 5214: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

5210: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
5211: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
5212: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
5213: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
5214: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
5215: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
5216: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
5217: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
5218: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

Line 5215: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

5211: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
5212: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
5213: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
5214: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
5215: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
5216: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
5217: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
5218: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
5219: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

Line 5216: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

5212: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
5213: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
5214: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
5215: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
5216: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
5217: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
5218: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
5219: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
5220: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

Line 5217: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

5213: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
5214: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
5215: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
5216: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
5217: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
5218: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
5219: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
5220: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
5221: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

Line 5218: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

5214: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
5215: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
5216: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
5217: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
5218: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
5219: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
5220: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
5221: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
5222: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

Line 5219: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

5215: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
5216: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
5217: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
5218: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
5219: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
5220: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
5221: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
5222: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
5223: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

Line 5220: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

5216: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
5217: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
5218: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
5219: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
5220: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
5221: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
5222: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
5223: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
5224: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

Line 5221: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

5217: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
5218: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
5219: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
5220: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
5221: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
5222: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
5223: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
5224: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
5225: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

Line 5222: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

5218: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
5219: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
5220: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
5221: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
5222: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
5223: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
5224: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
5225: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
5226: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

Line 5223: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

5219: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
5220: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
5221: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
5222: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
5223: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
5224: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
5225: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
5226: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
5227: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

Line 5224: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

5220: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
5221: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
5222: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
5223: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
5224: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
5225: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
5226: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
5227: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
5228: p_comments IN ar_receivable_applications.comments%TYPE,

Line 5225: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

5221: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
5222: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
5223: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
5224: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
5225: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
5226: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
5227: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
5228: p_comments IN ar_receivable_applications.comments%TYPE,
5229: p_module_name IN VARCHAR2,

Line 5226: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

5222: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
5223: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
5224: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
5225: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
5226: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
5227: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
5228: p_comments IN ar_receivable_applications.comments%TYPE,
5229: p_module_name IN VARCHAR2,
5230: p_module_version IN VARCHAR2,

Line 5227: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

5223: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
5224: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
5225: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
5226: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
5227: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
5228: p_comments IN ar_receivable_applications.comments%TYPE,
5229: p_module_name IN VARCHAR2,
5230: p_module_version IN VARCHAR2,
5231: p_out_rec_application_id OUT NOCOPY NUMBER

Line 5228: p_comments IN ar_receivable_applications.comments%TYPE,

5224: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
5225: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
5226: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
5227: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
5228: p_comments IN ar_receivable_applications.comments%TYPE,
5229: p_module_name IN VARCHAR2,
5230: p_module_version IN VARCHAR2,
5231: p_out_rec_application_id OUT NOCOPY NUMBER
5232: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE

Line 5232: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE

5228: p_comments IN ar_receivable_applications.comments%TYPE,
5229: p_module_name IN VARCHAR2,
5230: p_module_version IN VARCHAR2,
5231: p_out_rec_application_id OUT NOCOPY NUMBER
5232: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
5233: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
5234: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
5235: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
5236: , p_secondary_app_ref_type IN

Line 5233: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE

5229: p_module_name IN VARCHAR2,
5230: p_module_version IN VARCHAR2,
5231: p_out_rec_application_id OUT NOCOPY NUMBER
5232: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
5233: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
5234: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
5235: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
5236: , p_secondary_app_ref_type IN
5237: ar_receivable_applications.secondary_application_ref_type%TYPE := null

Line 5234: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE

5230: p_module_version IN VARCHAR2,
5231: p_out_rec_application_id OUT NOCOPY NUMBER
5232: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
5233: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
5234: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
5235: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
5236: , p_secondary_app_ref_type IN
5237: ar_receivable_applications.secondary_application_ref_type%TYPE := null
5238: , p_secondary_app_ref_num IN

Line 5235: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE

5231: p_out_rec_application_id OUT NOCOPY NUMBER
5232: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
5233: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
5234: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
5235: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
5236: , p_secondary_app_ref_type IN
5237: ar_receivable_applications.secondary_application_ref_type%TYPE := null
5238: , p_secondary_app_ref_num IN
5239: ar_receivable_applications.secondary_application_ref_num%TYPE := null

Line 5237: ar_receivable_applications.secondary_application_ref_type%TYPE := null

5233: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
5234: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
5235: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
5236: , p_secondary_app_ref_type IN
5237: ar_receivable_applications.secondary_application_ref_type%TYPE := null
5238: , p_secondary_app_ref_num IN
5239: ar_receivable_applications.secondary_application_ref_num%TYPE := null
5240: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
5241: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL

Line 5239: ar_receivable_applications.secondary_application_ref_num%TYPE := null

5235: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
5236: , p_secondary_app_ref_type IN
5237: ar_receivable_applications.secondary_application_ref_type%TYPE := null
5238: , p_secondary_app_ref_num IN
5239: ar_receivable_applications.secondary_application_ref_num%TYPE := null
5240: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
5241: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
5242: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
5243: ) IS

Line 5240: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL

5236: , p_secondary_app_ref_type IN
5237: ar_receivable_applications.secondary_application_ref_type%TYPE := null
5238: , p_secondary_app_ref_num IN
5239: ar_receivable_applications.secondary_application_ref_num%TYPE := null
5240: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
5241: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
5242: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
5243: ) IS
5244:

Line 5241: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL

5237: ar_receivable_applications.secondary_application_ref_type%TYPE := null
5238: , p_secondary_app_ref_num IN
5239: ar_receivable_applications.secondary_application_ref_num%TYPE := null
5240: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
5241: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
5242: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
5243: ) IS
5244:
5245: l_ra_rec ar_receivable_applications%ROWTYPE;

Line 5242: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL

5238: , p_secondary_app_ref_num IN
5239: ar_receivable_applications.secondary_application_ref_num%TYPE := null
5240: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
5241: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
5242: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
5243: ) IS
5244:
5245: l_ra_rec ar_receivable_applications%ROWTYPE;
5246: l_ps_rec ar_payment_schedules%ROWTYPE;

Line 5245: l_ra_rec ar_receivable_applications%ROWTYPE;

5241: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
5242: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
5243: ) IS
5244:
5245: l_ra_rec ar_receivable_applications%ROWTYPE;
5246: l_ps_rec ar_payment_schedules%ROWTYPE;
5247:
5248: l_cr_rec ar_cash_receipts%ROWTYPE;
5249: l_amount_due_remaining NUMBER;

Line 5322: from ar_receivable_applications ra

5318: -- the On Account row that we are about to create.
5319: --
5320: select nvl(sum(ra.amount_applied),0)
5321: into l_on_account_total
5322: from ar_receivable_applications ra
5323: where ra.cash_receipt_id = l_ra_rec.cash_receipt_id
5324: and ra.status IN ('ACC','OTHER ACC');
5325:
5326: -- Prepare for 'UNAPP' record insertion with -ve amount applied

Line 5598: ar_receivable_applications.amount_applied%TYPE,

5594: +===========================================================================*/
5595: PROCEDURE validate_on_account_args(
5596: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5597: p_amount_applied IN
5598: ar_receivable_applications.amount_applied%TYPE,
5599: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5600: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
5601: BEGIN
5602: IF PG_DEBUG in ('Y', 'C') THEN

Line 5599: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

5595: PROCEDURE validate_on_account_args(
5596: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5597: p_amount_applied IN
5598: ar_receivable_applications.amount_applied%TYPE,
5599: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5600: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
5601: BEGIN
5602: IF PG_DEBUG in ('Y', 'C') THEN
5603: arp_debug.debug(

Line 5600: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS

5596: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5597: p_amount_applied IN
5598: ar_receivable_applications.amount_applied%TYPE,
5599: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5600: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
5601: BEGIN
5602: IF PG_DEBUG in ('Y', 'C') THEN
5603: arp_debug.debug(
5604: 'arp_process_application.validate_on_account_args()+' );

Line 5695: ar_receivable_applications.applied_payment_schedule_id%TYPE,

5691: PROCEDURE activity_application(
5692: p_receipt_ps_id IN
5693: ar_payment_schedules.payment_schedule_id%TYPE,
5694: p_application_ps_id IN
5695: ar_receivable_applications.applied_payment_schedule_id%TYPE,
5696: p_link_to_customer_trx_id IN
5697: ar_receivable_applications.link_to_customer_trx_id%TYPE,
5698: p_amount_applied IN
5699: ar_receivable_applications.amount_applied%TYPE,

Line 5697: ar_receivable_applications.link_to_customer_trx_id%TYPE,

5693: ar_payment_schedules.payment_schedule_id%TYPE,
5694: p_application_ps_id IN
5695: ar_receivable_applications.applied_payment_schedule_id%TYPE,
5696: p_link_to_customer_trx_id IN
5697: ar_receivable_applications.link_to_customer_trx_id%TYPE,
5698: p_amount_applied IN
5699: ar_receivable_applications.amount_applied%TYPE,
5700: p_apply_date IN
5701: ar_receivable_applications.apply_date%TYPE,

Line 5699: ar_receivable_applications.amount_applied%TYPE,

5695: ar_receivable_applications.applied_payment_schedule_id%TYPE,
5696: p_link_to_customer_trx_id IN
5697: ar_receivable_applications.link_to_customer_trx_id%TYPE,
5698: p_amount_applied IN
5699: ar_receivable_applications.amount_applied%TYPE,
5700: p_apply_date IN
5701: ar_receivable_applications.apply_date%TYPE,
5702: p_gl_date IN
5703: ar_receivable_applications.gl_date%TYPE,

Line 5701: ar_receivable_applications.apply_date%TYPE,

5697: ar_receivable_applications.link_to_customer_trx_id%TYPE,
5698: p_amount_applied IN
5699: ar_receivable_applications.amount_applied%TYPE,
5700: p_apply_date IN
5701: ar_receivable_applications.apply_date%TYPE,
5702: p_gl_date IN
5703: ar_receivable_applications.gl_date%TYPE,
5704: p_receivables_trx_id IN
5705: ar_receivable_applications.receivables_trx_id%TYPE,

Line 5703: ar_receivable_applications.gl_date%TYPE,

5699: ar_receivable_applications.amount_applied%TYPE,
5700: p_apply_date IN
5701: ar_receivable_applications.apply_date%TYPE,
5702: p_gl_date IN
5703: ar_receivable_applications.gl_date%TYPE,
5704: p_receivables_trx_id IN
5705: ar_receivable_applications.receivables_trx_id%TYPE,
5706: p_ussgl_transaction_code IN
5707: ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 5705: ar_receivable_applications.receivables_trx_id%TYPE,

5701: ar_receivable_applications.apply_date%TYPE,
5702: p_gl_date IN
5703: ar_receivable_applications.gl_date%TYPE,
5704: p_receivables_trx_id IN
5705: ar_receivable_applications.receivables_trx_id%TYPE,
5706: p_ussgl_transaction_code IN
5707: ar_receivable_applications.ussgl_transaction_code%TYPE,
5708: p_attribute_category IN
5709: ar_receivable_applications.attribute_category%TYPE,

Line 5707: ar_receivable_applications.ussgl_transaction_code%TYPE,

5703: ar_receivable_applications.gl_date%TYPE,
5704: p_receivables_trx_id IN
5705: ar_receivable_applications.receivables_trx_id%TYPE,
5706: p_ussgl_transaction_code IN
5707: ar_receivable_applications.ussgl_transaction_code%TYPE,
5708: p_attribute_category IN
5709: ar_receivable_applications.attribute_category%TYPE,
5710: p_attribute1 IN
5711: ar_receivable_applications.attribute1%TYPE,

Line 5709: ar_receivable_applications.attribute_category%TYPE,

5705: ar_receivable_applications.receivables_trx_id%TYPE,
5706: p_ussgl_transaction_code IN
5707: ar_receivable_applications.ussgl_transaction_code%TYPE,
5708: p_attribute_category IN
5709: ar_receivable_applications.attribute_category%TYPE,
5710: p_attribute1 IN
5711: ar_receivable_applications.attribute1%TYPE,
5712: p_attribute2 IN
5713: ar_receivable_applications.attribute2%TYPE,

Line 5711: ar_receivable_applications.attribute1%TYPE,

5707: ar_receivable_applications.ussgl_transaction_code%TYPE,
5708: p_attribute_category IN
5709: ar_receivable_applications.attribute_category%TYPE,
5710: p_attribute1 IN
5711: ar_receivable_applications.attribute1%TYPE,
5712: p_attribute2 IN
5713: ar_receivable_applications.attribute2%TYPE,
5714: p_attribute3 IN
5715: ar_receivable_applications.attribute3%TYPE,

Line 5713: ar_receivable_applications.attribute2%TYPE,

5709: ar_receivable_applications.attribute_category%TYPE,
5710: p_attribute1 IN
5711: ar_receivable_applications.attribute1%TYPE,
5712: p_attribute2 IN
5713: ar_receivable_applications.attribute2%TYPE,
5714: p_attribute3 IN
5715: ar_receivable_applications.attribute3%TYPE,
5716: p_attribute4 IN
5717: ar_receivable_applications.attribute4%TYPE,

Line 5715: ar_receivable_applications.attribute3%TYPE,

5711: ar_receivable_applications.attribute1%TYPE,
5712: p_attribute2 IN
5713: ar_receivable_applications.attribute2%TYPE,
5714: p_attribute3 IN
5715: ar_receivable_applications.attribute3%TYPE,
5716: p_attribute4 IN
5717: ar_receivable_applications.attribute4%TYPE,
5718: p_attribute5 IN
5719: ar_receivable_applications.attribute5%TYPE,

Line 5717: ar_receivable_applications.attribute4%TYPE,

5713: ar_receivable_applications.attribute2%TYPE,
5714: p_attribute3 IN
5715: ar_receivable_applications.attribute3%TYPE,
5716: p_attribute4 IN
5717: ar_receivable_applications.attribute4%TYPE,
5718: p_attribute5 IN
5719: ar_receivable_applications.attribute5%TYPE,
5720: p_attribute6 IN
5721: ar_receivable_applications.attribute6%TYPE,

Line 5719: ar_receivable_applications.attribute5%TYPE,

5715: ar_receivable_applications.attribute3%TYPE,
5716: p_attribute4 IN
5717: ar_receivable_applications.attribute4%TYPE,
5718: p_attribute5 IN
5719: ar_receivable_applications.attribute5%TYPE,
5720: p_attribute6 IN
5721: ar_receivable_applications.attribute6%TYPE,
5722: p_attribute7 IN
5723: ar_receivable_applications.attribute7%TYPE,

Line 5721: ar_receivable_applications.attribute6%TYPE,

5717: ar_receivable_applications.attribute4%TYPE,
5718: p_attribute5 IN
5719: ar_receivable_applications.attribute5%TYPE,
5720: p_attribute6 IN
5721: ar_receivable_applications.attribute6%TYPE,
5722: p_attribute7 IN
5723: ar_receivable_applications.attribute7%TYPE,
5724: p_attribute8 IN
5725: ar_receivable_applications.attribute8%TYPE,

Line 5723: ar_receivable_applications.attribute7%TYPE,

5719: ar_receivable_applications.attribute5%TYPE,
5720: p_attribute6 IN
5721: ar_receivable_applications.attribute6%TYPE,
5722: p_attribute7 IN
5723: ar_receivable_applications.attribute7%TYPE,
5724: p_attribute8 IN
5725: ar_receivable_applications.attribute8%TYPE,
5726: p_attribute9 IN
5727: ar_receivable_applications.attribute9%TYPE,

Line 5725: ar_receivable_applications.attribute8%TYPE,

5721: ar_receivable_applications.attribute6%TYPE,
5722: p_attribute7 IN
5723: ar_receivable_applications.attribute7%TYPE,
5724: p_attribute8 IN
5725: ar_receivable_applications.attribute8%TYPE,
5726: p_attribute9 IN
5727: ar_receivable_applications.attribute9%TYPE,
5728: p_attribute10 IN
5729: ar_receivable_applications.attribute10%TYPE,

Line 5727: ar_receivable_applications.attribute9%TYPE,

5723: ar_receivable_applications.attribute7%TYPE,
5724: p_attribute8 IN
5725: ar_receivable_applications.attribute8%TYPE,
5726: p_attribute9 IN
5727: ar_receivable_applications.attribute9%TYPE,
5728: p_attribute10 IN
5729: ar_receivable_applications.attribute10%TYPE,
5730: p_attribute11 IN
5731: ar_receivable_applications.attribute11%TYPE,

Line 5729: ar_receivable_applications.attribute10%TYPE,

5725: ar_receivable_applications.attribute8%TYPE,
5726: p_attribute9 IN
5727: ar_receivable_applications.attribute9%TYPE,
5728: p_attribute10 IN
5729: ar_receivable_applications.attribute10%TYPE,
5730: p_attribute11 IN
5731: ar_receivable_applications.attribute11%TYPE,
5732: p_attribute12 IN
5733: ar_receivable_applications.attribute12%TYPE,

Line 5731: ar_receivable_applications.attribute11%TYPE,

5727: ar_receivable_applications.attribute9%TYPE,
5728: p_attribute10 IN
5729: ar_receivable_applications.attribute10%TYPE,
5730: p_attribute11 IN
5731: ar_receivable_applications.attribute11%TYPE,
5732: p_attribute12 IN
5733: ar_receivable_applications.attribute12%TYPE,
5734: p_attribute13 IN
5735: ar_receivable_applications.attribute13%TYPE,

Line 5733: ar_receivable_applications.attribute12%TYPE,

5729: ar_receivable_applications.attribute10%TYPE,
5730: p_attribute11 IN
5731: ar_receivable_applications.attribute11%TYPE,
5732: p_attribute12 IN
5733: ar_receivable_applications.attribute12%TYPE,
5734: p_attribute13 IN
5735: ar_receivable_applications.attribute13%TYPE,
5736: p_attribute14 IN
5737: ar_receivable_applications.attribute14%TYPE,

Line 5735: ar_receivable_applications.attribute13%TYPE,

5731: ar_receivable_applications.attribute11%TYPE,
5732: p_attribute12 IN
5733: ar_receivable_applications.attribute12%TYPE,
5734: p_attribute13 IN
5735: ar_receivable_applications.attribute13%TYPE,
5736: p_attribute14 IN
5737: ar_receivable_applications.attribute14%TYPE,
5738: p_attribute15 IN
5739: ar_receivable_applications.attribute15%TYPE,

Line 5737: ar_receivable_applications.attribute14%TYPE,

5733: ar_receivable_applications.attribute12%TYPE,
5734: p_attribute13 IN
5735: ar_receivable_applications.attribute13%TYPE,
5736: p_attribute14 IN
5737: ar_receivable_applications.attribute14%TYPE,
5738: p_attribute15 IN
5739: ar_receivable_applications.attribute15%TYPE,
5740: p_global_attribute_category IN
5741: ar_receivable_applications.global_attribute_category%TYPE,

Line 5739: ar_receivable_applications.attribute15%TYPE,

5735: ar_receivable_applications.attribute13%TYPE,
5736: p_attribute14 IN
5737: ar_receivable_applications.attribute14%TYPE,
5738: p_attribute15 IN
5739: ar_receivable_applications.attribute15%TYPE,
5740: p_global_attribute_category IN
5741: ar_receivable_applications.global_attribute_category%TYPE,
5742: p_global_attribute1 IN
5743: ar_receivable_applications.global_attribute1%TYPE,

Line 5741: ar_receivable_applications.global_attribute_category%TYPE,

5737: ar_receivable_applications.attribute14%TYPE,
5738: p_attribute15 IN
5739: ar_receivable_applications.attribute15%TYPE,
5740: p_global_attribute_category IN
5741: ar_receivable_applications.global_attribute_category%TYPE,
5742: p_global_attribute1 IN
5743: ar_receivable_applications.global_attribute1%TYPE,
5744: p_global_attribute2 IN
5745: ar_receivable_applications.global_attribute2%TYPE,

Line 5743: ar_receivable_applications.global_attribute1%TYPE,

5739: ar_receivable_applications.attribute15%TYPE,
5740: p_global_attribute_category IN
5741: ar_receivable_applications.global_attribute_category%TYPE,
5742: p_global_attribute1 IN
5743: ar_receivable_applications.global_attribute1%TYPE,
5744: p_global_attribute2 IN
5745: ar_receivable_applications.global_attribute2%TYPE,
5746: p_global_attribute3 IN
5747: ar_receivable_applications.global_attribute3%TYPE,

Line 5745: ar_receivable_applications.global_attribute2%TYPE,

5741: ar_receivable_applications.global_attribute_category%TYPE,
5742: p_global_attribute1 IN
5743: ar_receivable_applications.global_attribute1%TYPE,
5744: p_global_attribute2 IN
5745: ar_receivable_applications.global_attribute2%TYPE,
5746: p_global_attribute3 IN
5747: ar_receivable_applications.global_attribute3%TYPE,
5748: p_global_attribute4 IN
5749: ar_receivable_applications.global_attribute4%TYPE,

Line 5747: ar_receivable_applications.global_attribute3%TYPE,

5743: ar_receivable_applications.global_attribute1%TYPE,
5744: p_global_attribute2 IN
5745: ar_receivable_applications.global_attribute2%TYPE,
5746: p_global_attribute3 IN
5747: ar_receivable_applications.global_attribute3%TYPE,
5748: p_global_attribute4 IN
5749: ar_receivable_applications.global_attribute4%TYPE,
5750: p_global_attribute5 IN
5751: ar_receivable_applications.global_attribute5%TYPE,

Line 5749: ar_receivable_applications.global_attribute4%TYPE,

5745: ar_receivable_applications.global_attribute2%TYPE,
5746: p_global_attribute3 IN
5747: ar_receivable_applications.global_attribute3%TYPE,
5748: p_global_attribute4 IN
5749: ar_receivable_applications.global_attribute4%TYPE,
5750: p_global_attribute5 IN
5751: ar_receivable_applications.global_attribute5%TYPE,
5752: p_global_attribute6 IN
5753: ar_receivable_applications.global_attribute6%TYPE,

Line 5751: ar_receivable_applications.global_attribute5%TYPE,

5747: ar_receivable_applications.global_attribute3%TYPE,
5748: p_global_attribute4 IN
5749: ar_receivable_applications.global_attribute4%TYPE,
5750: p_global_attribute5 IN
5751: ar_receivable_applications.global_attribute5%TYPE,
5752: p_global_attribute6 IN
5753: ar_receivable_applications.global_attribute6%TYPE,
5754: p_global_attribute7 IN
5755: ar_receivable_applications.global_attribute7%TYPE,

Line 5753: ar_receivable_applications.global_attribute6%TYPE,

5749: ar_receivable_applications.global_attribute4%TYPE,
5750: p_global_attribute5 IN
5751: ar_receivable_applications.global_attribute5%TYPE,
5752: p_global_attribute6 IN
5753: ar_receivable_applications.global_attribute6%TYPE,
5754: p_global_attribute7 IN
5755: ar_receivable_applications.global_attribute7%TYPE,
5756: p_global_attribute8 IN
5757: ar_receivable_applications.global_attribute8%TYPE,

Line 5755: ar_receivable_applications.global_attribute7%TYPE,

5751: ar_receivable_applications.global_attribute5%TYPE,
5752: p_global_attribute6 IN
5753: ar_receivable_applications.global_attribute6%TYPE,
5754: p_global_attribute7 IN
5755: ar_receivable_applications.global_attribute7%TYPE,
5756: p_global_attribute8 IN
5757: ar_receivable_applications.global_attribute8%TYPE,
5758: p_global_attribute9 IN
5759: ar_receivable_applications.global_attribute9%TYPE,

Line 5757: ar_receivable_applications.global_attribute8%TYPE,

5753: ar_receivable_applications.global_attribute6%TYPE,
5754: p_global_attribute7 IN
5755: ar_receivable_applications.global_attribute7%TYPE,
5756: p_global_attribute8 IN
5757: ar_receivable_applications.global_attribute8%TYPE,
5758: p_global_attribute9 IN
5759: ar_receivable_applications.global_attribute9%TYPE,
5760: p_global_attribute10 IN
5761: ar_receivable_applications.global_attribute10%TYPE,

Line 5759: ar_receivable_applications.global_attribute9%TYPE,

5755: ar_receivable_applications.global_attribute7%TYPE,
5756: p_global_attribute8 IN
5757: ar_receivable_applications.global_attribute8%TYPE,
5758: p_global_attribute9 IN
5759: ar_receivable_applications.global_attribute9%TYPE,
5760: p_global_attribute10 IN
5761: ar_receivable_applications.global_attribute10%TYPE,
5762: p_global_attribute11 IN
5763: ar_receivable_applications.global_attribute11%TYPE,

Line 5761: ar_receivable_applications.global_attribute10%TYPE,

5757: ar_receivable_applications.global_attribute8%TYPE,
5758: p_global_attribute9 IN
5759: ar_receivable_applications.global_attribute9%TYPE,
5760: p_global_attribute10 IN
5761: ar_receivable_applications.global_attribute10%TYPE,
5762: p_global_attribute11 IN
5763: ar_receivable_applications.global_attribute11%TYPE,
5764: p_global_attribute12 IN
5765: ar_receivable_applications.global_attribute12%TYPE,

Line 5763: ar_receivable_applications.global_attribute11%TYPE,

5759: ar_receivable_applications.global_attribute9%TYPE,
5760: p_global_attribute10 IN
5761: ar_receivable_applications.global_attribute10%TYPE,
5762: p_global_attribute11 IN
5763: ar_receivable_applications.global_attribute11%TYPE,
5764: p_global_attribute12 IN
5765: ar_receivable_applications.global_attribute12%TYPE,
5766: p_global_attribute13 IN
5767: ar_receivable_applications.global_attribute13%TYPE,

Line 5765: ar_receivable_applications.global_attribute12%TYPE,

5761: ar_receivable_applications.global_attribute10%TYPE,
5762: p_global_attribute11 IN
5763: ar_receivable_applications.global_attribute11%TYPE,
5764: p_global_attribute12 IN
5765: ar_receivable_applications.global_attribute12%TYPE,
5766: p_global_attribute13 IN
5767: ar_receivable_applications.global_attribute13%TYPE,
5768: p_global_attribute14 IN
5769: ar_receivable_applications.global_attribute14%TYPE,

Line 5767: ar_receivable_applications.global_attribute13%TYPE,

5763: ar_receivable_applications.global_attribute11%TYPE,
5764: p_global_attribute12 IN
5765: ar_receivable_applications.global_attribute12%TYPE,
5766: p_global_attribute13 IN
5767: ar_receivable_applications.global_attribute13%TYPE,
5768: p_global_attribute14 IN
5769: ar_receivable_applications.global_attribute14%TYPE,
5770: p_global_attribute15 IN
5771: ar_receivable_applications.global_attribute15%TYPE,

Line 5769: ar_receivable_applications.global_attribute14%TYPE,

5765: ar_receivable_applications.global_attribute12%TYPE,
5766: p_global_attribute13 IN
5767: ar_receivable_applications.global_attribute13%TYPE,
5768: p_global_attribute14 IN
5769: ar_receivable_applications.global_attribute14%TYPE,
5770: p_global_attribute15 IN
5771: ar_receivable_applications.global_attribute15%TYPE,
5772: p_global_attribute16 IN
5773: ar_receivable_applications.global_attribute16%TYPE,

Line 5771: ar_receivable_applications.global_attribute15%TYPE,

5767: ar_receivable_applications.global_attribute13%TYPE,
5768: p_global_attribute14 IN
5769: ar_receivable_applications.global_attribute14%TYPE,
5770: p_global_attribute15 IN
5771: ar_receivable_applications.global_attribute15%TYPE,
5772: p_global_attribute16 IN
5773: ar_receivable_applications.global_attribute16%TYPE,
5774: p_global_attribute17 IN
5775: ar_receivable_applications.global_attribute17%TYPE,

Line 5773: ar_receivable_applications.global_attribute16%TYPE,

5769: ar_receivable_applications.global_attribute14%TYPE,
5770: p_global_attribute15 IN
5771: ar_receivable_applications.global_attribute15%TYPE,
5772: p_global_attribute16 IN
5773: ar_receivable_applications.global_attribute16%TYPE,
5774: p_global_attribute17 IN
5775: ar_receivable_applications.global_attribute17%TYPE,
5776: p_global_attribute18 IN
5777: ar_receivable_applications.global_attribute18%TYPE,

Line 5775: ar_receivable_applications.global_attribute17%TYPE,

5771: ar_receivable_applications.global_attribute15%TYPE,
5772: p_global_attribute16 IN
5773: ar_receivable_applications.global_attribute16%TYPE,
5774: p_global_attribute17 IN
5775: ar_receivable_applications.global_attribute17%TYPE,
5776: p_global_attribute18 IN
5777: ar_receivable_applications.global_attribute18%TYPE,
5778: p_global_attribute19 IN
5779: ar_receivable_applications.global_attribute19%TYPE,

Line 5777: ar_receivable_applications.global_attribute18%TYPE,

5773: ar_receivable_applications.global_attribute16%TYPE,
5774: p_global_attribute17 IN
5775: ar_receivable_applications.global_attribute17%TYPE,
5776: p_global_attribute18 IN
5777: ar_receivable_applications.global_attribute18%TYPE,
5778: p_global_attribute19 IN
5779: ar_receivable_applications.global_attribute19%TYPE,
5780: p_global_attribute20 IN
5781: ar_receivable_applications.global_attribute20%TYPE,

Line 5779: ar_receivable_applications.global_attribute19%TYPE,

5775: ar_receivable_applications.global_attribute17%TYPE,
5776: p_global_attribute18 IN
5777: ar_receivable_applications.global_attribute18%TYPE,
5778: p_global_attribute19 IN
5779: ar_receivable_applications.global_attribute19%TYPE,
5780: p_global_attribute20 IN
5781: ar_receivable_applications.global_attribute20%TYPE,
5782: p_comments IN
5783: ar_receivable_applications.comments%TYPE,

Line 5781: ar_receivable_applications.global_attribute20%TYPE,

5777: ar_receivable_applications.global_attribute18%TYPE,
5778: p_global_attribute19 IN
5779: ar_receivable_applications.global_attribute19%TYPE,
5780: p_global_attribute20 IN
5781: ar_receivable_applications.global_attribute20%TYPE,
5782: p_comments IN
5783: ar_receivable_applications.comments%TYPE,
5784: p_module_name IN VARCHAR2,
5785: p_module_version IN VARCHAR2,

Line 5783: ar_receivable_applications.comments%TYPE,

5779: ar_receivable_applications.global_attribute19%TYPE,
5780: p_global_attribute20 IN
5781: ar_receivable_applications.global_attribute20%TYPE,
5782: p_comments IN
5783: ar_receivable_applications.comments%TYPE,
5784: p_module_name IN VARCHAR2,
5785: p_module_version IN VARCHAR2,
5786: p_application_ref_type IN OUT NOCOPY
5787: ar_receivable_applications.application_ref_type%TYPE,

Line 5787: ar_receivable_applications.application_ref_type%TYPE,

5783: ar_receivable_applications.comments%TYPE,
5784: p_module_name IN VARCHAR2,
5785: p_module_version IN VARCHAR2,
5786: p_application_ref_type IN OUT NOCOPY
5787: ar_receivable_applications.application_ref_type%TYPE,
5788: p_application_ref_id IN OUT NOCOPY
5789: ar_receivable_applications.application_ref_id%TYPE,
5790: p_application_ref_num IN OUT NOCOPY
5791: ar_receivable_applications.application_ref_num%TYPE,

Line 5789: ar_receivable_applications.application_ref_id%TYPE,

5785: p_module_version IN VARCHAR2,
5786: p_application_ref_type IN OUT NOCOPY
5787: ar_receivable_applications.application_ref_type%TYPE,
5788: p_application_ref_id IN OUT NOCOPY
5789: ar_receivable_applications.application_ref_id%TYPE,
5790: p_application_ref_num IN OUT NOCOPY
5791: ar_receivable_applications.application_ref_num%TYPE,
5792: p_secondary_application_ref_id IN OUT NOCOPY NUMBER,
5793: p_payment_set_id IN NUMBER,

Line 5791: ar_receivable_applications.application_ref_num%TYPE,

5787: ar_receivable_applications.application_ref_type%TYPE,
5788: p_application_ref_id IN OUT NOCOPY
5789: ar_receivable_applications.application_ref_id%TYPE,
5790: p_application_ref_num IN OUT NOCOPY
5791: ar_receivable_applications.application_ref_num%TYPE,
5792: p_secondary_application_ref_id IN OUT NOCOPY NUMBER,
5793: p_payment_set_id IN NUMBER,
5794: p_called_from IN VARCHAR2, /*5444407*/
5795: p_out_rec_application_id OUT NOCOPY NUMBER,

Line 5797: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,

5793: p_payment_set_id IN NUMBER,
5794: p_called_from IN VARCHAR2, /*5444407*/
5795: p_out_rec_application_id OUT NOCOPY NUMBER,
5796: p_applied_rec_app_id IN NUMBER,
5797: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5798: p_netted_receipt_flag IN VARCHAR2,
5799: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
5800: p_secondary_app_ref_type IN
5801: ar_receivable_applications.secondary_application_ref_type%TYPE := null,

Line 5801: ar_receivable_applications.secondary_application_ref_type%TYPE := null,

5797: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5798: p_netted_receipt_flag IN VARCHAR2,
5799: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
5800: p_secondary_app_ref_type IN
5801: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5802: p_secondary_app_ref_num IN
5803: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5804: p_customer_reason IN
5805: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

Line 5803: ar_receivable_applications.secondary_application_ref_num%TYPE := null,

5799: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
5800: p_secondary_app_ref_type IN
5801: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5802: p_secondary_app_ref_num IN
5803: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5804: p_customer_reason IN
5805: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5806: --Bug 5450371
5807: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL

Line 5805: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

5801: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5802: p_secondary_app_ref_num IN
5803: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5804: p_customer_reason IN
5805: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5806: --Bug 5450371
5807: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL
5808: ) IS
5809:

Line 5807: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL

5803: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5804: p_customer_reason IN
5805: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5806: --Bug 5450371
5807: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL
5808: ) IS
5809:
5810: /* Cursor to application information for activity application */
5811: CURSOR activity_c IS

Line 5838: l_ra_rec ar_receivable_applications%ROWTYPE;

5834: AND rt.receivables_trx_id = p_receivables_trx_id;
5835:
5836: activity_rec activity_c%ROWTYPE;
5837:
5838: l_ra_rec ar_receivable_applications%ROWTYPE;
5839: l_ps_rec ar_payment_schedules%ROWTYPE;
5840: l_cr_rec ar_cash_receipts%ROWTYPE;
5841: l_crcpt_rec ar_cash_receipts%ROWTYPE;
5842:

Line 5843: l_unapp_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */

5839: l_ps_rec ar_payment_schedules%ROWTYPE;
5840: l_cr_rec ar_cash_receipts%ROWTYPE;
5841: l_crcpt_rec ar_cash_receipts%ROWTYPE;
5842:
5843: l_unapp_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */
5844:
5845: functional_curr VARCHAR2(100);
5846: l_on_account_total NUMBER;
5847: l_ae_doc_rec ae_doc_rec_type;

Line 5849: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;

5845: functional_curr VARCHAR2(100);
5846: l_on_account_total NUMBER;
5847: l_ae_doc_rec ae_doc_rec_type;
5848: l_prev_unapp_id NUMBER;
5849: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
5850: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
5851: l_invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE;
5852: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE;
5853: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;

Line 5850: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

5846: l_on_account_total NUMBER;
5847: l_ae_doc_rec ae_doc_rec_type;
5848: l_prev_unapp_id NUMBER;
5849: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
5850: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
5851: l_invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE;
5852: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE;
5853: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
5854: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

Line 5866: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

5862: l_msg_count NUMBER;
5863: l_msg_data VARCHAR2(2000);
5864: l_msg_index NUMBER;
5865:
5866: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
5867: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5868: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5869: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5870: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;

Line 5867: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

5863: l_msg_data VARCHAR2(2000);
5864: l_msg_index NUMBER;
5865:
5866: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
5867: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5868: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5869: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5870: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5871: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;

Line 5868: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

5864: l_msg_index NUMBER;
5865:
5866: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
5867: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5868: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5869: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5870: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5871: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
5872: l_netted_receipt_flag VARCHAR2(1);

Line 5869: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

5865:
5866: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
5867: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5868: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5869: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5870: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5871: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
5872: l_netted_receipt_flag VARCHAR2(1);
5873: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

Line 5870: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;

5866: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
5867: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5868: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5869: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5870: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5871: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
5872: l_netted_receipt_flag VARCHAR2(1);
5873: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5874: API_exception EXCEPTION;

Line 5871: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;

5867: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5868: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5869: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5870: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5871: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
5872: l_netted_receipt_flag VARCHAR2(1);
5873: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5874: API_exception EXCEPTION;
5875:

Line 5873: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

5869: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5870: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5871: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
5872: l_netted_receipt_flag VARCHAR2(1);
5873: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5874: API_exception EXCEPTION;
5875:
5876: --Bug 5450371
5877: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;

Line 5877: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;

5873: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5874: API_exception EXCEPTION;
5875:
5876: --Bug 5450371
5877: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
5878:
5879: --For CC_Chargeback logic
5880: l_called_from VARCHAR2(100) := null;
5881: l_called_from_api VARCHAR2(1);

Line 5982: FROM ar_receivable_applications

5978: INTO l_pymnt_trxn_ext_id_temp
5979: FROM ar_cash_receipts
5980: WHERE cash_receipt_id IN (
5981: SELECT MAX(application_ref_id)
5982: FROM ar_receivable_applications
5983: WHERE cash_receipt_id = l_ps_rec.cash_receipt_id
5984: AND application_type = 'CASH'
5985: AND application_ref_type = 'MISC_RECEIPT'
5986: AND applied_payment_schedule_id <> '-9'); -- Added for Bug 13591288

Line 6493: from ar_receivable_applications ra

6489: * total for the receipt. */
6490:
6491: select nvl(sum(ra.amount_applied),0)
6492: into l_on_account_total
6493: from ar_receivable_applications ra
6494: where ra.cash_receipt_id = l_ra_rec.cash_receipt_id
6495: and ra.status IN ('ACC','OTHER ACC');
6496:
6497: IF (activity_rec.amount_due_remaining + l_on_account_total + p_amount_applied < 0)

Line 6578: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

6574: | |
6575: +===========================================================================*/
6576: PROCEDURE validate_activity_args(
6577: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6578: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6579: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6580: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6581: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6582: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 6579: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,

6575: +===========================================================================*/
6576: PROCEDURE validate_activity_args(
6577: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6578: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6579: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6580: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6581: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6582: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6583: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS

Line 6580: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

6576: PROCEDURE validate_activity_args(
6577: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6578: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6579: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6580: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6581: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6582: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6583: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS
6584:

Line 6581: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

6577: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6578: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6579: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6580: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6581: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6582: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6583: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS
6584:
6585: BEGIN

Line 6582: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

6578: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6579: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6580: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6581: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6582: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6583: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS
6584:
6585: BEGIN
6586: IF PG_DEBUG in ('Y', 'C') THEN

Line 6583: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS

6579: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6580: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6581: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6582: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6583: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS
6584:
6585: BEGIN
6586: IF PG_DEBUG in ('Y', 'C') THEN
6587: arp_debug.debug( 'arp_process_application.validate_activity_args()+' );

Line 6646: p_applied_customer_trx_id OUT NOCOPY ar_receivable_applications.applied_customer_trx_id%TYPE,

6642: | |
6643: +===========================================================================*/
6644: PROCEDURE fetch_app_ccid(
6645: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6646: p_applied_customer_trx_id OUT NOCOPY ar_receivable_applications.applied_customer_trx_id%TYPE,
6647: p_code_combination_id OUT NOCOPY ar_receivable_applications.code_combination_id%TYPE,
6648: p_source_type OUT NOCOPY ar_distributions.source_type%TYPE) IS
6649:
6650: /* Cursor to fetch the given transaction information */

Line 6647: p_code_combination_id OUT NOCOPY ar_receivable_applications.code_combination_id%TYPE,

6643: +===========================================================================*/
6644: PROCEDURE fetch_app_ccid(
6645: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6646: p_applied_customer_trx_id OUT NOCOPY ar_receivable_applications.applied_customer_trx_id%TYPE,
6647: p_code_combination_id OUT NOCOPY ar_receivable_applications.code_combination_id%TYPE,
6648: p_source_type OUT NOCOPY ar_distributions.source_type%TYPE) IS
6649:
6650: /* Cursor to fetch the given transaction information */
6651: CURSOR doc_cur IS

Line 6824: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

6820: | schedule_id of -3 for receipt write-off|
6821: | |
6822: +===========================================================================*/
6823: PROCEDURE validate_activity(
6824: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6825: p_activity_type IN ar_receivables_trx.type%TYPE) IS
6826:
6827: BEGIN
6828: IF PG_DEBUG in ('Y', 'C') THEN

Line 6880: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,

6876: | FALSE - If the UNAPP row is not postable |
6877: | MODIFICATION HISTORY - Created by Jani Rautiainen - 09-OCT-2000 |
6878: | |
6879: +===========================================================================*/
6880: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,
6881: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN IS
6882:
6883: CURSOR trx_class_cur IS
6884: SELECT ps.class

Line 6881: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN IS

6877: | MODIFICATION HISTORY - Created by Jani Rautiainen - 09-OCT-2000 |
6878: | |
6879: +===========================================================================*/
6880: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,
6881: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN IS
6882:
6883: CURSOR trx_class_cur IS
6884: SELECT ps.class
6885: FROM ar_payment_schedules ps

Line 6995: | used in query on ar_receivable_applications |

6991: | 30-JUN-2004 Jon Beckett Removed RAISE from handling of trade_mgt_err |
6992: | to ensure TM errors are displayed correctly |
6993: | 06-AUG-2004 Jon Beckett Bug 3643551 - index on applied_ps_id |
6994: | ignored to ensure index on cash_receipt_id is|
6995: | used in query on ar_receivable_applications |
6996: | 03-MAR-2005 JASSING Added the code to check for the profile |
6997: | option 'AR:Disable Receivable Activity |
6998: | Balancing Segment Substitution' for Claims |
6999: | and Prepayments. Bug Fix 4025652. |

Line 7005: ar_receivable_applications.amount_applied%TYPE,

7001: +===========================================================================*/
7002: PROCEDURE other_account_application(
7003: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
7004: p_amount_applied IN
7005: ar_receivable_applications.amount_applied%TYPE,
7006: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
7007: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
7008: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
7009: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

Line 7006: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

7002: PROCEDURE other_account_application(
7003: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
7004: p_amount_applied IN
7005: ar_receivable_applications.amount_applied%TYPE,
7006: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
7007: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
7008: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
7009: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
7010: p_ussgl_transaction_code IN

Line 7007: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

7003: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
7004: p_amount_applied IN
7005: ar_receivable_applications.amount_applied%TYPE,
7006: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
7007: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
7008: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
7009: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
7010: p_ussgl_transaction_code IN
7011: ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 7008: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,

7004: p_amount_applied IN
7005: ar_receivable_applications.amount_applied%TYPE,
7006: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
7007: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
7008: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
7009: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
7010: p_ussgl_transaction_code IN
7011: ar_receivable_applications.ussgl_transaction_code%TYPE,
7012: p_application_ref_type IN

Line 7009: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

7005: ar_receivable_applications.amount_applied%TYPE,
7006: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
7007: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
7008: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
7009: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
7010: p_ussgl_transaction_code IN
7011: ar_receivable_applications.ussgl_transaction_code%TYPE,
7012: p_application_ref_type IN
7013: ar_receivable_applications.application_ref_type%TYPE,

Line 7011: ar_receivable_applications.ussgl_transaction_code%TYPE,

7007: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
7008: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
7009: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
7010: p_ussgl_transaction_code IN
7011: ar_receivable_applications.ussgl_transaction_code%TYPE,
7012: p_application_ref_type IN
7013: ar_receivable_applications.application_ref_type%TYPE,
7014: p_application_ref_id IN
7015: ar_receivable_applications.application_ref_id%TYPE,

Line 7013: ar_receivable_applications.application_ref_type%TYPE,

7009: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
7010: p_ussgl_transaction_code IN
7011: ar_receivable_applications.ussgl_transaction_code%TYPE,
7012: p_application_ref_type IN
7013: ar_receivable_applications.application_ref_type%TYPE,
7014: p_application_ref_id IN
7015: ar_receivable_applications.application_ref_id%TYPE,
7016: p_application_ref_num IN
7017: ar_receivable_applications.application_ref_num%TYPE,

Line 7015: ar_receivable_applications.application_ref_id%TYPE,

7011: ar_receivable_applications.ussgl_transaction_code%TYPE,
7012: p_application_ref_type IN
7013: ar_receivable_applications.application_ref_type%TYPE,
7014: p_application_ref_id IN
7015: ar_receivable_applications.application_ref_id%TYPE,
7016: p_application_ref_num IN
7017: ar_receivable_applications.application_ref_num%TYPE,
7018: p_secondary_application_ref_id IN NUMBER,
7019: p_comments IN

Line 7017: ar_receivable_applications.application_ref_num%TYPE,

7013: ar_receivable_applications.application_ref_type%TYPE,
7014: p_application_ref_id IN
7015: ar_receivable_applications.application_ref_id%TYPE,
7016: p_application_ref_num IN
7017: ar_receivable_applications.application_ref_num%TYPE,
7018: p_secondary_application_ref_id IN NUMBER,
7019: p_comments IN
7020: ar_receivable_applications.comments%TYPE,
7021: p_attribute_category IN

Line 7020: ar_receivable_applications.comments%TYPE,

7016: p_application_ref_num IN
7017: ar_receivable_applications.application_ref_num%TYPE,
7018: p_secondary_application_ref_id IN NUMBER,
7019: p_comments IN
7020: ar_receivable_applications.comments%TYPE,
7021: p_attribute_category IN
7022: ar_receivable_applications.attribute_category%TYPE,
7023: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
7024: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

Line 7022: ar_receivable_applications.attribute_category%TYPE,

7018: p_secondary_application_ref_id IN NUMBER,
7019: p_comments IN
7020: ar_receivable_applications.comments%TYPE,
7021: p_attribute_category IN
7022: ar_receivable_applications.attribute_category%TYPE,
7023: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
7024: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
7025: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
7026: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

Line 7023: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

7019: p_comments IN
7020: ar_receivable_applications.comments%TYPE,
7021: p_attribute_category IN
7022: ar_receivable_applications.attribute_category%TYPE,
7023: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
7024: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
7025: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
7026: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
7027: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

Line 7024: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

7020: ar_receivable_applications.comments%TYPE,
7021: p_attribute_category IN
7022: ar_receivable_applications.attribute_category%TYPE,
7023: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
7024: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
7025: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
7026: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
7027: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
7028: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

Line 7025: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

7021: p_attribute_category IN
7022: ar_receivable_applications.attribute_category%TYPE,
7023: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
7024: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
7025: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
7026: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
7027: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
7028: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
7029: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

Line 7026: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

7022: ar_receivable_applications.attribute_category%TYPE,
7023: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
7024: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
7025: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
7026: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
7027: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
7028: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
7029: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
7030: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

Line 7027: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

7023: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
7024: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
7025: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
7026: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
7027: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
7028: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
7029: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
7030: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
7031: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

Line 7028: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

7024: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
7025: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
7026: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
7027: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
7028: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
7029: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
7030: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
7031: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
7032: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

Line 7029: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

7025: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
7026: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
7027: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
7028: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
7029: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
7030: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
7031: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
7032: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
7033: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

Line 7030: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

7026: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
7027: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
7028: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
7029: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
7030: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
7031: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
7032: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
7033: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
7034: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

Line 7031: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

7027: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
7028: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
7029: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
7030: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
7031: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
7032: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
7033: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
7034: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
7035: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

Line 7032: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

7028: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
7029: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
7030: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
7031: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
7032: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
7033: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
7034: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
7035: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
7036: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

Line 7033: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

7029: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
7030: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
7031: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
7032: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
7033: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
7034: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
7035: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
7036: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
7037: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

Line 7034: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

7030: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
7031: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
7032: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
7033: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
7034: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
7035: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
7036: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
7037: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
7038: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

Line 7035: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

7031: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
7032: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
7033: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
7034: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
7035: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
7036: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
7037: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
7038: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
7039: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

Line 7036: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

7032: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
7033: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
7034: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
7035: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
7036: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
7037: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
7038: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
7039: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
7040: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

Line 7037: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

7033: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
7034: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
7035: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
7036: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
7037: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
7038: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
7039: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
7040: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
7041: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

Line 7038: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

7034: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
7035: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
7036: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
7037: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
7038: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
7039: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
7040: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
7041: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
7042: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

Line 7039: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

7035: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
7036: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
7037: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
7038: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
7039: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
7040: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
7041: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
7042: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
7043: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

Line 7040: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

7036: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
7037: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
7038: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
7039: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
7040: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
7041: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
7042: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
7043: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
7044: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

Line 7041: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

7037: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
7038: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
7039: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
7040: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
7041: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
7042: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
7043: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
7044: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
7045: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

Line 7042: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

7038: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
7039: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
7040: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
7041: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
7042: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
7043: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
7044: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
7045: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
7046: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

Line 7043: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

7039: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
7040: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
7041: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
7042: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
7043: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
7044: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
7045: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
7046: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
7047: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

Line 7044: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

7040: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
7041: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
7042: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
7043: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
7044: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
7045: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
7046: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
7047: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
7048: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

Line 7045: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

7041: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
7042: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
7043: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
7044: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
7045: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
7046: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
7047: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
7048: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
7049: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

Line 7046: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

7042: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
7043: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
7044: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
7045: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
7046: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
7047: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
7048: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
7049: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
7050: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

Line 7047: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

7043: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
7044: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
7045: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
7046: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
7047: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
7048: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
7049: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
7050: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
7051: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

Line 7048: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

7044: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
7045: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
7046: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
7047: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
7048: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
7049: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
7050: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
7051: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
7052: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

Line 7049: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

7045: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
7046: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
7047: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
7048: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
7049: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
7050: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
7051: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
7052: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
7053: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

Line 7050: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

7046: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
7047: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
7048: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
7049: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
7050: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
7051: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
7052: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
7053: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
7054: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

Line 7051: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

7047: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
7048: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
7049: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
7050: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
7051: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
7052: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
7053: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
7054: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
7055: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

Line 7052: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

7048: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
7049: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
7050: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
7051: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
7052: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
7053: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
7054: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
7055: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
7056: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

Line 7053: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

7049: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
7050: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
7051: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
7052: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
7053: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
7054: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
7055: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
7056: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
7057: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

Line 7054: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

7050: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
7051: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
7052: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
7053: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
7054: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
7055: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
7056: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
7057: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
7058: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

Line 7055: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

7051: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
7052: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
7053: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
7054: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
7055: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
7056: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
7057: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
7058: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
7059: p_module_name IN VARCHAR2,

Line 7056: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

7052: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
7053: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
7054: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
7055: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
7056: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
7057: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
7058: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
7059: p_module_name IN VARCHAR2,
7060: p_module_version IN VARCHAR2,

Line 7057: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

7053: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
7054: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
7055: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
7056: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
7057: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
7058: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
7059: p_module_name IN VARCHAR2,
7060: p_module_version IN VARCHAR2,
7061: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,

Line 7058: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

7054: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
7055: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
7056: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
7057: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
7058: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
7059: p_module_name IN VARCHAR2,
7060: p_module_version IN VARCHAR2,
7061: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
7062: x_application_ref_id OUT NOCOPY

Line 7061: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,

7057: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
7058: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
7059: p_module_name IN VARCHAR2,
7060: p_module_version IN VARCHAR2,
7061: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
7062: x_application_ref_id OUT NOCOPY
7063: ar_receivable_applications.application_ref_id%TYPE,
7064: x_application_ref_num OUT NOCOPY
7065: ar_receivable_applications.application_ref_num%TYPE

Line 7063: ar_receivable_applications.application_ref_id%TYPE,

7059: p_module_name IN VARCHAR2,
7060: p_module_version IN VARCHAR2,
7061: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
7062: x_application_ref_id OUT NOCOPY
7063: ar_receivable_applications.application_ref_id%TYPE,
7064: x_application_ref_num OUT NOCOPY
7065: ar_receivable_applications.application_ref_num%TYPE
7066: , x_return_status OUT NOCOPY VARCHAR2
7067: , x_msg_count OUT NOCOPY NUMBER

Line 7065: ar_receivable_applications.application_ref_num%TYPE

7061: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
7062: x_application_ref_id OUT NOCOPY
7063: ar_receivable_applications.application_ref_id%TYPE,
7064: x_application_ref_num OUT NOCOPY
7065: ar_receivable_applications.application_ref_num%TYPE
7066: , x_return_status OUT NOCOPY VARCHAR2
7067: , x_msg_count OUT NOCOPY NUMBER
7068: , x_msg_data OUT NOCOPY VARCHAR2
7069: , p_out_rec_application_id OUT NOCOPY NUMBER

Line 7070: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE

7066: , x_return_status OUT NOCOPY VARCHAR2
7067: , x_msg_count OUT NOCOPY NUMBER
7068: , x_msg_data OUT NOCOPY VARCHAR2
7069: , p_out_rec_application_id OUT NOCOPY NUMBER
7070: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE
7071: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
7072: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
7073: , x_claim_reason_name OUT NOCOPY VARCHAR2
7074: , p_called_from IN VARCHAR2) IS

Line 7071: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE

7067: , x_msg_count OUT NOCOPY NUMBER
7068: , x_msg_data OUT NOCOPY VARCHAR2
7069: , p_out_rec_application_id OUT NOCOPY NUMBER
7070: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE
7071: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
7072: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
7073: , x_claim_reason_name OUT NOCOPY VARCHAR2
7074: , p_called_from IN VARCHAR2) IS
7075:

Line 7072: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE

7068: , x_msg_data OUT NOCOPY VARCHAR2
7069: , p_out_rec_application_id OUT NOCOPY NUMBER
7070: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE
7071: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
7072: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
7073: , x_claim_reason_name OUT NOCOPY VARCHAR2
7074: , p_called_from IN VARCHAR2) IS
7075:
7076: l_ra_rec ar_receivable_applications%ROWTYPE;

Line 7076: l_ra_rec ar_receivable_applications%ROWTYPE;

7072: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
7073: , x_claim_reason_name OUT NOCOPY VARCHAR2
7074: , p_called_from IN VARCHAR2) IS
7075:
7076: l_ra_rec ar_receivable_applications%ROWTYPE;
7077: l_ps_rec ar_payment_schedules%ROWTYPE;
7078:
7079: l_cr_rec ar_cash_receipts%ROWTYPE;
7080: l_amount_due_remaining NUMBER;

Line 7193: FROM ar_receivable_applications rap

7189:
7190: -- Bug 3643551: use of index on applied_ps_id prevented
7191: SELECT 'Y'
7192: INTO l_found
7193: FROM ar_receivable_applications rap
7194: WHERE rap.cash_receipt_id = l_ra_rec.cash_receipt_id
7195: AND rap.applied_payment_schedule_id + 0 = -4
7196: AND rap.secondary_application_ref_id = p_secondary_application_ref_id
7197: AND rap.display = 'Y'

Line 7222: from ar_receivable_applications ra

7218: --
7219: BEGIN
7220: select nvl(sum(ra.amount_applied),0)
7221: into l_on_account_total
7222: from ar_receivable_applications ra
7223: where ra.cash_receipt_id = l_ra_rec.cash_receipt_id
7224: and ra.status IN ('ACC','OTHER ACC');
7225: EXCEPTION
7226: WHEN NO_DATA_FOUND then

Line 7857: from ar_receivable_applications

7853: cursor c_ra_app_id (p_cust_trx_id varchar2) is
7854: select receivable_application_id ra_app_id,
7855: amount_applied ,
7856: application_ref_type app_ref_type
7857: from ar_receivable_applications
7858: WHERE applied_customer_trx_id =p_cust_trx_id
7859: order by receivable_application_id;
7860: /*End of change, Bug 11841102*/
7861:

Line 8390: IN ar_receivable_applications.application_ref_id%TYPE,

8386: | |
8387: +===========================================================================*/
8388: PROCEDURE reverse_action_receipt_cb(
8389: p_chargeback_customer_trx_id
8390: IN ar_receivable_applications.application_ref_id%TYPE,
8391: p_reversal_gl_date IN DATE,
8392: p_reversal_date IN DATE,
8393: p_module_name IN VARCHAR2,
8394: p_module_version IN VARCHAR2 ) IS

Line 8451: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,

8447: | MODIFICATION HISTORY - Created by Ramakant Alat 18-JUN-01 |
8448: | |
8449: +===========================================================================*/
8450: PROCEDURE reverse_action_misc_receipt(
8451: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,
8452: p_reversal_gl_date IN DATE,
8453: p_reversal_date IN DATE,
8454: p_reversal_comments IN VARCHAR2 DEFAULT NULL,
8455: p_called_from IN VARCHAR2 DEFAULT NULL) IS

Line 8659: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

8655: +===========================================================================*/
8656: PROCEDURE cm_activity_application(
8657: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8658: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8659: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8660: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8661: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8662: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8663: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,

Line 8660: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

8656: PROCEDURE cm_activity_application(
8657: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8658: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8659: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8660: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8661: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8662: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8663: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8664: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

Line 8661: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

8657: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8658: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8659: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8660: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8661: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8662: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8663: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8664: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8665: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

Line 8662: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

8658: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8659: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8660: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8661: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8662: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8663: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8664: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8665: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8666: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

Line 8663: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,

8659: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8660: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8661: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8662: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8663: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8664: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8665: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8666: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8667: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

Line 8664: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

8660: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8661: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8662: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8663: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8664: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8665: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8666: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8667: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8668: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

Line 8665: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

8661: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8662: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8663: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8664: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8665: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8666: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8667: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8668: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8669: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

Line 8666: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

8662: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8663: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8664: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8665: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8666: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8667: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8668: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8669: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8670: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

Line 8667: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

8663: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8664: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8665: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8666: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8667: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8668: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8669: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8670: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8671: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

Line 8668: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

8664: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8665: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8666: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8667: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8668: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8669: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8670: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8671: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8672: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

Line 8669: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

8665: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8666: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8667: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8668: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8669: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8670: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8671: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8672: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8673: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

Line 8670: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

8666: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8667: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8668: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8669: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8670: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8671: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8672: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8673: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8674: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

Line 8671: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

8667: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8668: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8669: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8670: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8671: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8672: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8673: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8674: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8675: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

Line 8672: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

8668: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8669: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8670: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8671: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8672: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8673: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8674: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8675: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8676: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

Line 8673: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

8669: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8670: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8671: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8672: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8673: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8674: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8675: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8676: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8677: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

Line 8674: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

8670: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8671: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8672: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8673: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8674: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8675: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8676: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8677: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8678: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

Line 8675: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

8671: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8672: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8673: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8674: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8675: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8676: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8677: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8678: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8679: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

Line 8676: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

8672: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8673: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8674: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8675: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8676: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8677: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8678: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8679: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8680: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

Line 8677: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

8673: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8674: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8675: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8676: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8677: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8678: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8679: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8680: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8681: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

Line 8678: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

8674: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8675: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8676: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8677: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8678: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8679: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8680: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8681: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8682: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

Line 8679: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

8675: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8676: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8677: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8678: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8679: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8680: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8681: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8682: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8683: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

Line 8680: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

8676: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8677: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8678: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8679: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8680: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8681: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8682: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8683: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8684: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

Line 8681: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

8677: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8678: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8679: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8680: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8681: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8682: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8683: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8684: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8685: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

Line 8682: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

8678: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8679: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8680: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8681: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8682: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8683: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8684: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8685: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8686: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

Line 8683: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

8679: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8680: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8681: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8682: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8683: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8684: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8685: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8686: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8687: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

Line 8684: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

8680: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8681: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8682: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8683: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8684: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8685: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8686: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8687: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8688: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

Line 8685: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

8681: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8682: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8683: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8684: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8685: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8686: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8687: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8688: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8689: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

Line 8686: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

8682: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8683: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8684: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8685: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8686: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8687: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8688: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8689: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8690: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

Line 8687: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

8683: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8684: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8685: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8686: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8687: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8688: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8689: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8690: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8691: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

Line 8688: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

8684: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8685: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8686: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8687: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8688: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8689: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8690: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8691: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8692: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

Line 8689: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

8685: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8686: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8687: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8688: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8689: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8690: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8691: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8692: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8693: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

Line 8690: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

8686: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8687: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8688: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8689: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8690: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8691: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8692: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8693: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8694: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

Line 8691: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

8687: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8688: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8689: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8690: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8691: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8692: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8693: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8694: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8695: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

Line 8692: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

8688: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8689: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8690: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8691: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8692: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8693: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8694: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8695: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8696: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

Line 8693: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

8689: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8690: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8691: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8692: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8693: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8694: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8695: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8696: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8697: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

Line 8694: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

8690: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8691: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8692: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8693: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8694: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8695: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8696: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8697: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8698: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

Line 8695: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

8691: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8692: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8693: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8694: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8695: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8696: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8697: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8698: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8699: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

Line 8696: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

8692: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8693: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8694: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8695: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8696: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8697: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8698: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8699: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8700: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,

Line 8697: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

8693: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8694: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8695: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8696: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8697: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8698: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8699: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8700: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
8701: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

Line 8698: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

8694: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8695: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8696: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8697: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8698: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8699: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8700: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
8701: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
8702: p_comments IN ar_receivable_applications.comments%TYPE ,

Line 8699: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

8695: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8696: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8697: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8698: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8699: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8700: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
8701: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
8702: p_comments IN ar_receivable_applications.comments%TYPE ,
8703: p_module_name IN VARCHAR2,

Line 8700: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,

8696: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8697: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8698: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8699: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8700: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
8701: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
8702: p_comments IN ar_receivable_applications.comments%TYPE ,
8703: p_module_name IN VARCHAR2,
8704: p_module_version IN VARCHAR2,

Line 8702: p_comments IN ar_receivable_applications.comments%TYPE ,

8698: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8699: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8700: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
8701: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
8702: p_comments IN ar_receivable_applications.comments%TYPE ,
8703: p_module_name IN VARCHAR2,
8704: p_module_version IN VARCHAR2,
8705: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
8706: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,

Line 8705: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,

8701: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
8702: p_comments IN ar_receivable_applications.comments%TYPE ,
8703: p_module_name IN VARCHAR2,
8704: p_module_version IN VARCHAR2,
8705: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
8706: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
8707: -- OUT NOCOPY
8708: p_out_rec_application_id OUT NOCOPY NUMBER,
8709: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,

Line 8706: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,

8702: p_comments IN ar_receivable_applications.comments%TYPE ,
8703: p_module_name IN VARCHAR2,
8704: p_module_version IN VARCHAR2,
8705: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
8706: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
8707: -- OUT NOCOPY
8708: p_out_rec_application_id OUT NOCOPY NUMBER,
8709: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
8710: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

Line 8709: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,

8705: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
8706: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
8707: -- OUT NOCOPY
8708: p_out_rec_application_id OUT NOCOPY NUMBER,
8709: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
8710: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
8711: x_return_status OUT NOCOPY VARCHAR2,
8712: x_msg_count OUT NOCOPY NUMBER,
8713: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 8710: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

8706: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
8707: -- OUT NOCOPY
8708: p_out_rec_application_id OUT NOCOPY NUMBER,
8709: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
8710: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
8711: x_return_status OUT NOCOPY VARCHAR2,
8712: x_msg_count OUT NOCOPY NUMBER,
8713: x_msg_data OUT NOCOPY VARCHAR2) IS
8714:

Line 8715: l_inv_ra_rec ar_receivable_applications%ROWTYPE;

8711: x_return_status OUT NOCOPY VARCHAR2,
8712: x_msg_count OUT NOCOPY NUMBER,
8713: x_msg_data OUT NOCOPY VARCHAR2) IS
8714:
8715: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
8716: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
8717: l_ae_doc_rec ae_doc_rec_type;
8718: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
8719: l_flag char;

Line 8726: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

8722: l_inv_bal_amount NUMBER;
8723: l_inv_orig_amount NUMBER;
8724: l_allow_over_application VARCHAR2(1);
8725: l_effective_amount_applied NUMBER;
8726: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
8727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
8728: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
8729: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
8730: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;

Line 8727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

8723: l_inv_orig_amount NUMBER;
8724: l_allow_over_application VARCHAR2(1);
8725: l_effective_amount_applied NUMBER;
8726: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
8727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
8728: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
8729: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
8730: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
8731: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type;

Line 8728: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

8724: l_allow_over_application VARCHAR2(1);
8725: l_effective_amount_applied NUMBER;
8726: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
8727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
8728: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
8729: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
8730: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
8731: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type;
8732: l_return_status VARCHAR2(1);

Line 8729: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

8725: l_effective_amount_applied NUMBER;
8726: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
8727: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
8728: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
8729: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
8730: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
8731: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type;
8732: l_return_status VARCHAR2(1);
8733: l_msg_count NUMBER;

Line 8743: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;

8739: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8740: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8741: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8742: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8743: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
8744: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
8745: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
8746: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
8747: l_rule_set_id number;

Line 8744: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;

8740: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8741: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8742: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8743: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
8744: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
8745: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
8746: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
8747: l_rule_set_id number;
8748:

Line 8745: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;

8741: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8742: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8743: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
8744: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
8745: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
8746: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
8747: l_rule_set_id number;
8748:
8749: l_receivable_application_id NUMBER;

Line 8746: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;

8742: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8743: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
8744: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
8745: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
8746: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
8747: l_rule_set_id number;
8748:
8749: l_receivable_application_id NUMBER;
8750:

Line 9072: For rec in (select receivable_application_id source_id from ar_receivable_applications ra

9068:
9069: BEGIN
9070: arp_debug.debug('arp_process_application.Unapply_Regular_CM()+');
9071:
9072: For rec in (select receivable_application_id source_id from ar_receivable_applications ra
9073: where customer_trx_id = p_cust_Trx_id
9074: and applied_customer_trx_id = p_app_cust_trx_id
9075: and exists (select 'x' from ar_distributions
9076: where source_id = ra.receivable_application_id

Line 9090: ar_receivable_applications ra

9086: where source_id = rec.source_id
9087: and source_table = 'RA'
9088: and ref_customer_trx_line_id in (select customer_trx_line_id
9089: from ra_customer_trx_lines ctl_cm,
9090: ar_receivable_applications ra
9091: where ra.receivable_application_id = rec.source_id
9092: and ra.customer_trx_id = ctl_cm.customer_trx_id
9093: and ctl_cm.previous_customer_trx_line_id is not null);
9094:

Line 9111: ar_receivable_applications ra

9107: and rownum = 1)
9108: where source_id = rec.source_id
9109: and ref_customer_trx_line_id in (select customer_trx_line_id
9110: from ra_customer_trx_lines ctl_inv,
9111: ar_receivable_applications ra
9112: where ra.receivable_application_id = rec.source_id
9113: and ra.applied_customer_trx_id = ctl_inv.customer_trx_id);
9114: l_cnt := sql%rowcount;
9115: