13: null ;
14: END ;
15:
16:
17: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all
18: --Also deletes the MRC data from ra_cust_trx_line_gl_dist
19: PROCEDURE delete_trx_data(
20: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
21: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
56: null ;
57: END ;
58:
59:
60: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all
61: PROCEDURE insert_trx_line_gl_dist(
62: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
63: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
64: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
58:
59:
60: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all
61: PROCEDURE insert_trx_line_gl_dist(
62: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
63: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
64: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
65: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
66: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
59:
60: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all
61: PROCEDURE insert_trx_line_gl_dist(
62: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
63: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
64: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
65: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
66: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
67: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
60: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all
61: PROCEDURE insert_trx_line_gl_dist(
62: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
63: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
64: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
65: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
66: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
67: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
68: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
61: PROCEDURE insert_trx_line_gl_dist(
62: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
63: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
64: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
65: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
66: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
67: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
68: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
69: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
62: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
63: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
64: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
65: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
66: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
67: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
68: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
69: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
70: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
63: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
64: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
65: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
66: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
67: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
68: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
69: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
70: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
71: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
64: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
65: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
66: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
67: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
68: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
69: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
70: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
71: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
72: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
65: p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
66: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
67: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
68: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
69: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
70: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
71: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
72: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
73: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
66: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
67: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
68: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
69: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
70: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
71: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
72: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
73: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
74: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
67: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
68: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
69: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
70: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
71: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
72: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
73: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
74: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
75: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
68: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
69: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
70: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
71: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
72: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
73: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
74: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
75: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
76: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
69: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
70: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
71: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
72: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
73: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
74: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
75: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
76: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
77: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
70: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
71: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
72: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
73: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
74: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
75: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
76: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
77: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
78: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
71: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
72: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
73: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
74: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
75: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
76: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
77: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
78: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
79: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
72: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
73: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
74: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
75: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
76: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
77: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
78: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
79: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
80: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
73: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
74: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
75: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
76: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
77: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
78: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
79: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
80: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
81: p_process_status OUT NOCOPY VARCHAR2,
74: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
75: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
76: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
77: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
78: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
79: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
80: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
81: p_process_status OUT NOCOPY VARCHAR2,
82: p_process_message OUT NOCOPY VARCHAR2)
75: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
76: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
77: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
78: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
79: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
80: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
81: p_process_status OUT NOCOPY VARCHAR2,
82: p_process_message OUT NOCOPY VARCHAR2)
83: IS
76: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
77: p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
78: p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
79: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
80: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
81: p_process_status OUT NOCOPY VARCHAR2,
82: p_process_message OUT NOCOPY VARCHAR2)
83: IS
84: BEGIN
117: BEGIN
118: null ;
119: END ;
120:
121: --This procedure updates the MRC data for ra_cust_trx_line_gl_dist_all, ar_payment_schedules_all, ar_receivable_applications_all
122: /* This may be obsolete in R12. We want to retain this procedure
123: to avoid spec. change in future.
124: */
125: PROCEDURE maintain_mrc(