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 17: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

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

Line 22: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

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

Line 32: P_RA_ID IN AR_RECEIVABLE_APPLICATIONS.RECEIVABLE_APPLICATION_ID%TYPE,

28: P_MODULE_NAME IN VARCHAR2,
29: P_MODULE_VERSION IN VARCHAR2 );
30: --
31: PROCEDURE VALIDATE_ARGS(
32: P_RA_ID IN AR_RECEIVABLE_APPLICATIONS.RECEIVABLE_APPLICATION_ID%TYPE,
33: P_REVERSAL_GL_DATE IN DATE,
34: P_REVERSAL_DATE IN DATE,
35: P_MODULE_NAME IN VARCHAR2 );
36: --

Line 38: p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE

34: P_REVERSAL_DATE IN DATE,
35: P_MODULE_NAME IN VARCHAR2 );
36: --
37: PROCEDURE reversal_insert_oppos_ra_recs (
38: p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE
39: , p_app_rec_trx_type IN VARCHAR
40: , p_reversal_gl_date IN DATE
41: , p_reversal_date IN DATE
42: , p_module_name IN VARCHAR2

Line 48: , p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE

44: , p_rec_app_id OUT NOCOPY NUMBER); /* jrautiai BR implementation */
45:
46: PROCEDURE reversal_update_old_ra_rec(
47: p_reversal_gl_date DATE
48: , p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE
49: );
50:
51: PROCEDURE reversal_update_ps_recs (
52: p_ra_rec IN ar_receivable_applications%ROWTYPE

Line 52: p_ra_rec IN ar_receivable_applications%ROWTYPE

48: , p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE
49: );
50:
51: PROCEDURE reversal_update_ps_recs (
52: p_ra_rec IN ar_receivable_applications%ROWTYPE
53: , p_app_rec_trx_type IN VARCHAR
54: , p_reversal_gl_date IN DATE
55: , p_reversal_date IN DATE);
56: --

Line 58: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

54: , p_reversal_gl_date IN DATE
55: , p_reversal_date IN DATE);
56: --
57: PROCEDURE validate_reverse_action_args(
58: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
59: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
60: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
61: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
62: p_select_flag IN BOOLEAN );

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

