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.JAI_AR_PROCESSING_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 13: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all

9: p_all_orgs IN VARCHAR2,
10: p_debug IN VARCHAR2 DEFAULT NULL);
11:
12:
13: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all
14: --Also deletes the MRC data from ra_cust_trx_line_gl_dist
15: PROCEDURE delete_trx_data(
16: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
17: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,

Line 48: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all

44: p_process_status OUT NOCOPY VARCHAR2,
45: p_process_message OUT NOCOPY VARCHAR2);
46:
47:
48: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all
49: PROCEDURE insert_trx_line_gl_dist(
50: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
51: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
52: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,

Line 50: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,

46:
47:
48: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all
49: PROCEDURE insert_trx_line_gl_dist(
50: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
51: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
52: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
53: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
54: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,

Line 51: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,

47:
48: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all
49: PROCEDURE insert_trx_line_gl_dist(
50: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
51: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
52: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
53: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
54: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
55: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,

Line 52: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,

48: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all
49: PROCEDURE insert_trx_line_gl_dist(
50: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
51: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
52: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
53: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
54: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
55: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
56: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,

Line 53: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,

49: PROCEDURE insert_trx_line_gl_dist(
50: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
51: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
52: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
53: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
54: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
55: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
56: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
57: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,

Line 54: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,

50: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
51: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
52: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
53: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
54: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
55: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
56: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
57: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
58: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,

Line 55: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,

51: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
52: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
53: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
54: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
55: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
56: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
57: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
58: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
59: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,

Line 56: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,

52: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
53: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
54: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
55: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
56: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
57: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
58: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
59: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
60: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,

Line 57: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,

53: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
54: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
55: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
56: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
57: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
58: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
59: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
60: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
61: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,

Line 58: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,

54: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
55: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
56: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
57: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
58: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
59: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
60: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
61: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
62: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,

Line 59: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,

55: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
56: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
57: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
58: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
59: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
60: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
61: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
62: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
63: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,

Line 60: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,

56: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
57: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
58: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
59: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
60: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
61: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
62: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
63: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
64: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,

Line 61: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,

57: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
58: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
59: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
60: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
61: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
62: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
63: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
64: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
65: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,

Line 62: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,

58: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
59: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
60: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
61: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
62: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
63: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
64: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
65: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
66: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,

Line 63: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,

59: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
60: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
61: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
62: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
63: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
64: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
65: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
66: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
67: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,

Line 64: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,

60: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
61: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
62: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
63: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
64: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
65: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
66: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
67: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
68: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,

Line 65: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,

61: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
62: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
63: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
64: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
65: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
66: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
67: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
68: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
69: p_process_status OUT NOCOPY VARCHAR2,

Line 66: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,

62: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
63: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
64: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
65: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
66: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
67: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
68: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
69: p_process_status OUT NOCOPY VARCHAR2,
70: p_process_message OUT NOCOPY VARCHAR2);

Line 67: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,

63: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
64: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
65: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
66: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
67: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
68: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
69: p_process_status OUT NOCOPY VARCHAR2,
70: p_process_message OUT NOCOPY VARCHAR2);
71:

Line 68: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,

64: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
65: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
66: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
67: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
68: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
69: p_process_status OUT NOCOPY VARCHAR2,
70: p_process_message OUT NOCOPY VARCHAR2);
71:
72:

Line 99: --This procedure updates the MRC data for ra_cust_trx_line_gl_dist_all, ar_payment_schedules_all, ar_receivable_applications_all

95: p_process_status OUT NOCOPY VARCHAR2,
96: p_process_message OUT NOCOPY VARCHAR2);
97:
98:
99: --This procedure updates the MRC data for ra_cust_trx_line_gl_dist_all, ar_payment_schedules_all, ar_receivable_applications_all
100: PROCEDURE maintain_mrc(
101: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
102: p_previous_cust_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
103: p_called_from IN VARCHAR2,