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

APPS.AR_CM_API_PUB dependencies on RA_CUSTOMER_TRX

Line 9: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,

5: * against a debit memo or invoice using simple calls to PL/SQL functions.
6: */
7:
8: TYPE G_cm_app_rec_type IS RECORD(
9: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,
10: cm_trx_number ra_customer_trx.trx_number%TYPE ,
11: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,
12: inv_trx_number ra_customer_trx.trx_number%TYPE ,
13: installment ar_payment_schedules.terms_sequence_number%TYPE ,

Line 10: cm_trx_number ra_customer_trx.trx_number%TYPE ,

6: */
7:
8: TYPE G_cm_app_rec_type IS RECORD(
9: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,
10: cm_trx_number ra_customer_trx.trx_number%TYPE ,
11: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,
12: inv_trx_number ra_customer_trx.trx_number%TYPE ,
13: installment ar_payment_schedules.terms_sequence_number%TYPE ,
14: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ,

Line 11: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,

7:
8: TYPE G_cm_app_rec_type IS RECORD(
9: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,
10: cm_trx_number ra_customer_trx.trx_number%TYPE ,
11: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,
12: inv_trx_number ra_customer_trx.trx_number%TYPE ,
13: installment ar_payment_schedules.terms_sequence_number%TYPE ,
14: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ,
15: amount_applied ar_receivable_applications.amount_applied%TYPE ,

Line 12: inv_trx_number ra_customer_trx.trx_number%TYPE ,

8: TYPE G_cm_app_rec_type IS RECORD(
9: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,
10: cm_trx_number ra_customer_trx.trx_number%TYPE ,
11: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,
12: inv_trx_number ra_customer_trx.trx_number%TYPE ,
13: installment ar_payment_schedules.terms_sequence_number%TYPE ,
14: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ,
15: amount_applied ar_receivable_applications.amount_applied%TYPE ,
16: inv_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,

Line 16: inv_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,

12: inv_trx_number ra_customer_trx.trx_number%TYPE ,
13: installment ar_payment_schedules.terms_sequence_number%TYPE ,
14: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ,
15: amount_applied ar_receivable_applications.amount_applied%TYPE ,
16: inv_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,
17: inv_line_number ra_customer_trx_lines.line_number%TYPE );
18:
19: TYPE G_cm_unapp_rec_type IS RECORD
20: (cm_trx_number ra_customer_trx.trx_number%TYPE,

Line 17: inv_line_number ra_customer_trx_lines.line_number%TYPE );

13: installment ar_payment_schedules.terms_sequence_number%TYPE ,
14: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ,
15: amount_applied ar_receivable_applications.amount_applied%TYPE ,
16: inv_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,
17: inv_line_number ra_customer_trx_lines.line_number%TYPE );
18:
19: TYPE G_cm_unapp_rec_type IS RECORD
20: (cm_trx_number ra_customer_trx.trx_number%TYPE,
21: cm_customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,

Line 20: (cm_trx_number ra_customer_trx.trx_number%TYPE,

16: inv_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,
17: inv_line_number ra_customer_trx_lines.line_number%TYPE );
18:
19: TYPE G_cm_unapp_rec_type IS RECORD
20: (cm_trx_number ra_customer_trx.trx_number%TYPE,
21: cm_customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
22: inv_trx_number ra_customer_trx.trx_number%TYPE,
23: inv_customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
24: applied_ps_id ar_receivable_applications.applied_payment_schedule_id%TYPE,

Line 22: inv_trx_number ra_customer_trx.trx_number%TYPE,

18:
19: TYPE G_cm_unapp_rec_type IS RECORD
20: (cm_trx_number ra_customer_trx.trx_number%TYPE,
21: cm_customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
22: inv_trx_number ra_customer_trx.trx_number%TYPE,
23: inv_customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
24: applied_ps_id ar_receivable_applications.applied_payment_schedule_id%TYPE,
25: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
26:

Line 32: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,

28: original_cm_app_info G_cm_app_rec_type;
29: original_cm_unapp_info G_cm_unapp_rec_type;
30:
31: TYPE cm_app_rec_type IS RECORD (
32: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
33: cm_trx_number ra_customer_trx.trx_number%TYPE,
34: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
35: inv_trx_number ra_customer_trx.trx_number%TYPE,
36: installment NUMBER(15),

Line 33: cm_trx_number ra_customer_trx.trx_number%TYPE,

29: original_cm_unapp_info G_cm_unapp_rec_type;
30:
31: TYPE cm_app_rec_type IS RECORD (
32: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
33: cm_trx_number ra_customer_trx.trx_number%TYPE,
34: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
35: inv_trx_number ra_customer_trx.trx_number%TYPE,
36: installment NUMBER(15),
37: applied_payment_schedule_id NUMBER(15),

Line 34: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,

30:
31: TYPE cm_app_rec_type IS RECORD (
32: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
33: cm_trx_number ra_customer_trx.trx_number%TYPE,
34: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
35: inv_trx_number ra_customer_trx.trx_number%TYPE,
36: installment NUMBER(15),
37: applied_payment_schedule_id NUMBER(15),
38: amount_applied ar_receivable_applications.amount_applied%TYPE,

Line 35: inv_trx_number ra_customer_trx.trx_number%TYPE,

31: TYPE cm_app_rec_type IS RECORD (
32: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
33: cm_trx_number ra_customer_trx.trx_number%TYPE,
34: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
35: inv_trx_number ra_customer_trx.trx_number%TYPE,
36: installment NUMBER(15),
37: applied_payment_schedule_id NUMBER(15),
38: amount_applied ar_receivable_applications.amount_applied%TYPE,
39: apply_date ar_receivable_applications.apply_date%TYPE,

Line 41: inv_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,

37: applied_payment_schedule_id NUMBER(15),
38: amount_applied ar_receivable_applications.amount_applied%TYPE,
39: apply_date ar_receivable_applications.apply_date%TYPE,
40: gl_date ar_receivable_applications.gl_date%TYPE,
41: inv_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,
42: inv_line_number ra_customer_trx_lines.line_number%TYPE ,
43: show_closed_invoices VARCHAR2(1),
44: ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE ,
45: attribute_category ar_receivable_applications.attribute_category%TYPE ,

Line 42: inv_line_number ra_customer_trx_lines.line_number%TYPE ,

38: amount_applied ar_receivable_applications.amount_applied%TYPE,
39: apply_date ar_receivable_applications.apply_date%TYPE,
40: gl_date ar_receivable_applications.gl_date%TYPE,
41: inv_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,
42: inv_line_number ra_customer_trx_lines.line_number%TYPE ,
43: show_closed_invoices VARCHAR2(1),
44: ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE ,
45: attribute_category ar_receivable_applications.attribute_category%TYPE ,
46: attribute1 ar_receivable_applications.attribute1%TYPE ,

Line 86: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,

82: comments ar_receivable_applications.comments%TYPE,
83: called_from VARCHAR2(20) );
84:
85: TYPE cm_unapp_rec_type IS RECORD (
86: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
87: cm_trx_number ra_customer_trx.trx_number%TYPE,
88: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
89: inv_trx_number ra_customer_trx.trx_number%TYPE,
90: installment NUMBER(15),

Line 87: cm_trx_number ra_customer_trx.trx_number%TYPE,

83: called_from VARCHAR2(20) );
84:
85: TYPE cm_unapp_rec_type IS RECORD (
86: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
87: cm_trx_number ra_customer_trx.trx_number%TYPE,
88: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
89: inv_trx_number ra_customer_trx.trx_number%TYPE,
90: installment NUMBER(15),
91: applied_payment_schedule_id NUMBER(15),

Line 88: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,

84:
85: TYPE cm_unapp_rec_type IS RECORD (
86: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
87: cm_trx_number ra_customer_trx.trx_number%TYPE,
88: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
89: inv_trx_number ra_customer_trx.trx_number%TYPE,
90: installment NUMBER(15),
91: applied_payment_schedule_id NUMBER(15),
92: receivable_application_id NUMBER(15),

Line 89: inv_trx_number ra_customer_trx.trx_number%TYPE,

85: TYPE cm_unapp_rec_type IS RECORD (
86: cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
87: cm_trx_number ra_customer_trx.trx_number%TYPE,
88: inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
89: inv_trx_number ra_customer_trx.trx_number%TYPE,
90: installment NUMBER(15),
91: applied_payment_schedule_id NUMBER(15),
92: receivable_application_id NUMBER(15),
93: reversal_gl_date DATE,