61: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
62: p_select_flag IN BOOLEAN );
63: --
64: PROCEDURE validate_args_appdel(
65: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE );
66: --
67: PROCEDURE validate_receipt_appln_args(
68: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
69: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 70: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

66: --
67: PROCEDURE validate_receipt_appln_args(
68: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
69: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
70: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
71: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
72: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
73: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
74: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 71: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,

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

Line 72: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,

68: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
69: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
70: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
71: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
72: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
73: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
74: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
75: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
76: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,

Line 75: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,

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

Line 76: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,

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

Line 77: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

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

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

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

Line 84: ar_receivable_applications.amount_applied%TYPE,

80: PROCEDURE validate_cm_appln_args(
81: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
82: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
83: p_amount_applied IN
84: ar_receivable_applications.amount_applied%TYPE,
85: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
86: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
87: --
88: PROCEDURE validate_on_account_args(

Line 85: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

81: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
82: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
83: p_amount_applied IN
84: ar_receivable_applications.amount_applied%TYPE,
85: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
86: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
87: --
88: PROCEDURE validate_on_account_args(
89: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

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

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

Line 91: ar_receivable_applications.amount_applied%TYPE,

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

Line 92: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

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

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

89: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
90: p_amount_applied IN
91: ar_receivable_applications.amount_applied%TYPE,
92: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
93: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
94:
95: PROCEDURE validate_activity_args(
96: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
97: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

Line 97: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

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

Line 98: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,

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

Line 99: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

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

Line 100: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

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

Line 101: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

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

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

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

Line 105: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

101: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
102: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE);
103:
104: PROCEDURE validate_activity(
105: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
106: p_activity_type IN ar_receivables_trx.type%TYPE);
107:
108: PROCEDURE reverse_action_receipt_cb(
109: p_chargeback_customer_trx_id IN ar_receivable_applications.application_ref_id%TYPE,

Line 109: p_chargeback_customer_trx_id IN ar_receivable_applications.application_ref_id%TYPE,

105: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
106: p_activity_type IN ar_receivables_trx.type%TYPE);
107:
108: PROCEDURE reverse_action_receipt_cb(
109: p_chargeback_customer_trx_id IN ar_receivable_applications.application_ref_id%TYPE,
110: p_reversal_gl_date IN DATE,
111: p_reversal_date IN DATE,
112: p_module_name IN VARCHAR2,
113: p_module_version IN VARCHAR2);

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

118: , p_claim_number IN VARCHAR2
119: , p_flag IN VARCHAR2);
120:
121:
122: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,
123: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN;
124:
125: PROCEDURE reverse_action_misc_receipt(
126: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,

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

119: , p_flag IN VARCHAR2);
120:
121:
122: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,
123: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN;
124:
125: PROCEDURE reverse_action_misc_receipt(
126: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,
127: p_reversal_gl_date IN DATE,

Line 126: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,

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

Line 162: | AR_RECEIVABLE_APPLICATIONS table |

158: | SCOPE - PUBLIC |
159: | |
160: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
161: | arp_app_pkg.fetch_p - Fetch a record from |
162: | AR_RECEIVABLE_APPLICATIONS table |
163: | arp_app_pkg.lock_p - lock a record in |
164: | AR_RECEIVABLE_APPLICATIONS table |
165: | |
166: | ARGUMENTS : IN: |

Line 164: | AR_RECEIVABLE_APPLICATIONS table |

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

Line 205: l_ra_rec ar_receivable_applications%ROWTYPE;

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

Line 226: -- Populate the ar_receivable_applications record from

222: validate_args( p_ra_id,
223: p_reversal_gl_date,
224: p_reversal_date, p_module_name );
225:
226: -- Populate the ar_receivable_applications record from
227: -- ar_receivable_applications table.
228:
229: --Bug:4068781
230: BEGIN

Line 227: -- ar_receivable_applications table.

223: p_reversal_gl_date,
224: p_reversal_date, p_module_name );
225:
226: -- Populate the ar_receivable_applications record from
227: -- ar_receivable_applications table.
228:
229: --Bug:4068781
230: BEGIN
231: arp_app_pkg.lock_p( p_ra_id );

Line 372: -- Update the current ar_receivable_applications record.

368: end if;
369: END IF;
370:
371: ----------------------------------------------------------
372: -- Update the current ar_receivable_applications record.
373: -- Set reversal_gl_date and display_flag to 'N'.
374: --
375: ----------------------------------------------------------
376: reversal_update_old_ra_rec( p_reversal_gl_date, l_ra_rec );

Line 381: update ar_receivable_applications

377:
378: /* Bug fix 2877224
379: Update the UNAPP record which is paired with the APP record being reversed.
380: The reversal_gl_date needs to be populated */
381: update ar_receivable_applications
382: set reversal_gl_date = p_reversal_gl_date
383: where receivable_application_id = (select source_id
384: from ar_distributions
385: where source_table = 'RA'

Line 405: update ar_receivable_applications

401: arp_standard.debug('reverse: ' || 'gl_date = '||to_char(l_ra_rec.gl_date,'DD-MON-YYYY'));
402: arp_standard.debug('reverse: ' || 'apply_date = '||to_char(l_ra_rec.apply_date,'DD-MON-YYYY'));
403: END IF;
404: IF l_ra_rec.trans_to_receipt_rate is NOT NULL THEN
405: update ar_receivable_applications
406: set reversal_gl_date = p_reversal_gl_date
407: where receivable_application_id = (select max(receivable_application_id)
408: from ar_receivable_applications
409: where cash_receipt_id = l_ra_rec.cash_receipt_id

Line 408: from ar_receivable_applications

404: IF l_ra_rec.trans_to_receipt_rate is NOT NULL THEN
405: update ar_receivable_applications
406: set reversal_gl_date = p_reversal_gl_date
407: where receivable_application_id = (select max(receivable_application_id)
408: from ar_receivable_applications
409: where cash_receipt_id = l_ra_rec.cash_receipt_id
410: and status ='UNAPP'
411: and posting_control_id = l_ra_rec.posting_control_id
412: and nvl(gl_posted_date,sysdate) = nvl(l_ra_rec.gl_posted_date, sysdate)

Line 424: update ar_receivable_applications

420: and gl_date = l_ra_rec.gl_date
421: and apply_date = l_ra_rec.apply_date
422: and reversal_gl_date is NULL);
423: ELSE
424: update ar_receivable_applications
425: set reversal_gl_date = p_reversal_gl_date
426: where receivable_application_id = (select max(receivable_application_id)
427: from ar_receivable_applications
428: where cash_receipt_id = l_ra_rec.cash_receipt_id

Line 427: from ar_receivable_applications

423: ELSE
424: update ar_receivable_applications
425: set reversal_gl_date = p_reversal_gl_date
426: where receivable_application_id = (select max(receivable_application_id)
427: from ar_receivable_applications
428: where cash_receipt_id = l_ra_rec.cash_receipt_id
429: and status ='UNAPP'
430: and posting_control_id = l_ra_rec.posting_control_id
431: and nvl(gl_posted_date,sysdate) = nvl(l_ra_rec.gl_posted_date, sysdate)

Line 469: , ar_receivable_applications ra

465: INTO
466: ln_batch_id
467: FROM
468: ar_cash_receipt_history crh
469: , ar_receivable_applications ra
470: WHERE
471: ra.receivable_application_id = p_ra_id
472: AND ra.cash_receipt_id = crh.cash_receipt_id
473: AND crh.current_record_flag = 'Y';

Line 549: AR_RECEIVABLE_APPLICATIONS table. |

545: | Reverse a credit memo application. |
546: | The algorithm for reversing an cm application is |
547: 1. Reverse existing application using opposite |
548: amounts. This is done by creating a new row into |
549: AR_RECEIVABLE_APPLICATIONS table. |
550: 2. Update applied transaction row in AR_PAYMENT_SCHEDULES |
551: | |
552: | SCOPE - PUBLIC |
553: | |

Line 556: | AR_RECEIVABLE_APPLICATIONS table

552: | SCOPE - PUBLIC |
553: | |
554: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
555: | arp_app_pkg.fetch_p - Fetch a record from
556: | AR_RECEIVABLE_APPLICATIONS table
557: | |
558: | ARGUMENTS : IN: |
559: | pn_ra_id Id of application to be reversed
560: | pd_reversal_gl_date Reversal GL date

Line 584: lr_ra_rec ar_receivable_applications%ROWTYPE;

580: , pc_module_name IN VARCHAR2
581: , pc_module_version IN VARCHAR2
582: , p_called_from IN VARCHAR2 ) IS
583:
584: lr_ra_rec ar_receivable_applications%ROWTYPE;
585: l_rec_app_id NUMBER;
586: l_trx_type VARCHAR2(20);
587:
588: -- added for unapplication of regular CM

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

596: arp_standard.debug( 'arp_process_application.reverse_cm_app()+' );
597: END IF;
598:
599: -- -------------------------------------------------------------------
600: -- Get ready to insert application row into ar_receivable_applications.
601: -- We use table handler to insert the record.
602: -- -------------------------------------------------------------------
603:
604: -- Populate the ar_receivable_applications record from

Line 604: -- Populate the ar_receivable_applications record from

600: -- Get ready to insert application row into ar_receivable_applications.
601: -- We use table handler to insert the record.
602: -- -------------------------------------------------------------------
603:
604: -- Populate the ar_receivable_applications record from
605: -- ar_receivable_applications table. Use ar_receivable_application_id
606: -- for selection.
607:
608: --Bug:4068781

Line 605: -- ar_receivable_applications table. Use ar_receivable_application_id

601: -- We use table handler to insert the record.
602: -- -------------------------------------------------------------------
603:
604: -- Populate the ar_receivable_applications record from
605: -- ar_receivable_applications table. Use ar_receivable_application_id
606: -- for selection.
607:
608: --Bug:4068781
609: BEGIN

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

658: p_app_cust_trx_id => lr_ra_rec.applied_customer_trx_id);
659:
660: END IF;
661:
662: -- If status of ar_receivable_applications record is 'APP', then
663: -- reverse the application by updating ar_payment_schedule of the
664: -- invoice, also set actual date closed and gl_date_closed.
665:
666: IF ( NVL( lr_ra_rec.confirmed_flag, 'Y' ) = 'Y' ) THEN

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

681: , pd_reversal_gl_date
682: , pd_reversal_date );
683: END IF;
684:
685: -- Update the current ar_receivable_applications record and set
686: -- reversal_gl_date and display_flag to 'N'.
687:
688: reversal_update_old_ra_rec( pd_reversal_gl_date, lr_ra_rec );
689:

Line 690: -- Insert opposing application in ar_receivable_applications.

686: -- reversal_gl_date and display_flag to 'N'.
687:
688: reversal_update_old_ra_rec( pd_reversal_gl_date, lr_ra_rec );
689:
690: -- Insert opposing application in ar_receivable_applications.
691: -- NOTE: We are passing module name ARREREVB to simulate same effect
692: -- as reversing the receipt would cause. We are not doing the same kind
693: -- of reversing as normal application reverse is doing.
694:

Line 876: lr_ra_rec ar_receivable_applications%ROWTYPE;

872: p_global_attribute18 IN VARCHAR2,
873: p_global_attribute19 IN VARCHAR2,
874: p_global_attribute20 IN VARCHAR2 ) IS
875:
876: lr_ra_rec ar_receivable_applications%ROWTYPE;
877: functional_curr VARCHAR2(100);
878:
879: ln_amount_change NUMBER;
880: ln_cash_receipt_id NUMBER;

Line 883: l_app_ra_rec ar_receivable_applications%ROWTYPE;

879: ln_amount_change NUMBER;
880: ln_cash_receipt_id NUMBER;
881: ln_unapp_ra_id NUMBER;
882:
883: l_app_ra_rec ar_receivable_applications%ROWTYPE;
884:
885: BEGIN
886: IF PG_DEBUG in ('Y', 'C') THEN
887: arp_standard.debug( 'arp_process_application.update_selected_transaction()+');

Line 933: -- Populate the ar_receivable_applications record from

929: , 'pn_receipt_exchange_rate'
930: , 'NULL');
931: END IF;
932:
933: -- Populate the ar_receivable_applications record from
934: -- ar_receivable_applications table. Use ar_receivable_application_id
935: -- for selection.
936:
937: --Bug:4068781

Line 934: -- ar_receivable_applications table. Use ar_receivable_application_id

930: , 'NULL');
931: END IF;
932:
933: -- Populate the ar_receivable_applications record from
934: -- ar_receivable_applications table. Use ar_receivable_application_id
935: -- for selection.
936:
937: --Bug:4068781
938: BEGIN

Line 1037: from ar_receivable_applications ra

1033:
1034: -- Get the receivable application id for the UNAPP row.
1035: select ra.receivable_application_id
1036: into ln_unapp_ra_id
1037: from ar_receivable_applications ra
1038: where ra.cash_receipt_id = ln_cash_receipt_id
1039: and ra.status = 'UNAPP';
1040:
1041: --Bug:4068781

Line 1133: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

1129: | to APP_EXCEPTION.INVALID_ARGUMENT).
1130: | 2/2/1996 Harri Kaukovuo Fixed procedure to pass module name
1131: +===========================================================================*/
1132: PROCEDURE validate_args(
1133: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
1134: p_reversal_gl_date IN DATE,
1135: p_reversal_date IN DATE,
1136: p_module_name IN VARCHAR2 ) IS
1137: BEGIN

Line 1247: p_ra_rec IN ar_receivable_applications%ROWTYPE,

1243: | remaining amounts in the payment schedule
1244: | package.
1245: +===========================================================================*/
1246: PROCEDURE reversal_update_ps_recs (
1247: p_ra_rec IN ar_receivable_applications%ROWTYPE,
1248: -- Trx type is either
1249: -- AR_APP meaning that it is a cash receipt reversal
1250: -- AR_CM meaning that it is a credit memo reversal
1251: p_app_rec_trx_type IN VARCHAR,

Line 1383: | ar_receivable_applications table. |

1379: | |
1380: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1381: | ARCIAPPS.pls |
1382: | arp_app_pkg.insert_p Table handler to insert into |
1383: | ar_receivable_applications table. |
1384: | |
1385: | ARGUMENTS : IN: |
1386: | p_ra_rec Receivables application record |
1387: | p_reversal_gl_date Reversal GL date |

Line 1400: | Added second ar_receivable_applications

Line 1440: p_ra_rec IN OUT NOCOPY AR_RECEIVABLE_APPLICATIONS%ROWTYPE

1436: | 19-Dec-03 Jyoti Pandey Bug 2729626 Unapplied Amount is zero, but the
1437: | status of receipt is 'UNAPP'.
1438: +===========================================================================*/
1439: PROCEDURE reversal_insert_oppos_ra_recs (
1440: p_ra_rec IN OUT NOCOPY AR_RECEIVABLE_APPLICATIONS%ROWTYPE
1441: , p_app_rec_trx_type IN VARCHAR
1442: , p_reversal_gl_date DATE
1443: , p_reversal_date DATE
1444: , p_module_name IN VARCHAR2

Line 2011: -- They were fetched from AR_RECEIVABLE_APPLICATIONS table

2007: AND rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)
2008: AND rma.unedisc_receivables_trx_id = uned.receivables_trx_id (+);
2009:
2010: -- Remember that record fields have values already.
2011: -- They were fetched from AR_RECEIVABLE_APPLICATIONS table
2012: -- earlier in fetch_p(), in reverse procedure.
2013:
2014: -- Note that amount applied from is used if not null as this indicates
2015: -- that it is a cross currency application. For cross currency

Line 2163: from ar_receivable_applications ra

2159: considered of determining status */
2160:
2161: select nvl(sum(ra.amount_applied),0)
2162: into l_on_account_total
2163: from ar_receivable_applications ra
2164: where ra.cash_receipt_id = p_ra_rec.cash_receipt_id
2165: and ra.status IN ('ACC','OTHER ACC');
2166:
2167: IF (l_amount_due_remaining + l_on_account_total < 0)

Line 2204: | ar_receivable_applications table |

2200: | SCOPE - PUBLIC |
2201: | |
2202: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2203: | arp_app_pkg.update_p - table handler to update |
2204: | ar_receivable_applications table |
2205: | |
2206: | ARGUMENTS : IN: |
2207: | p_ra_rec - Receivables application record |
2208: | OUT: |

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

2216: | 21-Jul-97 Karen Lawrance Release 11.
2217: | Renamed procedure from modify_update_old_ra_rec
2218: +===========================================================================*/
2219: PROCEDURE reversal_update_old_ra_rec( p_reversal_gl_date DATE,
2220: p_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
2221: BEGIN
2222: IF PG_DEBUG in ('Y', 'C') THEN
2223: arp_standard.debug('validate_args: ' || 'arp_process_application.reversal_update_old_ra_rec()+' );
2224: END IF;

Line 2291: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

2287: | 02-Jun-01 S.Nambiar Bug 1808020 -Modified the routine to handle |
2288: | Activity and receipt chargeback |
2289: +===========================================================================*/
2290: FUNCTION check_reversable (
2291: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2292: p_module_name IN VARCHAR2,
2293: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
2294: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2295: l_ass_cr_id ar_adjustments.associated_cash_receipt_id%TYPE;

Line 2311: l_ra_rec ar_receivable_applications%ROWTYPE;

2307: l_adj_amount NUMBER;
2308: --
2309: l_cb_count NUMBER DEFAULT 0;
2310: l_over_appln_flag CHAR(1);
2311: l_ra_rec ar_receivable_applications%ROWTYPE;
2312: l_dummy NUMBER;
2313: BEGIN
2314: -- validate_args_appdel( p_ra_id );
2315: --

Line 2343: FROM ar_receivable_applications ra,

2339: l_bal,
2340: l_status,
2341: l_over_appln_flag,
2342: l_bal_org
2343: FROM ar_receivable_applications ra,
2344: ar_payment_schedules ps,
2345: ra_cust_trx_types ctt
2346: WHERE ra.receivable_application_id = p_ra_id
2347: AND ps.payment_schedule_id(+) = ra.applied_payment_schedule_id

Line 2381: FROM ar_receivable_applications ra,

2377: l_bal,
2378: l_status,
2379: l_over_appln_flag,
2380: l_bal_org
2381: FROM ar_receivable_applications ra,
2382: ar_payment_schedules ps,
2383: ra_cust_trx_types ctt
2384: WHERE ra.receivable_application_id = p_ra_id
2385: AND ps.customer_trx_id(+) = ra.application_ref_id

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

2627: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
2628: | |
2629: +===========================================================================*/
2630: PROCEDURE validate_args_appdel(
2631: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
2632: BEGIN
2633: IF PG_DEBUG in ('Y', 'C') THEN
2634: arp_standard.debug( 'arp_process_application.validate_args_appdel()+' );
2635: END IF;

Line 2692: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

2688: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
2689: | |
2690: +===========================================================================*/
2691: PROCEDURE reverse_action(
2692: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2693: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2694: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2695: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
2696: p_select_flag IN BOOLEAN,

Line 2758: FROM ar_receivable_applications

2754: SELECT cash_receipt_id,
2755: applied_payment_schedule_id
2756: INTO l_ass_cr_id,
2757: l_ps_id
2758: FROM ar_receivable_applications
2759: WHERE receivable_application_id = p_ra_id;
2760: EXCEPTION
2761: WHEN NO_DATA_FOUND THEN
2762: IF PG_DEBUG in ('Y', 'C') THEN

Line 2995: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

2991: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
2992: | |
2993: +===========================================================================*/
2994: PROCEDURE validate_reverse_action_args(
2995: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2996: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2997: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2998: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
2999: p_select_flag IN BOOLEAN ) IS

Line 3150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

3146: +===========================================================================*/
3147: PROCEDURE receipt_application(
3148: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3149: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
3151: p_amount_applied_from IN
3152: ar_receivable_applications.amount_applied_from%TYPE,
3153: p_trans_to_receipt_rate IN
3154: ar_receivable_applications.trans_to_receipt_rate%TYPE,

Line 3152: ar_receivable_applications.amount_applied_from%TYPE,

3148: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3149: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
3151: p_amount_applied_from IN
3152: ar_receivable_applications.amount_applied_from%TYPE,
3153: p_trans_to_receipt_rate IN
3154: ar_receivable_applications.trans_to_receipt_rate%TYPE,
3155: p_invoice_currency_code IN
3156: ar_payment_schedules.invoice_currency_code%TYPE,

Line 3154: ar_receivable_applications.trans_to_receipt_rate%TYPE,

3150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
3151: p_amount_applied_from IN
3152: ar_receivable_applications.amount_applied_from%TYPE,
3153: p_trans_to_receipt_rate IN
3154: ar_receivable_applications.trans_to_receipt_rate%TYPE,
3155: p_invoice_currency_code IN
3156: ar_payment_schedules.invoice_currency_code%TYPE,
3157: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
3158: p_earned_discount_taken IN

Line 3159: ar_receivable_applications.earned_discount_taken%TYPE,

3155: p_invoice_currency_code IN
3156: ar_payment_schedules.invoice_currency_code%TYPE,
3157: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
3158: p_earned_discount_taken IN
3159: ar_receivable_applications.earned_discount_taken%TYPE,
3160: p_unearned_discount_taken IN
3161: ar_receivable_applications.unearned_discount_taken%TYPE,
3162: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
3163: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 3161: ar_receivable_applications.unearned_discount_taken%TYPE,

3157: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
3158: p_earned_discount_taken IN
3159: ar_receivable_applications.earned_discount_taken%TYPE,
3160: p_unearned_discount_taken IN
3161: ar_receivable_applications.unearned_discount_taken%TYPE,
3162: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
3163: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
3164: p_ussgl_transaction_code IN
3165: ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 3162: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

3158: p_earned_discount_taken IN
3159: ar_receivable_applications.earned_discount_taken%TYPE,
3160: p_unearned_discount_taken IN
3161: ar_receivable_applications.unearned_discount_taken%TYPE,
3162: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
3163: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
3164: p_ussgl_transaction_code IN
3165: ar_receivable_applications.ussgl_transaction_code%TYPE,
3166: p_customer_trx_line_id IN

Line 3163: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

3159: ar_receivable_applications.earned_discount_taken%TYPE,
3160: p_unearned_discount_taken IN
3161: ar_receivable_applications.unearned_discount_taken%TYPE,
3162: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
3163: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
3164: p_ussgl_transaction_code IN
3165: ar_receivable_applications.ussgl_transaction_code%TYPE,
3166: p_customer_trx_line_id IN
3167: ar_receivable_applications.applied_customer_trx_line_id%TYPE,

Line 3165: ar_receivable_applications.ussgl_transaction_code%TYPE,

3161: ar_receivable_applications.unearned_discount_taken%TYPE,
3162: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
3163: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
3164: p_ussgl_transaction_code IN
3165: ar_receivable_applications.ussgl_transaction_code%TYPE,
3166: p_customer_trx_line_id IN
3167: ar_receivable_applications.applied_customer_trx_line_id%TYPE,
3168: p_application_ref_type IN
3169: ar_receivable_applications.application_ref_type%TYPE,

Line 3167: ar_receivable_applications.applied_customer_trx_line_id%TYPE,

3163: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
3164: p_ussgl_transaction_code IN
3165: ar_receivable_applications.ussgl_transaction_code%TYPE,
3166: p_customer_trx_line_id IN
3167: ar_receivable_applications.applied_customer_trx_line_id%TYPE,
3168: p_application_ref_type IN
3169: ar_receivable_applications.application_ref_type%TYPE,
3170: p_application_ref_id IN
3171: ar_receivable_applications.application_ref_id%TYPE,

Line 3169: ar_receivable_applications.application_ref_type%TYPE,

3165: ar_receivable_applications.ussgl_transaction_code%TYPE,
3166: p_customer_trx_line_id IN
3167: ar_receivable_applications.applied_customer_trx_line_id%TYPE,
3168: p_application_ref_type IN
3169: ar_receivable_applications.application_ref_type%TYPE,
3170: p_application_ref_id IN
3171: ar_receivable_applications.application_ref_id%TYPE,
3172: p_application_ref_num IN
3173: ar_receivable_applications.application_ref_num%TYPE,

Line 3171: ar_receivable_applications.application_ref_id%TYPE,

3167: ar_receivable_applications.applied_customer_trx_line_id%TYPE,
3168: p_application_ref_type IN
3169: ar_receivable_applications.application_ref_type%TYPE,
3170: p_application_ref_id IN
3171: ar_receivable_applications.application_ref_id%TYPE,
3172: p_application_ref_num IN
3173: ar_receivable_applications.application_ref_num%TYPE,
3174: p_secondary_application_ref_id IN
3175: ar_receivable_applications.secondary_application_ref_id%TYPE,

Line 3173: ar_receivable_applications.application_ref_num%TYPE,

3169: ar_receivable_applications.application_ref_type%TYPE,
3170: p_application_ref_id IN
3171: ar_receivable_applications.application_ref_id%TYPE,
3172: p_application_ref_num IN
3173: ar_receivable_applications.application_ref_num%TYPE,
3174: p_secondary_application_ref_id IN
3175: ar_receivable_applications.secondary_application_ref_id%TYPE,
3176: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3177: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

Line 3175: ar_receivable_applications.secondary_application_ref_id%TYPE,

3171: ar_receivable_applications.application_ref_id%TYPE,
3172: p_application_ref_num IN
3173: ar_receivable_applications.application_ref_num%TYPE,
3174: p_secondary_application_ref_id IN
3175: ar_receivable_applications.secondary_application_ref_id%TYPE,
3176: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3177: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3178: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3179: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

Line 3176: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,

3172: p_application_ref_num IN
3173: ar_receivable_applications.application_ref_num%TYPE,
3174: p_secondary_application_ref_id IN
3175: ar_receivable_applications.secondary_application_ref_id%TYPE,
3176: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3177: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3178: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3179: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3180: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

Line 3177: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

3173: ar_receivable_applications.application_ref_num%TYPE,
3174: p_secondary_application_ref_id IN
3175: ar_receivable_applications.secondary_application_ref_id%TYPE,
3176: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3177: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3178: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3179: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3180: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3181: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

Line 3178: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

3174: p_secondary_application_ref_id IN
3175: ar_receivable_applications.secondary_application_ref_id%TYPE,
3176: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3177: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3178: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3179: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3180: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3181: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3182: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

Line 3179: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

3175: ar_receivable_applications.secondary_application_ref_id%TYPE,
3176: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3177: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3178: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3179: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3180: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3181: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3182: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3183: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

Line 3180: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

3176: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
3177: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3178: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3179: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3180: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3181: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3182: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3183: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3184: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

Line 3181: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

3177: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
3178: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3179: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3180: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3181: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3182: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3183: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3184: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3185: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

Line 3182: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

3178: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
3179: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3180: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3181: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3182: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3183: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3184: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3185: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3186: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

Line 3183: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

3179: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
3180: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3181: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3182: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3183: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3184: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3185: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3186: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3187: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

Line 3184: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

3180: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
3181: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3182: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3183: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3184: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3185: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3186: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3187: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3188: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

Line 3185: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

3181: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
3182: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3183: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3184: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3185: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3186: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3187: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3188: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3189: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

Line 3186: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

3182: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
3183: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3184: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3185: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3186: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3187: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3188: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3189: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3190: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

Line 3187: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

3183: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
3184: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3185: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3186: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3187: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3188: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3189: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3190: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3191: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

Line 3188: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

3184: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
3185: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3186: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3187: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3188: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3189: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3190: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3191: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3192: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

Line 3189: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

3185: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
3186: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3187: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3188: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3189: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3190: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3191: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3192: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3193: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

Line 3190: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

3186: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
3187: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3188: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3189: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3190: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3191: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3192: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3193: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3194: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

Line 3191: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

3187: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
3188: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3189: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3190: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3191: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3192: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3193: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3194: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3195: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

Line 3192: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

3188: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
3189: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3190: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3191: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3192: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3193: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3194: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3195: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3196: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

Line 3193: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

3189: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
3190: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3191: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3192: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3193: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3194: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3195: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3196: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3197: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

Line 3194: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

3190: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
3191: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3192: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3193: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3194: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3195: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3196: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3197: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3198: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

Line 3195: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

3191: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
3192: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3193: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3194: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3195: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3196: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3197: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3198: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3199: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

Line 3196: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

3192: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
3193: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3194: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3195: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3196: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3197: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3198: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3199: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3200: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

Line 3197: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

3193: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
3194: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3195: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3196: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3197: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3198: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3199: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3200: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3201: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

Line 3198: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

3194: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
3195: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3196: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3197: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3198: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3199: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3200: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3201: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3202: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

Line 3199: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

3195: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
3196: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3197: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3198: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3199: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3200: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3201: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3202: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3203: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

Line 3200: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

3196: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
3197: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3198: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3199: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3200: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3201: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3202: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3203: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3204: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

Line 3201: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

3197: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
3198: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3199: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3200: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3201: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3202: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3203: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3204: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3205: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

Line 3202: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

3198: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
3199: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3200: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3201: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3202: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3203: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3204: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3205: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3206: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

Line 3203: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

3199: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
3200: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3201: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3202: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3203: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3204: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3205: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3206: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3207: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

Line 3204: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

3200: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
3201: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3202: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3203: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3204: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3205: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3206: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3207: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3208: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

Line 3205: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

3201: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
3202: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3203: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3204: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3205: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3206: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3207: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3208: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3209: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

Line 3206: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

3202: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
3203: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3204: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3205: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3206: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3207: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3208: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3209: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3210: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

Line 3207: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

3203: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
3204: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3205: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3206: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3207: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3208: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3209: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3210: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3211: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

Line 3208: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

3204: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
3205: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3206: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3207: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3208: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3209: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3210: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3211: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3212: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

Line 3209: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

3205: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
3206: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3207: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3208: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3209: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3210: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3211: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3212: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
3213: p_comments IN ar_receivable_applications.comments%TYPE,

Line 3210: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

3206: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
3207: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3208: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3209: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3210: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3211: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3212: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
3213: p_comments IN ar_receivable_applications.comments%TYPE,
3214: p_module_name IN VARCHAR2,

Line 3211: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

3207: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
3208: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3209: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3210: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3211: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3212: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
3213: p_comments IN ar_receivable_applications.comments%TYPE,
3214: p_module_name IN VARCHAR2,
3215: p_module_version IN VARCHAR2,

Line 3212: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

3208: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
3209: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3210: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3211: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3212: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
3213: p_comments IN ar_receivable_applications.comments%TYPE,
3214: p_module_name IN VARCHAR2,
3215: p_module_version IN VARCHAR2,
3216: -- OUT NOCOPY

Line 3213: p_comments IN ar_receivable_applications.comments%TYPE,

3209: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
3210: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
3211: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
3212: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
3213: p_comments IN ar_receivable_applications.comments%TYPE,
3214: p_module_name IN VARCHAR2,
3215: p_module_version IN VARCHAR2,
3216: -- OUT NOCOPY
3217: x_application_ref_id OUT NOCOPY

Line 3218: ar_receivable_applications.application_ref_id%TYPE,

3214: p_module_name IN VARCHAR2,
3215: p_module_version IN VARCHAR2,
3216: -- OUT NOCOPY
3217: x_application_ref_id OUT NOCOPY
3218: ar_receivable_applications.application_ref_id%TYPE,
3219: x_application_ref_num OUT NOCOPY
3220: ar_receivable_applications.application_ref_num%TYPE,
3221: x_return_status OUT NOCOPY VARCHAR2,
3222: x_msg_count OUT NOCOPY NUMBER,

Line 3220: ar_receivable_applications.application_ref_num%TYPE,

3216: -- OUT NOCOPY
3217: x_application_ref_id OUT NOCOPY
3218: ar_receivable_applications.application_ref_id%TYPE,
3219: x_application_ref_num OUT NOCOPY
3220: ar_receivable_applications.application_ref_num%TYPE,
3221: x_return_status OUT NOCOPY VARCHAR2,
3222: x_msg_count OUT NOCOPY NUMBER,
3223: x_msg_data OUT NOCOPY VARCHAR2,
3224: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

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

3220: ar_receivable_applications.application_ref_num%TYPE,
3221: x_return_status OUT NOCOPY VARCHAR2,
3222: x_msg_count OUT NOCOPY NUMBER,
3223: x_msg_data OUT NOCOPY VARCHAR2,
3224: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
3225: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
3226: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
3227: x_claim_reason_name OUT NOCOPY VARCHAR2,
3228: p_called_from IN VARCHAR2, /* jrautiai BR implementation */

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

3221: x_return_status OUT NOCOPY VARCHAR2,
3222: x_msg_count OUT NOCOPY NUMBER,
3223: x_msg_data OUT NOCOPY VARCHAR2,
3224: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
3225: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
3226: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
3227: x_claim_reason_name OUT NOCOPY VARCHAR2,
3228: p_called_from IN VARCHAR2, /* jrautiai BR implementation */
3229: p_move_deferred_tax IN VARCHAR2, /* jrautiai BR implementation */

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

3222: x_msg_count OUT NOCOPY NUMBER,
3223: x_msg_data OUT NOCOPY VARCHAR2,
3224: p_out_rec_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
3225: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
3226: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
3227: x_claim_reason_name OUT NOCOPY VARCHAR2,
3228: p_called_from IN VARCHAR2, /* jrautiai BR implementation */
3229: p_move_deferred_tax IN VARCHAR2, /* jrautiai BR implementation */
3230: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */

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

3226: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
3227: x_claim_reason_name OUT NOCOPY VARCHAR2,
3228: p_called_from IN VARCHAR2, /* jrautiai BR implementation */
3229: p_move_deferred_tax IN VARCHAR2, /* jrautiai BR implementation */
3230: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */
3231: p_amount_due_remaining IN
3232: ar_payment_schedules.amount_due_remaining%TYPE,
3233: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3234: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,

Line 3233: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,

3229: p_move_deferred_tax IN VARCHAR2, /* jrautiai BR implementation */
3230: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */
3231: p_amount_due_remaining IN
3232: ar_payment_schedules.amount_due_remaining%TYPE,
3233: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3234: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
3235: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
3236: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
3237: from_llca_call IN VARCHAR2 DEFAULT 'N',

Line 3234: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,

3230: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */
3231: p_amount_due_remaining IN
3232: ar_payment_schedules.amount_due_remaining%TYPE,
3233: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3234: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
3235: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
3236: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
3237: from_llca_call IN VARCHAR2 DEFAULT 'N',
3238: p_gt_id IN NUMBER DEFAULT NULL

Line 3235: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,

3231: p_amount_due_remaining IN
3232: ar_payment_schedules.amount_due_remaining%TYPE,
3233: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3234: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
3235: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
3236: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
3237: from_llca_call IN VARCHAR2 DEFAULT 'N',
3238: p_gt_id IN NUMBER DEFAULT NULL
3239: ) IS

Line 3236: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,

3232: ar_payment_schedules.amount_due_remaining%TYPE,
3233: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3234: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
3235: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
3236: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
3237: from_llca_call IN VARCHAR2 DEFAULT 'N',
3238: p_gt_id IN NUMBER DEFAULT NULL
3239: ) IS
3240:

Line 3241: l_rec_ra_rec ar_receivable_applications%ROWTYPE;

3237: from_llca_call IN VARCHAR2 DEFAULT 'N',
3238: p_gt_id IN NUMBER DEFAULT NULL
3239: ) IS
3240:
3241: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
3242: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
3243:
3244: l_cr_rec ar_cash_receipts%ROWTYPE;
3245: l_amount_due_remaining NUMBER;

Line 3242: l_inv_ra_rec ar_receivable_applications%ROWTYPE;

3238: p_gt_id IN NUMBER DEFAULT NULL
3239: ) IS
3240:
3241: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
3242: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
3243:
3244: l_cr_rec ar_cash_receipts%ROWTYPE;
3245: l_amount_due_remaining NUMBER;
3246: ln_batch_id NUMBER;

Line 3372: from ar_receivable_applications rap

3368: BEGIN
3369: IF p_customer_trx_line_id IS NULL THEN
3370: select 'Y'
3371: into l_found
3372: from ar_receivable_applications rap
3373: where rap.payment_schedule_id = p_receipt_ps_id
3374: and rap.applied_payment_schedule_id = p_invoice_ps_id
3375: and rap.applied_customer_trx_line_id IS NULL /* Bug fix 1659928*/
3376: and rap.display = 'Y'

Line 3381: from ar_receivable_applications rap

3377: and rap.status = 'APP';
3378: ELSE
3379: select 'Y'
3380: into l_found
3381: from ar_receivable_applications rap
3382: where rap.payment_schedule_id = p_receipt_ps_id
3383: and rap.applied_payment_schedule_id = p_invoice_ps_id
3384: and rap.applied_customer_trx_line_id = p_customer_trx_line_id
3385: and rap.display = 'Y'

Line 3511: from ar_receivable_applications rap

3507:
3508: BEGIN
3509: select count(*)
3510: into l_count
3511: from ar_receivable_applications rap
3512: where rap.cash_receipt_id = l_rec_ra_rec.cash_receipt_id
3513: and rap.secondary_application_ref_id =
3514: p_secondary_application_ref_id
3515: and rap.application_ref_type = 'CLAIM'

Line 4080: from ar_receivable_applications ra

4076: -- fully applied.
4077: --
4078: select nvl(sum(ra.amount_applied),0)
4079: into l_on_account_total
4080: from ar_receivable_applications ra
4081: where ra.cash_receipt_id = l_rec_ra_rec.cash_receipt_id
4082: and ra.status IN ('ACC','OTHER ACC');
4083:
4084: -- Cash receipt must be fully applied in order to set the status

Line 4225: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

4221: +===========================================================================*/
4222: PROCEDURE validate_receipt_appln_args(
4223: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4224: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4225: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4226: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4227: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4228: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4229: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 4226: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,

4222: PROCEDURE validate_receipt_appln_args(
4223: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4224: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4225: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4226: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4227: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4228: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4229: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4230: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,

Line 4227: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,

4223: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4224: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4225: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4226: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4227: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4228: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4229: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4230: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4231: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,

Line 4230: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,

4226: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4227: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4228: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4229: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4230: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4231: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4232: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4233: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4234: BEGIN

Line 4231: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,

4227: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4228: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4229: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4230: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4231: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4232: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4233: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4234: BEGIN
4235: IF PG_DEBUG in ('Y', 'C') THEN

Line 4232: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

4228: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4229: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4230: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4231: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4232: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4233: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4234: BEGIN
4235: IF PG_DEBUG in ('Y', 'C') THEN
4236: arp_standard.debug( 'arp_process_application.validate_receipt_appln_args()+' );

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

4229: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4230: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4231: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4232: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4233: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4234: BEGIN
4235: IF PG_DEBUG in ('Y', 'C') THEN
4236: arp_standard.debug( 'arp_process_application.validate_receipt_appln_args()+' );
4237: END IF;

Line 4341: | mrc data for ar_receivable_applications

Line 4350: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

4346: +===========================================================================*/
4347: PROCEDURE cm_application(
4348: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4349: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4350: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4351: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4352: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4353: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4354: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,

Line 4351: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

4347: PROCEDURE cm_application(
4348: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4349: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4350: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4351: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4352: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4353: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4354: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4355: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

Line 4352: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

4348: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4349: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4350: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4351: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4352: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4353: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4354: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4355: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4356: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

Line 4353: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

4349: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4350: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4351: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4352: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4353: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4354: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4355: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4356: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4357: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

Line 4354: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,

4350: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4351: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4352: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4353: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4354: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4355: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4356: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4357: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4358: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

Line 4355: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

4351: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4352: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4353: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4354: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4355: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4356: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4357: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4358: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4359: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

Line 4356: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

4352: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4353: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4354: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4355: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4356: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4357: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4358: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4359: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4360: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

Line 4357: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

4353: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
4354: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4355: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4356: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4357: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4358: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4359: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4360: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4361: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

Line 4358: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

4354: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
4355: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4356: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4357: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4358: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4359: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4360: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4361: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4362: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

Line 4359: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

4355: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4356: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4357: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4358: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4359: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4360: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4361: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4362: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4363: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

Line 4360: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

4356: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4357: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4358: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4359: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4360: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4361: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4362: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4363: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4364: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

Line 4361: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

4357: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4358: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4359: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4360: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4361: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4362: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4363: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4364: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4365: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

Line 4362: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

4358: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4359: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4360: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4361: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4362: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4363: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4364: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4365: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4366: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

Line 4363: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

4359: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4360: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4361: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4362: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4363: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4364: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4365: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4366: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4367: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

Line 4364: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

4360: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4361: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4362: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4363: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4364: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4365: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4366: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4367: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4368: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

Line 4365: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

4361: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4362: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4363: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4364: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4365: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4366: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4367: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4368: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4369: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

Line 4366: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

4362: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4363: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4364: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4365: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4366: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4367: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4368: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4369: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4370: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

Line 4367: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

4363: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4364: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4365: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4366: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4367: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4368: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4369: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4370: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4371: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

Line 4368: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

4364: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4365: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4366: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4367: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4368: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4369: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4370: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4371: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4372: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

Line 4369: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

4365: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4366: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4367: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4368: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4369: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4370: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4371: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4372: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4373: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

Line 4370: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

4366: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4367: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4368: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4369: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4370: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4371: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4372: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4373: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4374: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

Line 4371: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

4367: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4368: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4369: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4370: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4371: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4372: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4373: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4374: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4375: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

Line 4372: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

4368: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4369: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4370: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4371: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4372: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4373: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4374: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4375: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4376: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

Line 4373: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

4369: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4370: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4371: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4372: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4373: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4374: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4375: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4376: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4377: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

Line 4374: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

4370: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4371: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4372: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4373: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4374: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4375: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4376: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4377: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4378: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

Line 4375: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

4371: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4372: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4373: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4374: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4375: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4376: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4377: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4378: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4379: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

Line 4376: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

4372: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4373: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4374: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4375: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4376: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4377: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4378: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4379: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4380: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

Line 4377: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

4373: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4374: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4375: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4376: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4377: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4378: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4379: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4380: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4381: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

Line 4378: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

4374: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4375: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4376: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4377: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4378: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4379: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4380: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4381: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4382: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

Line 4379: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

4375: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4376: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4377: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4378: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4379: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4380: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4381: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4382: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4383: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

Line 4380: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

4376: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4377: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4378: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4379: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4380: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4381: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4382: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4383: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4384: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

Line 4381: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

4377: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4378: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4379: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4380: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4381: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4382: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4383: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4384: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4385: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

Line 4382: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

4378: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4379: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4380: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4381: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4382: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4383: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4384: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4385: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4386: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

Line 4383: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

4379: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4380: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4381: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4382: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4383: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4384: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4385: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4386: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4387: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

Line 4384: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

4380: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4381: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4382: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4383: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4384: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4385: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4386: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4387: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4388: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

Line 4385: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

4381: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4382: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4383: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4384: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4385: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4386: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4387: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4388: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4389: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

Line 4386: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

4382: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4383: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4384: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4385: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4386: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4387: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4388: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4389: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4390: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

Line 4387: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

4383: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4384: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4385: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4386: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4387: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4388: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4389: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4390: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4391: p_customer_trx_line_id IN NUMBER,

Line 4388: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

4384: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4385: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4386: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4387: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4388: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4389: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4390: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4391: p_customer_trx_line_id IN NUMBER,
4392: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --bug2662270

Line 4389: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

4385: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4386: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4387: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4388: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4389: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4390: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4391: p_customer_trx_line_id IN NUMBER,
4392: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --bug2662270
4393: p_module_name IN VARCHAR2,

Line 4390: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

4386: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4387: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4388: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4389: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4390: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4391: p_customer_trx_line_id IN NUMBER,
4392: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --bug2662270
4393: p_module_name IN VARCHAR2,
4394: p_module_version IN VARCHAR2,

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

4388: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4389: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4390: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4391: p_customer_trx_line_id IN NUMBER,
4392: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL, --bug2662270
4393: p_module_name IN VARCHAR2,
4394: p_module_version IN VARCHAR2,
4395: -- OUT NOCOPY
4396: p_out_rec_application_id OUT NOCOPY NUMBER,

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

4393: p_module_name IN VARCHAR2,
4394: p_module_version IN VARCHAR2,
4395: -- OUT NOCOPY
4396: p_out_rec_application_id OUT NOCOPY NUMBER,
4397: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
4398: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE) IS
4399:
4400: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
4401: l_cm_ps_rec ar_payment_schedules%ROWTYPE;

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

4394: p_module_version IN VARCHAR2,
4395: -- OUT NOCOPY
4396: p_out_rec_application_id OUT NOCOPY NUMBER,
4397: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
4398: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE) IS
4399:
4400: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
4401: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
4402: l_ae_doc_rec ae_doc_rec_type;

Line 4400: l_inv_ra_rec ar_receivable_applications%ROWTYPE;

4396: p_out_rec_application_id OUT NOCOPY NUMBER,
4397: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
4398: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE) IS
4399:
4400: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
4401: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
4402: l_ae_doc_rec ae_doc_rec_type;
4403: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
4404: l_flag char; /* added for bug 2318048 */

Line 4446: from ar_receivable_applications rap

4442: BEGIN
4443: IF p_customer_trx_line_id IS NULL THEN
4444: select 'Y'
4445: into l_found
4446: from ar_receivable_applications rap
4447: where rap.payment_schedule_id = p_cm_ps_id
4448: and rap.applied_payment_schedule_id = p_invoice_ps_id
4449: and rap.applied_customer_trx_line_id IS NULL /* Bug fix 1659928 */
4450: and rap.display = 'Y'

Line 4455: from ar_receivable_applications rap

4451: and rap.status = 'APP';
4452: ELSE
4453: select 'Y'
4454: into l_found
4455: from ar_receivable_applications rap
4456: where rap.payment_schedule_id = p_cm_ps_id
4457: and rap.applied_payment_schedule_id = p_invoice_ps_id
4458: and rap.applied_customer_trx_line_id = p_customer_trx_line_id
4459: and rap.display = 'Y'

Line 4751: ar_receivable_applications.amount_applied%TYPE,

4747: PROCEDURE validate_cm_appln_args(
4748: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4749: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4750: p_amount_applied IN
4751: ar_receivable_applications.amount_applied%TYPE,
4752: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4753: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4754: BEGIN
4755: IF PG_DEBUG in ('Y', 'C') THEN

Line 4752: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

4748: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4749: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4750: p_amount_applied IN
4751: ar_receivable_applications.amount_applied%TYPE,
4752: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4753: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4754: BEGIN
4755: IF PG_DEBUG in ('Y', 'C') THEN
4756: arp_standard.debug(

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

4749: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4750: p_amount_applied IN
4751: ar_receivable_applications.amount_applied%TYPE,
4752: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4753: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
4754: BEGIN
4755: IF PG_DEBUG in ('Y', 'C') THEN
4756: arp_standard.debug(
4757: 'arp_process_application.validate_cm_appln_args()+' );

Line 4839: | inserts to ar_receivable_applications |

4835: | default value, hence all code calling this |
4836: | procedure and not passing comment is failing |
4837: | modify code to DEFAULT NULL |
4838: | 04-Sep-02 Debbie Jancis Added calls to mrc engine 3 for processing |
4839: | inserts to ar_receivable_applications |
4840: | 28-JUL-2003 Jon Beckett Bug 2821139 - added p_customer_reason. |
4841: +===========================================================================*/
4842: PROCEDURE on_account_receipts(
4843: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 4845: ar_receivable_applications.amount_applied%TYPE,

4841: +===========================================================================*/
4842: PROCEDURE on_account_receipts(
4843: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4844: p_amount_applied IN
4845: ar_receivable_applications.amount_applied%TYPE,
4846: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4847: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4848: p_ussgl_transaction_code IN
4849: ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 4846: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

4842: PROCEDURE on_account_receipts(
4843: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4844: p_amount_applied IN
4845: ar_receivable_applications.amount_applied%TYPE,
4846: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4847: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4848: p_ussgl_transaction_code IN
4849: ar_receivable_applications.ussgl_transaction_code%TYPE,
4850: p_attribute_category IN

Line 4847: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

4843: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4844: p_amount_applied IN
4845: ar_receivable_applications.amount_applied%TYPE,
4846: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4847: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4848: p_ussgl_transaction_code IN
4849: ar_receivable_applications.ussgl_transaction_code%TYPE,
4850: p_attribute_category IN
4851: ar_receivable_applications.attribute_category%TYPE,

Line 4849: ar_receivable_applications.ussgl_transaction_code%TYPE,

4845: ar_receivable_applications.amount_applied%TYPE,
4846: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4847: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4848: p_ussgl_transaction_code IN
4849: ar_receivable_applications.ussgl_transaction_code%TYPE,
4850: p_attribute_category IN
4851: ar_receivable_applications.attribute_category%TYPE,
4852: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4853: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

Line 4851: ar_receivable_applications.attribute_category%TYPE,

4847: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4848: p_ussgl_transaction_code IN
4849: ar_receivable_applications.ussgl_transaction_code%TYPE,
4850: p_attribute_category IN
4851: ar_receivable_applications.attribute_category%TYPE,
4852: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4853: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4854: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4855: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

Line 4852: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

4848: p_ussgl_transaction_code IN
4849: ar_receivable_applications.ussgl_transaction_code%TYPE,
4850: p_attribute_category IN
4851: ar_receivable_applications.attribute_category%TYPE,
4852: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4853: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4854: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4855: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4856: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

Line 4853: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

4849: ar_receivable_applications.ussgl_transaction_code%TYPE,
4850: p_attribute_category IN
4851: ar_receivable_applications.attribute_category%TYPE,
4852: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4853: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4854: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4855: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4856: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4857: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

Line 4854: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

4850: p_attribute_category IN
4851: ar_receivable_applications.attribute_category%TYPE,
4852: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4853: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4854: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4855: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4856: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4857: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4858: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

Line 4855: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

4851: ar_receivable_applications.attribute_category%TYPE,
4852: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4853: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4854: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4855: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4856: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4857: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4858: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4859: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

Line 4856: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

4852: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
4853: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4854: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4855: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4856: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4857: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4858: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4859: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4860: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

Line 4857: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

4853: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
4854: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4855: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4856: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4857: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4858: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4859: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4860: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4861: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

Line 4858: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

4854: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
4855: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4856: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4857: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4858: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4859: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4860: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4861: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4862: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

Line 4859: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

4855: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
4856: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4857: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4858: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4859: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4860: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4861: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4862: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4863: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

Line 4860: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

4856: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
4857: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4858: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4859: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4860: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4861: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4862: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4863: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4864: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

Line 4861: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

4857: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
4858: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4859: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4860: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4861: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4862: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4863: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4864: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4865: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

Line 4862: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

4858: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
4859: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4860: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4861: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4862: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4863: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4864: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4865: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4866: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

Line 4863: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

4859: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
4860: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4861: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4862: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4863: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4864: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4865: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4866: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4867: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

Line 4864: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

4860: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
4861: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4862: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4863: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4864: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4865: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4866: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4867: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4868: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

Line 4865: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

4861: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
4862: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4863: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4864: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4865: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4866: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4867: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4868: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4869: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

Line 4866: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

4862: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
4863: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4864: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4865: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4866: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4867: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4868: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4869: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4870: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

Line 4867: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

4863: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
4864: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4865: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4866: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4867: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4868: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4869: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4870: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4871: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

Line 4868: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

4864: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
4865: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4866: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4867: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4868: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4869: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4870: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4871: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4872: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

Line 4869: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

4865: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
4866: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4867: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4868: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4869: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4870: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4871: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4872: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4873: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

Line 4870: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

4866: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
4867: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4868: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4869: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4870: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4871: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4872: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4873: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4874: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

Line 4871: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

4867: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
4868: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4869: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4870: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4871: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4872: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4873: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4874: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4875: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

Line 4872: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

4868: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
4869: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4870: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4871: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4872: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4873: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4874: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4875: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4876: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

Line 4873: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

4869: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
4870: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4871: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4872: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4873: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4874: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4875: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4876: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4877: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

Line 4874: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

4870: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
4871: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4872: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4873: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4874: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4875: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4876: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4877: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4878: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

Line 4875: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

4871: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
4872: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4873: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4874: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4875: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4876: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4877: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4878: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4879: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

Line 4876: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

4872: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
4873: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4874: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4875: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4876: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4877: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4878: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4879: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4880: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

Line 4877: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

4873: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
4874: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4875: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4876: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4877: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4878: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4879: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4880: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4881: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

Line 4878: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

4874: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
4875: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4876: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4877: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4878: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4879: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4880: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4881: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4882: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

Line 4879: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

4875: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
4876: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4877: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4878: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4879: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4880: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4881: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4882: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4883: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

Line 4880: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

4876: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
4877: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4878: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4879: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4880: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4881: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4882: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4883: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4884: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

Line 4881: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

4877: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
4878: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4879: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4880: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4881: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4882: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4883: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4884: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4885: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

Line 4882: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

4878: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
4879: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4880: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4881: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4882: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4883: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4884: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4885: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4886: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

Line 4883: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

4879: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
4880: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4881: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4882: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4883: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4884: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4885: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4886: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4887: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

Line 4884: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

4880: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
4881: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4882: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4883: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4884: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4885: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4886: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4887: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4888: p_comments IN ar_receivable_applications.comments%TYPE,

Line 4885: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

4881: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
4882: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4883: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4884: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4885: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4886: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4887: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4888: p_comments IN ar_receivable_applications.comments%TYPE,
4889: p_module_name IN VARCHAR2,

Line 4886: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

4882: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
4883: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4884: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4885: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4886: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4887: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4888: p_comments IN ar_receivable_applications.comments%TYPE,
4889: p_module_name IN VARCHAR2,
4890: p_module_version IN VARCHAR2,

Line 4887: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

4883: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
4884: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4885: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4886: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4887: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4888: p_comments IN ar_receivable_applications.comments%TYPE,
4889: p_module_name IN VARCHAR2,
4890: p_module_version IN VARCHAR2,
4891: p_out_rec_application_id OUT NOCOPY NUMBER

Line 4888: p_comments IN ar_receivable_applications.comments%TYPE,

4884: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
4885: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
4886: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
4887: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
4888: p_comments IN ar_receivable_applications.comments%TYPE,
4889: p_module_name IN VARCHAR2,
4890: p_module_version IN VARCHAR2,
4891: p_out_rec_application_id OUT NOCOPY NUMBER
4892: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE

Line 4892: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE

4888: p_comments IN ar_receivable_applications.comments%TYPE,
4889: p_module_name IN VARCHAR2,
4890: p_module_version IN VARCHAR2,
4891: p_out_rec_application_id OUT NOCOPY NUMBER
4892: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
4893: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
4894: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
4895: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
4896: , p_secondary_app_ref_type IN

Line 4893: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE

4889: p_module_name IN VARCHAR2,
4890: p_module_version IN VARCHAR2,
4891: p_out_rec_application_id OUT NOCOPY NUMBER
4892: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
4893: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
4894: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
4895: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
4896: , p_secondary_app_ref_type IN
4897: ar_receivable_applications.secondary_application_ref_type%TYPE := null

Line 4894: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE

4890: p_module_version IN VARCHAR2,
4891: p_out_rec_application_id OUT NOCOPY NUMBER
4892: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
4893: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
4894: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
4895: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
4896: , p_secondary_app_ref_type IN
4897: ar_receivable_applications.secondary_application_ref_type%TYPE := null
4898: , p_secondary_app_ref_num IN

Line 4895: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE

4891: p_out_rec_application_id OUT NOCOPY NUMBER
4892: , p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
4893: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
4894: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
4895: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
4896: , p_secondary_app_ref_type IN
4897: ar_receivable_applications.secondary_application_ref_type%TYPE := null
4898: , p_secondary_app_ref_num IN
4899: ar_receivable_applications.secondary_application_ref_num%TYPE := null

Line 4897: ar_receivable_applications.secondary_application_ref_type%TYPE := null

4893: , p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
4894: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
4895: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
4896: , p_secondary_app_ref_type IN
4897: ar_receivable_applications.secondary_application_ref_type%TYPE := null
4898: , p_secondary_app_ref_num IN
4899: ar_receivable_applications.secondary_application_ref_num%TYPE := null
4900: ) IS
4901:

Line 4899: ar_receivable_applications.secondary_application_ref_num%TYPE := null

4895: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
4896: , p_secondary_app_ref_type IN
4897: ar_receivable_applications.secondary_application_ref_type%TYPE := null
4898: , p_secondary_app_ref_num IN
4899: ar_receivable_applications.secondary_application_ref_num%TYPE := null
4900: ) IS
4901:
4902: l_ra_rec ar_receivable_applications%ROWTYPE;
4903: l_ps_rec ar_payment_schedules%ROWTYPE;

Line 4902: l_ra_rec ar_receivable_applications%ROWTYPE;

4898: , p_secondary_app_ref_num IN
4899: ar_receivable_applications.secondary_application_ref_num%TYPE := null
4900: ) IS
4901:
4902: l_ra_rec ar_receivable_applications%ROWTYPE;
4903: l_ps_rec ar_payment_schedules%ROWTYPE;
4904:
4905: l_cr_rec ar_cash_receipts%ROWTYPE;
4906: l_amount_due_remaining NUMBER;

Line 4979: from ar_receivable_applications ra

4975: -- the On Account row that we are about to create.
4976: --
4977: select nvl(sum(ra.amount_applied),0)
4978: into l_on_account_total
4979: from ar_receivable_applications ra
4980: where ra.cash_receipt_id = l_ra_rec.cash_receipt_id
4981: and ra.status IN ('ACC','OTHER ACC');
4982:
4983: -- Prepare for 'UNAPP' record insertion with -ve amount applied

Line 5250: ar_receivable_applications.amount_applied%TYPE,

5246: +===========================================================================*/
5247: PROCEDURE validate_on_account_args(
5248: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5249: p_amount_applied IN
5250: ar_receivable_applications.amount_applied%TYPE,
5251: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5252: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
5253: BEGIN
5254: IF PG_DEBUG in ('Y', 'C') THEN

Line 5251: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

5247: PROCEDURE validate_on_account_args(
5248: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5249: p_amount_applied IN
5250: ar_receivable_applications.amount_applied%TYPE,
5251: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5252: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
5253: BEGIN
5254: IF PG_DEBUG in ('Y', 'C') THEN
5255: arp_standard.debug(

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

5248: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5249: p_amount_applied IN
5250: ar_receivable_applications.amount_applied%TYPE,
5251: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5252: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS
5253: BEGIN
5254: IF PG_DEBUG in ('Y', 'C') THEN
5255: arp_standard.debug(
5256: 'arp_process_application.validate_on_account_args()+' );

Line 5347: ar_receivable_applications.applied_payment_schedule_id%TYPE,

5343: PROCEDURE activity_application(
5344: p_receipt_ps_id IN
5345: ar_payment_schedules.payment_schedule_id%TYPE,
5346: p_application_ps_id IN
5347: ar_receivable_applications.applied_payment_schedule_id%TYPE,
5348: p_link_to_customer_trx_id IN
5349: ar_receivable_applications.link_to_customer_trx_id%TYPE,
5350: p_amount_applied IN
5351: ar_receivable_applications.amount_applied%TYPE,

Line 5349: ar_receivable_applications.link_to_customer_trx_id%TYPE,

5345: ar_payment_schedules.payment_schedule_id%TYPE,
5346: p_application_ps_id IN
5347: ar_receivable_applications.applied_payment_schedule_id%TYPE,
5348: p_link_to_customer_trx_id IN
5349: ar_receivable_applications.link_to_customer_trx_id%TYPE,
5350: p_amount_applied IN
5351: ar_receivable_applications.amount_applied%TYPE,
5352: p_apply_date IN
5353: ar_receivable_applications.apply_date%TYPE,

Line 5351: ar_receivable_applications.amount_applied%TYPE,

5347: ar_receivable_applications.applied_payment_schedule_id%TYPE,
5348: p_link_to_customer_trx_id IN
5349: ar_receivable_applications.link_to_customer_trx_id%TYPE,
5350: p_amount_applied IN
5351: ar_receivable_applications.amount_applied%TYPE,
5352: p_apply_date IN
5353: ar_receivable_applications.apply_date%TYPE,
5354: p_gl_date IN
5355: ar_receivable_applications.gl_date%TYPE,

Line 5353: ar_receivable_applications.apply_date%TYPE,

5349: ar_receivable_applications.link_to_customer_trx_id%TYPE,
5350: p_amount_applied IN
5351: ar_receivable_applications.amount_applied%TYPE,
5352: p_apply_date IN
5353: ar_receivable_applications.apply_date%TYPE,
5354: p_gl_date IN
5355: ar_receivable_applications.gl_date%TYPE,
5356: p_receivables_trx_id IN
5357: ar_receivable_applications.receivables_trx_id%TYPE,

Line 5355: ar_receivable_applications.gl_date%TYPE,

5351: ar_receivable_applications.amount_applied%TYPE,
5352: p_apply_date IN
5353: ar_receivable_applications.apply_date%TYPE,
5354: p_gl_date IN
5355: ar_receivable_applications.gl_date%TYPE,
5356: p_receivables_trx_id IN
5357: ar_receivable_applications.receivables_trx_id%TYPE,
5358: p_ussgl_transaction_code IN
5359: ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 5357: ar_receivable_applications.receivables_trx_id%TYPE,

5353: ar_receivable_applications.apply_date%TYPE,
5354: p_gl_date IN
5355: ar_receivable_applications.gl_date%TYPE,
5356: p_receivables_trx_id IN
5357: ar_receivable_applications.receivables_trx_id%TYPE,
5358: p_ussgl_transaction_code IN
5359: ar_receivable_applications.ussgl_transaction_code%TYPE,
5360: p_attribute_category IN
5361: ar_receivable_applications.attribute_category%TYPE,

Line 5359: ar_receivable_applications.ussgl_transaction_code%TYPE,

5355: ar_receivable_applications.gl_date%TYPE,
5356: p_receivables_trx_id IN
5357: ar_receivable_applications.receivables_trx_id%TYPE,
5358: p_ussgl_transaction_code IN
5359: ar_receivable_applications.ussgl_transaction_code%TYPE,
5360: p_attribute_category IN
5361: ar_receivable_applications.attribute_category%TYPE,
5362: p_attribute1 IN
5363: ar_receivable_applications.attribute1%TYPE,

Line 5361: ar_receivable_applications.attribute_category%TYPE,

5357: ar_receivable_applications.receivables_trx_id%TYPE,
5358: p_ussgl_transaction_code IN
5359: ar_receivable_applications.ussgl_transaction_code%TYPE,
5360: p_attribute_category IN
5361: ar_receivable_applications.attribute_category%TYPE,
5362: p_attribute1 IN
5363: ar_receivable_applications.attribute1%TYPE,
5364: p_attribute2 IN
5365: ar_receivable_applications.attribute2%TYPE,

Line 5363: ar_receivable_applications.attribute1%TYPE,

5359: ar_receivable_applications.ussgl_transaction_code%TYPE,
5360: p_attribute_category IN
5361: ar_receivable_applications.attribute_category%TYPE,
5362: p_attribute1 IN
5363: ar_receivable_applications.attribute1%TYPE,
5364: p_attribute2 IN
5365: ar_receivable_applications.attribute2%TYPE,
5366: p_attribute3 IN
5367: ar_receivable_applications.attribute3%TYPE,

Line 5365: ar_receivable_applications.attribute2%TYPE,

5361: ar_receivable_applications.attribute_category%TYPE,
5362: p_attribute1 IN
5363: ar_receivable_applications.attribute1%TYPE,
5364: p_attribute2 IN
5365: ar_receivable_applications.attribute2%TYPE,
5366: p_attribute3 IN
5367: ar_receivable_applications.attribute3%TYPE,
5368: p_attribute4 IN
5369: ar_receivable_applications.attribute4%TYPE,

Line 5367: ar_receivable_applications.attribute3%TYPE,

5363: ar_receivable_applications.attribute1%TYPE,
5364: p_attribute2 IN
5365: ar_receivable_applications.attribute2%TYPE,
5366: p_attribute3 IN
5367: ar_receivable_applications.attribute3%TYPE,
5368: p_attribute4 IN
5369: ar_receivable_applications.attribute4%TYPE,
5370: p_attribute5 IN
5371: ar_receivable_applications.attribute5%TYPE,

Line 5369: ar_receivable_applications.attribute4%TYPE,

5365: ar_receivable_applications.attribute2%TYPE,
5366: p_attribute3 IN
5367: ar_receivable_applications.attribute3%TYPE,
5368: p_attribute4 IN
5369: ar_receivable_applications.attribute4%TYPE,
5370: p_attribute5 IN
5371: ar_receivable_applications.attribute5%TYPE,
5372: p_attribute6 IN
5373: ar_receivable_applications.attribute6%TYPE,

Line 5371: ar_receivable_applications.attribute5%TYPE,

5367: ar_receivable_applications.attribute3%TYPE,
5368: p_attribute4 IN
5369: ar_receivable_applications.attribute4%TYPE,
5370: p_attribute5 IN
5371: ar_receivable_applications.attribute5%TYPE,
5372: p_attribute6 IN
5373: ar_receivable_applications.attribute6%TYPE,
5374: p_attribute7 IN
5375: ar_receivable_applications.attribute7%TYPE,

Line 5373: ar_receivable_applications.attribute6%TYPE,

5369: ar_receivable_applications.attribute4%TYPE,
5370: p_attribute5 IN
5371: ar_receivable_applications.attribute5%TYPE,
5372: p_attribute6 IN
5373: ar_receivable_applications.attribute6%TYPE,
5374: p_attribute7 IN
5375: ar_receivable_applications.attribute7%TYPE,
5376: p_attribute8 IN
5377: ar_receivable_applications.attribute8%TYPE,

Line 5375: ar_receivable_applications.attribute7%TYPE,

5371: ar_receivable_applications.attribute5%TYPE,
5372: p_attribute6 IN
5373: ar_receivable_applications.attribute6%TYPE,
5374: p_attribute7 IN
5375: ar_receivable_applications.attribute7%TYPE,
5376: p_attribute8 IN
5377: ar_receivable_applications.attribute8%TYPE,
5378: p_attribute9 IN
5379: ar_receivable_applications.attribute9%TYPE,

Line 5377: ar_receivable_applications.attribute8%TYPE,

5373: ar_receivable_applications.attribute6%TYPE,
5374: p_attribute7 IN
5375: ar_receivable_applications.attribute7%TYPE,
5376: p_attribute8 IN
5377: ar_receivable_applications.attribute8%TYPE,
5378: p_attribute9 IN
5379: ar_receivable_applications.attribute9%TYPE,
5380: p_attribute10 IN
5381: ar_receivable_applications.attribute10%TYPE,

Line 5379: ar_receivable_applications.attribute9%TYPE,

5375: ar_receivable_applications.attribute7%TYPE,
5376: p_attribute8 IN
5377: ar_receivable_applications.attribute8%TYPE,
5378: p_attribute9 IN
5379: ar_receivable_applications.attribute9%TYPE,
5380: p_attribute10 IN
5381: ar_receivable_applications.attribute10%TYPE,
5382: p_attribute11 IN
5383: ar_receivable_applications.attribute11%TYPE,

Line 5381: ar_receivable_applications.attribute10%TYPE,

5377: ar_receivable_applications.attribute8%TYPE,
5378: p_attribute9 IN
5379: ar_receivable_applications.attribute9%TYPE,
5380: p_attribute10 IN
5381: ar_receivable_applications.attribute10%TYPE,
5382: p_attribute11 IN
5383: ar_receivable_applications.attribute11%TYPE,
5384: p_attribute12 IN
5385: ar_receivable_applications.attribute12%TYPE,

Line 5383: ar_receivable_applications.attribute11%TYPE,

5379: ar_receivable_applications.attribute9%TYPE,
5380: p_attribute10 IN
5381: ar_receivable_applications.attribute10%TYPE,
5382: p_attribute11 IN
5383: ar_receivable_applications.attribute11%TYPE,
5384: p_attribute12 IN
5385: ar_receivable_applications.attribute12%TYPE,
5386: p_attribute13 IN
5387: ar_receivable_applications.attribute13%TYPE,

Line 5385: ar_receivable_applications.attribute12%TYPE,

5381: ar_receivable_applications.attribute10%TYPE,
5382: p_attribute11 IN
5383: ar_receivable_applications.attribute11%TYPE,
5384: p_attribute12 IN
5385: ar_receivable_applications.attribute12%TYPE,
5386: p_attribute13 IN
5387: ar_receivable_applications.attribute13%TYPE,
5388: p_attribute14 IN
5389: ar_receivable_applications.attribute14%TYPE,

Line 5387: ar_receivable_applications.attribute13%TYPE,

5383: ar_receivable_applications.attribute11%TYPE,
5384: p_attribute12 IN
5385: ar_receivable_applications.attribute12%TYPE,
5386: p_attribute13 IN
5387: ar_receivable_applications.attribute13%TYPE,
5388: p_attribute14 IN
5389: ar_receivable_applications.attribute14%TYPE,
5390: p_attribute15 IN
5391: ar_receivable_applications.attribute15%TYPE,

Line 5389: ar_receivable_applications.attribute14%TYPE,

5385: ar_receivable_applications.attribute12%TYPE,
5386: p_attribute13 IN
5387: ar_receivable_applications.attribute13%TYPE,
5388: p_attribute14 IN
5389: ar_receivable_applications.attribute14%TYPE,
5390: p_attribute15 IN
5391: ar_receivable_applications.attribute15%TYPE,
5392: p_global_attribute_category IN
5393: ar_receivable_applications.global_attribute_category%TYPE,

Line 5391: ar_receivable_applications.attribute15%TYPE,

5387: ar_receivable_applications.attribute13%TYPE,
5388: p_attribute14 IN
5389: ar_receivable_applications.attribute14%TYPE,
5390: p_attribute15 IN
5391: ar_receivable_applications.attribute15%TYPE,
5392: p_global_attribute_category IN
5393: ar_receivable_applications.global_attribute_category%TYPE,
5394: p_global_attribute1 IN
5395: ar_receivable_applications.global_attribute1%TYPE,

Line 5393: ar_receivable_applications.global_attribute_category%TYPE,

5389: ar_receivable_applications.attribute14%TYPE,
5390: p_attribute15 IN
5391: ar_receivable_applications.attribute15%TYPE,
5392: p_global_attribute_category IN
5393: ar_receivable_applications.global_attribute_category%TYPE,
5394: p_global_attribute1 IN
5395: ar_receivable_applications.global_attribute1%TYPE,
5396: p_global_attribute2 IN
5397: ar_receivable_applications.global_attribute2%TYPE,

Line 5395: ar_receivable_applications.global_attribute1%TYPE,

5391: ar_receivable_applications.attribute15%TYPE,
5392: p_global_attribute_category IN
5393: ar_receivable_applications.global_attribute_category%TYPE,
5394: p_global_attribute1 IN
5395: ar_receivable_applications.global_attribute1%TYPE,
5396: p_global_attribute2 IN
5397: ar_receivable_applications.global_attribute2%TYPE,
5398: p_global_attribute3 IN
5399: ar_receivable_applications.global_attribute3%TYPE,

Line 5397: ar_receivable_applications.global_attribute2%TYPE,

5393: ar_receivable_applications.global_attribute_category%TYPE,
5394: p_global_attribute1 IN
5395: ar_receivable_applications.global_attribute1%TYPE,
5396: p_global_attribute2 IN
5397: ar_receivable_applications.global_attribute2%TYPE,
5398: p_global_attribute3 IN
5399: ar_receivable_applications.global_attribute3%TYPE,
5400: p_global_attribute4 IN
5401: ar_receivable_applications.global_attribute4%TYPE,

Line 5399: ar_receivable_applications.global_attribute3%TYPE,

5395: ar_receivable_applications.global_attribute1%TYPE,
5396: p_global_attribute2 IN
5397: ar_receivable_applications.global_attribute2%TYPE,
5398: p_global_attribute3 IN
5399: ar_receivable_applications.global_attribute3%TYPE,
5400: p_global_attribute4 IN
5401: ar_receivable_applications.global_attribute4%TYPE,
5402: p_global_attribute5 IN
5403: ar_receivable_applications.global_attribute5%TYPE,

Line 5401: ar_receivable_applications.global_attribute4%TYPE,

5397: ar_receivable_applications.global_attribute2%TYPE,
5398: p_global_attribute3 IN
5399: ar_receivable_applications.global_attribute3%TYPE,
5400: p_global_attribute4 IN
5401: ar_receivable_applications.global_attribute4%TYPE,
5402: p_global_attribute5 IN
5403: ar_receivable_applications.global_attribute5%TYPE,
5404: p_global_attribute6 IN
5405: ar_receivable_applications.global_attribute6%TYPE,

Line 5403: ar_receivable_applications.global_attribute5%TYPE,

5399: ar_receivable_applications.global_attribute3%TYPE,
5400: p_global_attribute4 IN
5401: ar_receivable_applications.global_attribute4%TYPE,
5402: p_global_attribute5 IN
5403: ar_receivable_applications.global_attribute5%TYPE,
5404: p_global_attribute6 IN
5405: ar_receivable_applications.global_attribute6%TYPE,
5406: p_global_attribute7 IN
5407: ar_receivable_applications.global_attribute7%TYPE,

Line 5405: ar_receivable_applications.global_attribute6%TYPE,

5401: ar_receivable_applications.global_attribute4%TYPE,
5402: p_global_attribute5 IN
5403: ar_receivable_applications.global_attribute5%TYPE,
5404: p_global_attribute6 IN
5405: ar_receivable_applications.global_attribute6%TYPE,
5406: p_global_attribute7 IN
5407: ar_receivable_applications.global_attribute7%TYPE,
5408: p_global_attribute8 IN
5409: ar_receivable_applications.global_attribute8%TYPE,

Line 5407: ar_receivable_applications.global_attribute7%TYPE,

5403: ar_receivable_applications.global_attribute5%TYPE,
5404: p_global_attribute6 IN
5405: ar_receivable_applications.global_attribute6%TYPE,
5406: p_global_attribute7 IN
5407: ar_receivable_applications.global_attribute7%TYPE,
5408: p_global_attribute8 IN
5409: ar_receivable_applications.global_attribute8%TYPE,
5410: p_global_attribute9 IN
5411: ar_receivable_applications.global_attribute9%TYPE,

Line 5409: ar_receivable_applications.global_attribute8%TYPE,

5405: ar_receivable_applications.global_attribute6%TYPE,
5406: p_global_attribute7 IN
5407: ar_receivable_applications.global_attribute7%TYPE,
5408: p_global_attribute8 IN
5409: ar_receivable_applications.global_attribute8%TYPE,
5410: p_global_attribute9 IN
5411: ar_receivable_applications.global_attribute9%TYPE,
5412: p_global_attribute10 IN
5413: ar_receivable_applications.global_attribute10%TYPE,

Line 5411: ar_receivable_applications.global_attribute9%TYPE,

5407: ar_receivable_applications.global_attribute7%TYPE,
5408: p_global_attribute8 IN
5409: ar_receivable_applications.global_attribute8%TYPE,
5410: p_global_attribute9 IN
5411: ar_receivable_applications.global_attribute9%TYPE,
5412: p_global_attribute10 IN
5413: ar_receivable_applications.global_attribute10%TYPE,
5414: p_global_attribute11 IN
5415: ar_receivable_applications.global_attribute11%TYPE,

Line 5413: ar_receivable_applications.global_attribute10%TYPE,

5409: ar_receivable_applications.global_attribute8%TYPE,
5410: p_global_attribute9 IN
5411: ar_receivable_applications.global_attribute9%TYPE,
5412: p_global_attribute10 IN
5413: ar_receivable_applications.global_attribute10%TYPE,
5414: p_global_attribute11 IN
5415: ar_receivable_applications.global_attribute11%TYPE,
5416: p_global_attribute12 IN
5417: ar_receivable_applications.global_attribute12%TYPE,

Line 5415: ar_receivable_applications.global_attribute11%TYPE,

5411: ar_receivable_applications.global_attribute9%TYPE,
5412: p_global_attribute10 IN
5413: ar_receivable_applications.global_attribute10%TYPE,
5414: p_global_attribute11 IN
5415: ar_receivable_applications.global_attribute11%TYPE,
5416: p_global_attribute12 IN
5417: ar_receivable_applications.global_attribute12%TYPE,
5418: p_global_attribute13 IN
5419: ar_receivable_applications.global_attribute13%TYPE,

Line 5417: ar_receivable_applications.global_attribute12%TYPE,

5413: ar_receivable_applications.global_attribute10%TYPE,
5414: p_global_attribute11 IN
5415: ar_receivable_applications.global_attribute11%TYPE,
5416: p_global_attribute12 IN
5417: ar_receivable_applications.global_attribute12%TYPE,
5418: p_global_attribute13 IN
5419: ar_receivable_applications.global_attribute13%TYPE,
5420: p_global_attribute14 IN
5421: ar_receivable_applications.global_attribute14%TYPE,

Line 5419: ar_receivable_applications.global_attribute13%TYPE,

5415: ar_receivable_applications.global_attribute11%TYPE,
5416: p_global_attribute12 IN
5417: ar_receivable_applications.global_attribute12%TYPE,
5418: p_global_attribute13 IN
5419: ar_receivable_applications.global_attribute13%TYPE,
5420: p_global_attribute14 IN
5421: ar_receivable_applications.global_attribute14%TYPE,
5422: p_global_attribute15 IN
5423: ar_receivable_applications.global_attribute15%TYPE,

Line 5421: ar_receivable_applications.global_attribute14%TYPE,

5417: ar_receivable_applications.global_attribute12%TYPE,
5418: p_global_attribute13 IN
5419: ar_receivable_applications.global_attribute13%TYPE,
5420: p_global_attribute14 IN
5421: ar_receivable_applications.global_attribute14%TYPE,
5422: p_global_attribute15 IN
5423: ar_receivable_applications.global_attribute15%TYPE,
5424: p_global_attribute16 IN
5425: ar_receivable_applications.global_attribute16%TYPE,

Line 5423: ar_receivable_applications.global_attribute15%TYPE,

5419: ar_receivable_applications.global_attribute13%TYPE,
5420: p_global_attribute14 IN
5421: ar_receivable_applications.global_attribute14%TYPE,
5422: p_global_attribute15 IN
5423: ar_receivable_applications.global_attribute15%TYPE,
5424: p_global_attribute16 IN
5425: ar_receivable_applications.global_attribute16%TYPE,
5426: p_global_attribute17 IN
5427: ar_receivable_applications.global_attribute17%TYPE,

Line 5425: ar_receivable_applications.global_attribute16%TYPE,

5421: ar_receivable_applications.global_attribute14%TYPE,
5422: p_global_attribute15 IN
5423: ar_receivable_applications.global_attribute15%TYPE,
5424: p_global_attribute16 IN
5425: ar_receivable_applications.global_attribute16%TYPE,
5426: p_global_attribute17 IN
5427: ar_receivable_applications.global_attribute17%TYPE,
5428: p_global_attribute18 IN
5429: ar_receivable_applications.global_attribute18%TYPE,

Line 5427: ar_receivable_applications.global_attribute17%TYPE,

5423: ar_receivable_applications.global_attribute15%TYPE,
5424: p_global_attribute16 IN
5425: ar_receivable_applications.global_attribute16%TYPE,
5426: p_global_attribute17 IN
5427: ar_receivable_applications.global_attribute17%TYPE,
5428: p_global_attribute18 IN
5429: ar_receivable_applications.global_attribute18%TYPE,
5430: p_global_attribute19 IN
5431: ar_receivable_applications.global_attribute19%TYPE,

Line 5429: ar_receivable_applications.global_attribute18%TYPE,

5425: ar_receivable_applications.global_attribute16%TYPE,
5426: p_global_attribute17 IN
5427: ar_receivable_applications.global_attribute17%TYPE,
5428: p_global_attribute18 IN
5429: ar_receivable_applications.global_attribute18%TYPE,
5430: p_global_attribute19 IN
5431: ar_receivable_applications.global_attribute19%TYPE,
5432: p_global_attribute20 IN
5433: ar_receivable_applications.global_attribute20%TYPE,

Line 5431: ar_receivable_applications.global_attribute19%TYPE,

5427: ar_receivable_applications.global_attribute17%TYPE,
5428: p_global_attribute18 IN
5429: ar_receivable_applications.global_attribute18%TYPE,
5430: p_global_attribute19 IN
5431: ar_receivable_applications.global_attribute19%TYPE,
5432: p_global_attribute20 IN
5433: ar_receivable_applications.global_attribute20%TYPE,
5434: p_comments IN
5435: ar_receivable_applications.comments%TYPE,

Line 5433: ar_receivable_applications.global_attribute20%TYPE,

5429: ar_receivable_applications.global_attribute18%TYPE,
5430: p_global_attribute19 IN
5431: ar_receivable_applications.global_attribute19%TYPE,
5432: p_global_attribute20 IN
5433: ar_receivable_applications.global_attribute20%TYPE,
5434: p_comments IN
5435: ar_receivable_applications.comments%TYPE,
5436: p_module_name IN VARCHAR2,
5437: p_module_version IN VARCHAR2,

Line 5435: ar_receivable_applications.comments%TYPE,

5431: ar_receivable_applications.global_attribute19%TYPE,
5432: p_global_attribute20 IN
5433: ar_receivable_applications.global_attribute20%TYPE,
5434: p_comments IN
5435: ar_receivable_applications.comments%TYPE,
5436: p_module_name IN VARCHAR2,
5437: p_module_version IN VARCHAR2,
5438: p_application_ref_type IN OUT NOCOPY
5439: ar_receivable_applications.application_ref_type%TYPE,

Line 5439: ar_receivable_applications.application_ref_type%TYPE,

5435: ar_receivable_applications.comments%TYPE,
5436: p_module_name IN VARCHAR2,
5437: p_module_version IN VARCHAR2,
5438: p_application_ref_type IN OUT NOCOPY
5439: ar_receivable_applications.application_ref_type%TYPE,
5440: p_application_ref_id IN OUT NOCOPY
5441: ar_receivable_applications.application_ref_id%TYPE,
5442: p_application_ref_num IN OUT NOCOPY
5443: ar_receivable_applications.application_ref_num%TYPE,

Line 5441: ar_receivable_applications.application_ref_id%TYPE,

5437: p_module_version IN VARCHAR2,
5438: p_application_ref_type IN OUT NOCOPY
5439: ar_receivable_applications.application_ref_type%TYPE,
5440: p_application_ref_id IN OUT NOCOPY
5441: ar_receivable_applications.application_ref_id%TYPE,
5442: p_application_ref_num IN OUT NOCOPY
5443: ar_receivable_applications.application_ref_num%TYPE,
5444: p_secondary_application_ref_id IN OUT NOCOPY NUMBER,
5445: p_payment_set_id IN NUMBER,

Line 5443: ar_receivable_applications.application_ref_num%TYPE,

5439: ar_receivable_applications.application_ref_type%TYPE,
5440: p_application_ref_id IN OUT NOCOPY
5441: ar_receivable_applications.application_ref_id%TYPE,
5442: p_application_ref_num IN OUT NOCOPY
5443: ar_receivable_applications.application_ref_num%TYPE,
5444: p_secondary_application_ref_id IN OUT NOCOPY NUMBER,
5445: p_payment_set_id IN NUMBER,
5446: p_called_from IN VARCHAR2, /*5444407*/
5447: p_out_rec_application_id OUT NOCOPY NUMBER,

Line 5449: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,

5445: p_payment_set_id IN NUMBER,
5446: p_called_from IN VARCHAR2, /*5444407*/
5447: p_out_rec_application_id OUT NOCOPY NUMBER,
5448: p_applied_rec_app_id IN NUMBER,
5449: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5450: p_netted_receipt_flag IN VARCHAR2,
5451: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
5452: p_secondary_app_ref_type IN
5453: ar_receivable_applications.secondary_application_ref_type%TYPE := null,

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

5449: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5450: p_netted_receipt_flag IN VARCHAR2,
5451: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
5452: p_secondary_app_ref_type IN
5453: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5454: p_secondary_app_ref_num IN
5455: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5456: p_customer_reason IN
5457: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

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

5451: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
5452: p_secondary_app_ref_type IN
5453: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5454: p_secondary_app_ref_num IN
5455: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5456: p_customer_reason IN
5457: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5458: --Bug 5450371
5459: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL

Line 5457: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

5453: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5454: p_secondary_app_ref_num IN
5455: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5456: p_customer_reason IN
5457: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5458: --Bug 5450371
5459: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL
5460: ) IS
5461:

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

5455: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5456: p_customer_reason IN
5457: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
5458: --Bug 5450371
5459: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE Default NULL
5460: ) IS
5461:
5462: /* Cursor to application information for activity application */
5463: CURSOR activity_c IS

Line 5490: l_ra_rec ar_receivable_applications%ROWTYPE;

5486: AND rt.receivables_trx_id = p_receivables_trx_id;
5487:
5488: activity_rec activity_c%ROWTYPE;
5489:
5490: l_ra_rec ar_receivable_applications%ROWTYPE;
5491: l_ps_rec ar_payment_schedules%ROWTYPE;
5492: l_cr_rec ar_cash_receipts%ROWTYPE;
5493: l_crcpt_rec ar_cash_receipts%ROWTYPE;
5494:

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

5491: l_ps_rec ar_payment_schedules%ROWTYPE;
5492: l_cr_rec ar_cash_receipts%ROWTYPE;
5493: l_crcpt_rec ar_cash_receipts%ROWTYPE;
5494:
5495: l_unapp_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */
5496:
5497: functional_curr VARCHAR2(100);
5498: l_on_account_total NUMBER;
5499: l_ae_doc_rec ae_doc_rec_type;

Line 5501: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;

5497: functional_curr VARCHAR2(100);
5498: l_on_account_total NUMBER;
5499: l_ae_doc_rec ae_doc_rec_type;
5500: l_prev_unapp_id NUMBER;
5501: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
5502: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
5503: l_invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE;
5504: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE;
5505: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;

Line 5502: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

5498: l_on_account_total NUMBER;
5499: l_ae_doc_rec ae_doc_rec_type;
5500: l_prev_unapp_id NUMBER;
5501: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
5502: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
5503: l_invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE;
5504: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE;
5505: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
5506: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

Line 5518: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

5514: l_msg_count NUMBER;
5515: l_msg_data VARCHAR2(2000);
5516: l_msg_index NUMBER;
5517:
5518: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
5519: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5520: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5521: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5522: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;

Line 5519: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

5515: l_msg_data VARCHAR2(2000);
5516: l_msg_index NUMBER;
5517:
5518: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
5519: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5520: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5521: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5522: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5523: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;

Line 5520: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

5516: l_msg_index NUMBER;
5517:
5518: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
5519: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5520: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5521: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5522: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5523: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
5524: l_netted_receipt_flag VARCHAR2(1);

Line 5521: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

5517:
5518: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
5519: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5520: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5521: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5522: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5523: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
5524: l_netted_receipt_flag VARCHAR2(1);
5525: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

Line 5522: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;

5518: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
5519: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5520: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5521: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5522: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5523: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
5524: l_netted_receipt_flag VARCHAR2(1);
5525: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5526: API_exception EXCEPTION;

Line 5523: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;

5519: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
5520: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5521: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5522: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5523: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
5524: l_netted_receipt_flag VARCHAR2(1);
5525: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5526: API_exception EXCEPTION;
5527:

Line 5525: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

5521: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
5522: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
5523: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
5524: l_netted_receipt_flag VARCHAR2(1);
5525: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5526: API_exception EXCEPTION;
5527:
5528: --Bug 5450371
5529: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;

Line 5529: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;

5525: l_mc_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
5526: API_exception EXCEPTION;
5527:
5528: --Bug 5450371
5529: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
5530:
5531: --For CC_Chargeback logic
5532: l_called_from VARCHAR2(100) := null;
5533: l_called_from_api VARCHAR2(1);

Line 5633: FROM ar_receivable_applications

5629: INTO l_pymnt_trxn_ext_id_temp
5630: FROM ar_cash_receipts
5631: WHERE cash_receipt_id IN (
5632: SELECT MAX(application_ref_id)
5633: FROM ar_receivable_applications
5634: WHERE cash_receipt_id = l_ps_rec.cash_receipt_id
5635: AND application_type = 'CASH'
5636: AND application_ref_type = 'MISC_RECEIPT');
5637:

Line 6141: from ar_receivable_applications ra

6137: * total for the receipt. */
6138:
6139: select nvl(sum(ra.amount_applied),0)
6140: into l_on_account_total
6141: from ar_receivable_applications ra
6142: where ra.cash_receipt_id = l_ra_rec.cash_receipt_id
6143: and ra.status IN ('ACC','OTHER ACC');
6144:
6145: IF (activity_rec.amount_due_remaining + l_on_account_total + p_amount_applied < 0)

Line 6226: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

6222: | |
6223: +===========================================================================*/
6224: PROCEDURE validate_activity_args(
6225: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6226: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6227: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6228: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6229: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6230: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 6227: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,

6223: +===========================================================================*/
6224: PROCEDURE validate_activity_args(
6225: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6226: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6227: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6228: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6229: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6230: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6231: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS

Line 6228: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

6224: PROCEDURE validate_activity_args(
6225: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6226: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6227: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6228: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6229: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6230: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6231: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS
6232:

Line 6229: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

6225: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6226: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6227: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6228: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6229: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6230: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6231: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS
6232:
6233: BEGIN

Line 6230: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

6226: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6227: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6228: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6229: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6230: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6231: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS
6232:
6233: BEGIN
6234: IF PG_DEBUG in ('Y', 'C') THEN

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

6227: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6228: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6229: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6230: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6231: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE) IS
6232:
6233: BEGIN
6234: IF PG_DEBUG in ('Y', 'C') THEN
6235: arp_standard.debug( 'arp_process_application.validate_activity_args()+' );

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

6290: | |
6291: +===========================================================================*/
6292: PROCEDURE fetch_app_ccid(
6293: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6294: p_applied_customer_trx_id OUT NOCOPY ar_receivable_applications.applied_customer_trx_id%TYPE,
6295: p_code_combination_id OUT NOCOPY ar_receivable_applications.code_combination_id%TYPE,
6296: p_source_type OUT NOCOPY ar_distributions.source_type%TYPE) IS
6297:
6298: /* Cursor to fetch the given transaction information */

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

6291: +===========================================================================*/
6292: PROCEDURE fetch_app_ccid(
6293: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6294: p_applied_customer_trx_id OUT NOCOPY ar_receivable_applications.applied_customer_trx_id%TYPE,
6295: p_code_combination_id OUT NOCOPY ar_receivable_applications.code_combination_id%TYPE,
6296: p_source_type OUT NOCOPY ar_distributions.source_type%TYPE) IS
6297:
6298: /* Cursor to fetch the given transaction information */
6299: CURSOR doc_cur IS

Line 6472: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

6468: | schedule_id of -3 for receipt write-off|
6469: | |
6470: +===========================================================================*/
6471: PROCEDURE validate_activity(
6472: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6473: p_activity_type IN ar_receivables_trx.type%TYPE) IS
6474:
6475: BEGIN
6476: IF PG_DEBUG in ('Y', 'C') THEN

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

6524: | FALSE - If the UNAPP row is not postable |
6525: | MODIFICATION HISTORY - Created by Jani Rautiainen - 09-OCT-2000 |
6526: | |
6527: +===========================================================================*/
6528: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,
6529: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN IS
6530:
6531: CURSOR trx_class_cur IS
6532: SELECT ps.class

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

6525: | MODIFICATION HISTORY - Created by Jani Rautiainen - 09-OCT-2000 |
6526: | |
6527: +===========================================================================*/
6528: FUNCTION unapp_postable(p_applied_customer_trx_id IN ar_receivable_applications.applied_customer_trx_id%TYPE,
6529: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN IS
6530:
6531: CURSOR trx_class_cur IS
6532: SELECT ps.class
6533: FROM ar_payment_schedules ps

Line 6643: | used in query on ar_receivable_applications |

6639: | 30-JUN-2004 Jon Beckett Removed RAISE from handling of trade_mgt_err |
6640: | to ensure TM errors are displayed correctly |
6641: | 06-AUG-2004 Jon Beckett Bug 3643551 - index on applied_ps_id |
6642: | ignored to ensure index on cash_receipt_id is|
6643: | used in query on ar_receivable_applications |
6644: | 03-MAR-2005 JASSING Added the code to check for the profile |
6645: | option 'AR:Disable Receivable Activity |
6646: | Balancing Segment Substitution' for Claims |
6647: | and Prepayments. Bug Fix 4025652. |

Line 6653: ar_receivable_applications.amount_applied%TYPE,

6649: +===========================================================================*/
6650: PROCEDURE other_account_application(
6651: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6652: p_amount_applied IN
6653: ar_receivable_applications.amount_applied%TYPE,
6654: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6655: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6656: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
6657: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

Line 6654: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

6650: PROCEDURE other_account_application(
6651: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6652: p_amount_applied IN
6653: ar_receivable_applications.amount_applied%TYPE,
6654: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6655: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6656: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
6657: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6658: p_ussgl_transaction_code IN

Line 6655: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

6651: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6652: p_amount_applied IN
6653: ar_receivable_applications.amount_applied%TYPE,
6654: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6655: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6656: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
6657: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6658: p_ussgl_transaction_code IN
6659: ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 6656: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,

6652: p_amount_applied IN
6653: ar_receivable_applications.amount_applied%TYPE,
6654: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6655: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6656: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
6657: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6658: p_ussgl_transaction_code IN
6659: ar_receivable_applications.ussgl_transaction_code%TYPE,
6660: p_application_ref_type IN

Line 6657: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,

6653: ar_receivable_applications.amount_applied%TYPE,
6654: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6655: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6656: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
6657: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6658: p_ussgl_transaction_code IN
6659: ar_receivable_applications.ussgl_transaction_code%TYPE,
6660: p_application_ref_type IN
6661: ar_receivable_applications.application_ref_type%TYPE,

Line 6659: ar_receivable_applications.ussgl_transaction_code%TYPE,

6655: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
6656: p_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE,
6657: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6658: p_ussgl_transaction_code IN
6659: ar_receivable_applications.ussgl_transaction_code%TYPE,
6660: p_application_ref_type IN
6661: ar_receivable_applications.application_ref_type%TYPE,
6662: p_application_ref_id IN
6663: ar_receivable_applications.application_ref_id%TYPE,

Line 6661: ar_receivable_applications.application_ref_type%TYPE,

6657: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6658: p_ussgl_transaction_code IN
6659: ar_receivable_applications.ussgl_transaction_code%TYPE,
6660: p_application_ref_type IN
6661: ar_receivable_applications.application_ref_type%TYPE,
6662: p_application_ref_id IN
6663: ar_receivable_applications.application_ref_id%TYPE,
6664: p_application_ref_num IN
6665: ar_receivable_applications.application_ref_num%TYPE,

Line 6663: ar_receivable_applications.application_ref_id%TYPE,

6659: ar_receivable_applications.ussgl_transaction_code%TYPE,
6660: p_application_ref_type IN
6661: ar_receivable_applications.application_ref_type%TYPE,
6662: p_application_ref_id IN
6663: ar_receivable_applications.application_ref_id%TYPE,
6664: p_application_ref_num IN
6665: ar_receivable_applications.application_ref_num%TYPE,
6666: p_secondary_application_ref_id IN NUMBER,
6667: p_comments IN

Line 6665: ar_receivable_applications.application_ref_num%TYPE,

6661: ar_receivable_applications.application_ref_type%TYPE,
6662: p_application_ref_id IN
6663: ar_receivable_applications.application_ref_id%TYPE,
6664: p_application_ref_num IN
6665: ar_receivable_applications.application_ref_num%TYPE,
6666: p_secondary_application_ref_id IN NUMBER,
6667: p_comments IN
6668: ar_receivable_applications.comments%TYPE,
6669: p_attribute_category IN

Line 6668: ar_receivable_applications.comments%TYPE,

6664: p_application_ref_num IN
6665: ar_receivable_applications.application_ref_num%TYPE,
6666: p_secondary_application_ref_id IN NUMBER,
6667: p_comments IN
6668: ar_receivable_applications.comments%TYPE,
6669: p_attribute_category IN
6670: ar_receivable_applications.attribute_category%TYPE,
6671: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
6672: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

Line 6670: ar_receivable_applications.attribute_category%TYPE,

6666: p_secondary_application_ref_id IN NUMBER,
6667: p_comments IN
6668: ar_receivable_applications.comments%TYPE,
6669: p_attribute_category IN
6670: ar_receivable_applications.attribute_category%TYPE,
6671: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
6672: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
6673: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
6674: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

Line 6671: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

6667: p_comments IN
6668: ar_receivable_applications.comments%TYPE,
6669: p_attribute_category IN
6670: ar_receivable_applications.attribute_category%TYPE,
6671: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
6672: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
6673: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
6674: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
6675: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

Line 6672: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

6668: ar_receivable_applications.comments%TYPE,
6669: p_attribute_category IN
6670: ar_receivable_applications.attribute_category%TYPE,
6671: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
6672: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
6673: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
6674: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
6675: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
6676: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

Line 6673: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

6669: p_attribute_category IN
6670: ar_receivable_applications.attribute_category%TYPE,
6671: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
6672: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
6673: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
6674: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
6675: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
6676: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
6677: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

Line 6674: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

6670: ar_receivable_applications.attribute_category%TYPE,
6671: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
6672: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
6673: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
6674: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
6675: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
6676: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
6677: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
6678: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

Line 6675: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

6671: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
6672: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
6673: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
6674: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
6675: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
6676: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
6677: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
6678: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
6679: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

Line 6676: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

6672: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
6673: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
6674: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
6675: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
6676: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
6677: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
6678: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
6679: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
6680: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

Line 6677: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

6673: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
6674: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
6675: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
6676: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
6677: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
6678: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
6679: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
6680: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
6681: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

Line 6678: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

6674: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
6675: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
6676: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
6677: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
6678: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
6679: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
6680: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
6681: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
6682: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

Line 6679: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

6675: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
6676: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
6677: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
6678: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
6679: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
6680: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
6681: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
6682: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
6683: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

Line 6680: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

6676: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
6677: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
6678: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
6679: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
6680: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
6681: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
6682: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
6683: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
6684: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

Line 6681: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

6677: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
6678: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
6679: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
6680: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
6681: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
6682: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
6683: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
6684: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
6685: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

Line 6682: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

6678: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
6679: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
6680: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
6681: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
6682: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
6683: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
6684: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
6685: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
6686: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

Line 6683: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

6679: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
6680: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
6681: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
6682: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
6683: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
6684: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
6685: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
6686: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
6687: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

Line 6684: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

6680: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
6681: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
6682: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
6683: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
6684: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
6685: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
6686: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
6687: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
6688: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

Line 6685: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

6681: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
6682: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
6683: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
6684: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
6685: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
6686: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
6687: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
6688: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
6689: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

Line 6686: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

6682: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
6683: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
6684: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
6685: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
6686: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
6687: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
6688: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
6689: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
6690: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

Line 6687: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

6683: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
6684: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
6685: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
6686: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
6687: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
6688: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
6689: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
6690: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
6691: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

Line 6688: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

6684: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
6685: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
6686: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
6687: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
6688: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
6689: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
6690: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
6691: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
6692: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

Line 6689: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

6685: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
6686: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
6687: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
6688: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
6689: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
6690: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
6691: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
6692: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
6693: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

Line 6690: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

6686: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
6687: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
6688: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
6689: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
6690: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
6691: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
6692: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
6693: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
6694: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

Line 6691: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

6687: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
6688: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
6689: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
6690: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
6691: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
6692: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
6693: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
6694: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
6695: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

Line 6692: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

6688: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
6689: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
6690: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
6691: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
6692: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
6693: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
6694: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
6695: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
6696: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

Line 6693: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

6689: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
6690: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
6691: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
6692: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
6693: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
6694: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
6695: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
6696: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
6697: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

Line 6694: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

6690: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
6691: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
6692: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
6693: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
6694: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
6695: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
6696: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
6697: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
6698: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

Line 6695: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

6691: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
6692: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
6693: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
6694: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
6695: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
6696: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
6697: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
6698: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
6699: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

Line 6696: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

6692: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
6693: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
6694: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
6695: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
6696: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
6697: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
6698: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
6699: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
6700: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

Line 6697: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

6693: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
6694: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
6695: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
6696: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
6697: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
6698: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
6699: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
6700: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
6701: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

Line 6698: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

6694: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
6695: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
6696: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
6697: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
6698: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
6699: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
6700: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
6701: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
6702: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

Line 6699: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

6695: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
6696: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
6697: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
6698: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
6699: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
6700: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
6701: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
6702: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
6703: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

Line 6700: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

6696: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
6697: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
6698: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
6699: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
6700: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
6701: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
6702: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
6703: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
6704: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

Line 6701: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

6697: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
6698: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
6699: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
6700: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
6701: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
6702: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
6703: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
6704: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
6705: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

Line 6702: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

6698: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
6699: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
6700: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
6701: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
6702: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
6703: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
6704: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
6705: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
6706: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

Line 6703: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

6699: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
6700: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
6701: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
6702: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
6703: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
6704: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
6705: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
6706: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
6707: p_module_name IN VARCHAR2,

Line 6704: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

6700: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
6701: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
6702: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
6703: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
6704: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
6705: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
6706: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
6707: p_module_name IN VARCHAR2,
6708: p_module_version IN VARCHAR2,

Line 6705: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

6701: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
6702: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
6703: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
6704: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
6705: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
6706: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
6707: p_module_name IN VARCHAR2,
6708: p_module_version IN VARCHAR2,
6709: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,

Line 6706: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

6702: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
6703: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
6704: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
6705: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
6706: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
6707: p_module_name IN VARCHAR2,
6708: p_module_version IN VARCHAR2,
6709: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
6710: x_application_ref_id OUT NOCOPY

Line 6709: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,

6705: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
6706: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
6707: p_module_name IN VARCHAR2,
6708: p_module_version IN VARCHAR2,
6709: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
6710: x_application_ref_id OUT NOCOPY
6711: ar_receivable_applications.application_ref_id%TYPE,
6712: x_application_ref_num OUT NOCOPY
6713: ar_receivable_applications.application_ref_num%TYPE

Line 6711: ar_receivable_applications.application_ref_id%TYPE,

6707: p_module_name IN VARCHAR2,
6708: p_module_version IN VARCHAR2,
6709: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
6710: x_application_ref_id OUT NOCOPY
6711: ar_receivable_applications.application_ref_id%TYPE,
6712: x_application_ref_num OUT NOCOPY
6713: ar_receivable_applications.application_ref_num%TYPE
6714: , x_return_status OUT NOCOPY VARCHAR2
6715: , x_msg_count OUT NOCOPY NUMBER

Line 6713: ar_receivable_applications.application_ref_num%TYPE

6709: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
6710: x_application_ref_id OUT NOCOPY
6711: ar_receivable_applications.application_ref_id%TYPE,
6712: x_application_ref_num OUT NOCOPY
6713: ar_receivable_applications.application_ref_num%TYPE
6714: , x_return_status OUT NOCOPY VARCHAR2
6715: , x_msg_count OUT NOCOPY NUMBER
6716: , x_msg_data OUT NOCOPY VARCHAR2
6717: , p_out_rec_application_id OUT NOCOPY NUMBER

Line 6718: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE

6714: , x_return_status OUT NOCOPY VARCHAR2
6715: , x_msg_count OUT NOCOPY NUMBER
6716: , x_msg_data OUT NOCOPY VARCHAR2
6717: , p_out_rec_application_id OUT NOCOPY NUMBER
6718: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE
6719: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
6720: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
6721: , x_claim_reason_name OUT NOCOPY VARCHAR2
6722: , p_called_from IN VARCHAR2) IS

Line 6719: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE

6715: , x_msg_count OUT NOCOPY NUMBER
6716: , x_msg_data OUT NOCOPY VARCHAR2
6717: , p_out_rec_application_id OUT NOCOPY NUMBER
6718: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE
6719: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
6720: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
6721: , x_claim_reason_name OUT NOCOPY VARCHAR2
6722: , p_called_from IN VARCHAR2) IS
6723:

Line 6720: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE

6716: , x_msg_data OUT NOCOPY VARCHAR2
6717: , p_out_rec_application_id OUT NOCOPY NUMBER
6718: , p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE
6719: , p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
6720: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
6721: , x_claim_reason_name OUT NOCOPY VARCHAR2
6722: , p_called_from IN VARCHAR2) IS
6723:
6724: l_ra_rec ar_receivable_applications%ROWTYPE;

Line 6724: l_ra_rec ar_receivable_applications%ROWTYPE;

6720: , p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
6721: , x_claim_reason_name OUT NOCOPY VARCHAR2
6722: , p_called_from IN VARCHAR2) IS
6723:
6724: l_ra_rec ar_receivable_applications%ROWTYPE;
6725: l_ps_rec ar_payment_schedules%ROWTYPE;
6726:
6727: l_cr_rec ar_cash_receipts%ROWTYPE;
6728: l_amount_due_remaining NUMBER;

Line 6841: FROM ar_receivable_applications rap

6837:
6838: -- Bug 3643551: use of index on applied_ps_id prevented
6839: SELECT 'Y'
6840: INTO l_found
6841: FROM ar_receivable_applications rap
6842: WHERE rap.cash_receipt_id = l_ra_rec.cash_receipt_id
6843: AND rap.applied_payment_schedule_id + 0 = -4
6844: AND rap.secondary_application_ref_id = p_secondary_application_ref_id
6845: AND rap.display = 'Y'

Line 6870: from ar_receivable_applications ra

6866: --
6867: BEGIN
6868: select nvl(sum(ra.amount_applied),0)
6869: into l_on_account_total
6870: from ar_receivable_applications ra
6871: where ra.cash_receipt_id = l_ra_rec.cash_receipt_id
6872: and ra.status IN ('ACC','OTHER ACC');
6873: EXCEPTION
6874: WHEN NO_DATA_FOUND then

Line 7923: IN ar_receivable_applications.application_ref_id%TYPE,

7919: | |
7920: +===========================================================================*/
7921: PROCEDURE reverse_action_receipt_cb(
7922: p_chargeback_customer_trx_id
7923: IN ar_receivable_applications.application_ref_id%TYPE,
7924: p_reversal_gl_date IN DATE,
7925: p_reversal_date IN DATE,
7926: p_module_name IN VARCHAR2,
7927: p_module_version IN VARCHAR2 ) IS

Line 7984: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,

7980: | MODIFICATION HISTORY - Created by Ramakant Alat 18-JUN-01 |
7981: | |
7982: +===========================================================================*/
7983: PROCEDURE reverse_action_misc_receipt(
7984: p_cash_receipt_id IN ar_receivable_applications.application_ref_id%TYPE,
7985: p_reversal_gl_date IN DATE,
7986: p_reversal_date IN DATE,
7987: p_reversal_comments IN VARCHAR2 DEFAULT NULL,
7988: p_called_from IN VARCHAR2 DEFAULT NULL) IS

Line 8192: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

8188: +===========================================================================*/
8189: PROCEDURE cm_activity_application(
8190: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8191: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8192: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8193: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8194: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8195: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8196: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,

Line 8193: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

8189: PROCEDURE cm_activity_application(
8190: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8191: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8192: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8193: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8194: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8195: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8196: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8197: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

Line 8194: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

8190: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8191: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8192: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8193: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8194: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8195: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8196: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8197: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8198: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

Line 8195: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

8191: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8192: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8193: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8194: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8195: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8196: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8197: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8198: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8199: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

Line 8196: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,

8192: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8193: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8194: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8195: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8196: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8197: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8198: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8199: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8200: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

Line 8197: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,

8193: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8194: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8195: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8196: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8197: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8198: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8199: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8200: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8201: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

Line 8198: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,

8194: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8195: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8196: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8197: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8198: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8199: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8200: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8201: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8202: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

Line 8199: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,

8195: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
8196: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8197: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8198: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8199: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8200: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8201: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8202: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8203: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

Line 8200: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,

8196: p_attribute_category IN ar_receivable_applications.attribute_category%TYPE,
8197: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8198: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8199: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8200: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8201: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8202: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8203: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8204: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

Line 8201: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,

8197: p_attribute1 IN ar_receivable_applications.attribute1%TYPE,
8198: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8199: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8200: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8201: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8202: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8203: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8204: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8205: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

Line 8202: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,

8198: p_attribute2 IN ar_receivable_applications.attribute2%TYPE,
8199: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8200: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8201: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8202: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8203: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8204: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8205: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8206: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

Line 8203: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,

8199: p_attribute3 IN ar_receivable_applications.attribute3%TYPE,
8200: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8201: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8202: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8203: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8204: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8205: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8206: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8207: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

Line 8204: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,

8200: p_attribute4 IN ar_receivable_applications.attribute4%TYPE,
8201: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8202: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8203: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8204: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8205: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8206: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8207: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8208: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

Line 8205: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,

8201: p_attribute5 IN ar_receivable_applications.attribute5%TYPE,
8202: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8203: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8204: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8205: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8206: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8207: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8208: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8209: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

Line 8206: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,

8202: p_attribute6 IN ar_receivable_applications.attribute6%TYPE,
8203: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8204: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8205: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8206: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8207: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8208: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8209: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8210: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

Line 8207: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,

8203: p_attribute7 IN ar_receivable_applications.attribute7%TYPE,
8204: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8205: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8206: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8207: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8208: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8209: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8210: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8211: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

Line 8208: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,

8204: p_attribute8 IN ar_receivable_applications.attribute8%TYPE,
8205: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8206: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8207: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8208: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8209: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8210: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8211: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8212: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

Line 8209: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,

8205: p_attribute9 IN ar_receivable_applications.attribute9%TYPE,
8206: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8207: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8208: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8209: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8210: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8211: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8212: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8213: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

Line 8210: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,

8206: p_attribute10 IN ar_receivable_applications.attribute10%TYPE,
8207: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8208: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8209: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8210: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8211: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8212: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8213: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8214: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

Line 8211: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,

8207: p_attribute11 IN ar_receivable_applications.attribute11%TYPE,
8208: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8209: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8210: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8211: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8212: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8213: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8214: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8215: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

Line 8212: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,

8208: p_attribute12 IN ar_receivable_applications.attribute12%TYPE,
8209: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8210: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8211: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8212: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8213: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8214: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8215: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8216: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

Line 8213: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,

8209: p_attribute13 IN ar_receivable_applications.attribute13%TYPE,
8210: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8211: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8212: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8213: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8214: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8215: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8216: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8217: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

Line 8214: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,

8210: p_attribute14 IN ar_receivable_applications.attribute14%TYPE,
8211: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8212: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8213: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8214: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8215: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8216: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8217: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8218: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

Line 8215: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,

8211: p_attribute15 IN ar_receivable_applications.attribute15%TYPE,
8212: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8213: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8214: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8215: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8216: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8217: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8218: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8219: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

Line 8216: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,

8212: p_global_attribute_category IN ar_receivable_applications.global_attribute_category%TYPE,
8213: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8214: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8215: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8216: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8217: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8218: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8219: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8220: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

Line 8217: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,

8213: p_global_attribute1 IN ar_receivable_applications.global_attribute1%TYPE,
8214: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8215: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8216: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8217: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8218: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8219: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8220: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8221: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

Line 8218: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,

8214: p_global_attribute2 IN ar_receivable_applications.global_attribute2%TYPE,
8215: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8216: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8217: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8218: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8219: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8220: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8221: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8222: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

Line 8219: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,

8215: p_global_attribute3 IN ar_receivable_applications.global_attribute3%TYPE,
8216: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8217: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8218: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8219: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8220: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8221: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8222: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8223: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

Line 8220: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,

8216: p_global_attribute4 IN ar_receivable_applications.global_attribute4%TYPE,
8217: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8218: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8219: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8220: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8221: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8222: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8223: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8224: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

Line 8221: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,

8217: p_global_attribute5 IN ar_receivable_applications.global_attribute5%TYPE,
8218: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8219: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8220: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8221: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8222: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8223: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8224: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8225: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

Line 8222: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,

8218: p_global_attribute6 IN ar_receivable_applications.global_attribute6%TYPE,
8219: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8220: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8221: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8222: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8223: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8224: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8225: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8226: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

Line 8223: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,

8219: p_global_attribute7 IN ar_receivable_applications.global_attribute7%TYPE,
8220: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8221: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8222: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8223: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8224: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8225: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8226: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8227: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

Line 8224: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,

8220: p_global_attribute8 IN ar_receivable_applications.global_attribute8%TYPE,
8221: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8222: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8223: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8224: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8225: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8226: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8227: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8228: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

Line 8225: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,

8221: p_global_attribute9 IN ar_receivable_applications.global_attribute9%TYPE,
8222: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8223: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8224: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8225: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8226: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8227: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8228: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8229: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

Line 8226: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,

8222: p_global_attribute10 IN ar_receivable_applications.global_attribute10%TYPE,
8223: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8224: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8225: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8226: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8227: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8228: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8229: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8230: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

Line 8227: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,

8223: p_global_attribute11 IN ar_receivable_applications.global_attribute11%TYPE,
8224: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8225: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8226: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8227: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8228: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8229: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8230: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8231: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

Line 8228: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,

8224: p_global_attribute12 IN ar_receivable_applications.global_attribute12%TYPE,
8225: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8226: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8227: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8228: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8229: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8230: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8231: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8232: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

Line 8229: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,

8225: p_global_attribute13 IN ar_receivable_applications.global_attribute13%TYPE,
8226: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8227: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8228: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8229: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8230: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8231: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8232: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8233: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,

Line 8230: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,

8226: p_global_attribute14 IN ar_receivable_applications.global_attribute14%TYPE,
8227: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8228: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8229: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8230: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8231: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8232: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8233: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
8234: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

Line 8231: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,

8227: p_global_attribute15 IN ar_receivable_applications.global_attribute15%TYPE,
8228: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8229: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8230: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8231: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8232: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8233: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
8234: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
8235: p_comments IN ar_receivable_applications.comments%TYPE ,

Line 8232: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,

8228: p_global_attribute16 IN ar_receivable_applications.global_attribute16%TYPE,
8229: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8230: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8231: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8232: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8233: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
8234: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
8235: p_comments IN ar_receivable_applications.comments%TYPE ,
8236: p_module_name IN VARCHAR2,

Line 8233: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,

8229: p_global_attribute17 IN ar_receivable_applications.global_attribute17%TYPE,
8230: p_global_attribute18 IN ar_receivable_applications.global_attribute18%TYPE,
8231: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8232: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8233: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
8234: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
8235: p_comments IN ar_receivable_applications.comments%TYPE ,
8236: p_module_name IN VARCHAR2,
8237: p_module_version IN VARCHAR2,

Line 8235: p_comments IN ar_receivable_applications.comments%TYPE ,

8231: p_global_attribute19 IN ar_receivable_applications.global_attribute19%TYPE,
8232: p_global_attribute20 IN ar_receivable_applications.global_attribute20%TYPE,
8233: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
8234: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
8235: p_comments IN ar_receivable_applications.comments%TYPE ,
8236: p_module_name IN VARCHAR2,
8237: p_module_version IN VARCHAR2,
8238: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
8239: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,

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

8234: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
8235: p_comments IN ar_receivable_applications.comments%TYPE ,
8236: p_module_name IN VARCHAR2,
8237: p_module_version IN VARCHAR2,
8238: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
8239: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
8240: -- OUT NOCOPY
8241: p_out_rec_application_id OUT NOCOPY NUMBER,
8242: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,

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

8235: p_comments IN ar_receivable_applications.comments%TYPE ,
8236: p_module_name IN VARCHAR2,
8237: p_module_version IN VARCHAR2,
8238: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
8239: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
8240: -- OUT NOCOPY
8241: p_out_rec_application_id OUT NOCOPY NUMBER,
8242: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
8243: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

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

8238: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE,
8239: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
8240: -- OUT NOCOPY
8241: p_out_rec_application_id OUT NOCOPY NUMBER,
8242: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
8243: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
8244: x_return_status OUT NOCOPY VARCHAR2,
8245: x_msg_count OUT NOCOPY NUMBER,
8246: x_msg_data OUT NOCOPY VARCHAR2) IS

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

8239: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
8240: -- OUT NOCOPY
8241: p_out_rec_application_id OUT NOCOPY NUMBER,
8242: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
8243: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
8244: x_return_status OUT NOCOPY VARCHAR2,
8245: x_msg_count OUT NOCOPY NUMBER,
8246: x_msg_data OUT NOCOPY VARCHAR2) IS
8247:

Line 8248: l_inv_ra_rec ar_receivable_applications%ROWTYPE;

8244: x_return_status OUT NOCOPY VARCHAR2,
8245: x_msg_count OUT NOCOPY NUMBER,
8246: x_msg_data OUT NOCOPY VARCHAR2) IS
8247:
8248: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
8249: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
8250: l_ae_doc_rec ae_doc_rec_type;
8251: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
8252: l_flag char;

Line 8259: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

8255: l_inv_bal_amount NUMBER;
8256: l_inv_orig_amount NUMBER;
8257: l_allow_over_application VARCHAR2(1);
8258: l_effective_amount_applied NUMBER;
8259: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
8260: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
8261: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
8262: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
8263: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;

Line 8260: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

8256: l_inv_orig_amount NUMBER;
8257: l_allow_over_application VARCHAR2(1);
8258: l_effective_amount_applied NUMBER;
8259: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
8260: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
8261: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
8262: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
8263: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
8264: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type;

Line 8261: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

8257: l_allow_over_application VARCHAR2(1);
8258: l_effective_amount_applied NUMBER;
8259: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
8260: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
8261: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
8262: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
8263: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
8264: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type;
8265: l_return_status VARCHAR2(1);

Line 8262: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

8258: l_effective_amount_applied NUMBER;
8259: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
8260: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
8261: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
8262: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
8263: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
8264: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type;
8265: l_return_status VARCHAR2(1);
8266: l_msg_count NUMBER;