DBA Data[Home] [Help]

APPS.JAI_AR_PROCESSING_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

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

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,

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

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,

Line 62: p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%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,

Line 63: p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%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,

Line 64: p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%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,

Line 65: p_amount IN ra_cust_trx_line_gl_dist_all.amount%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,

Line 66: p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_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,

Line 67: p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_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,

Line 68: p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%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,

Line 69: p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%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,

Line 70: p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%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,

Line 71: p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_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,

Line 72: p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%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,

Line 73: p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%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,

Line 74: p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%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,

Line 75: p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%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,

Line 76: p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%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,

Line 77: p_org_id IN ra_cust_trx_line_gl_dist_all.org_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,

Line 78: p_percent IN ra_cust_trx_line_gl_dist_all.percent%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,
82: p_process_message OUT NOCOPY VARCHAR2)

Line 79: p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%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)
83: IS

Line 80: p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%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
84: BEGIN

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

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(