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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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:
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,