DBA Data[Home] [Help]

APPS.JAI_AR_PROCESSING_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 16: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

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,
18: p_process_status OUT NOCOPY VARCHAR2,
19: p_process_message OUT NOCOPY VARCHAR2);
20:

Line 75: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

71:
72:
73: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
74: PROCEDURE maintain_schedules(
75: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
76: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
77: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
78: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
79: p_concurrent_req_num IN NUMBER,

Line 77: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,

73: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
74: PROCEDURE maintain_schedules(
75: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
76: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
77: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
78: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
79: p_concurrent_req_num IN NUMBER,
80: p_request_id IN NUMBER,
81: p_operation_type IN VARCHAR2,

Line 78: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

74: PROCEDURE maintain_schedules(
75: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
76: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
77: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
78: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
79: p_concurrent_req_num IN NUMBER,
80: p_request_id IN NUMBER,
81: p_operation_type IN VARCHAR2,
82: p_payment_audit_id IN OUT NOCOPY NUMBER, -- jai_ar_payment_audits.payment_audit_id%TYPE, -- Harshita for Bug

Line 89: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

85:
86:
87: --This procedure maintains the history of ar_receivable_applications_all in jai_ar_rec_appl_audits
88: PROCEDURE maintain_applications(
89: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
90: p_receivable_application_id IN jai_ar_rec_appl_audits.receivable_application_id%TYPE,
91: p_concurrent_req_num IN NUMBER,
92: p_request_id IN NUMBER,
93: p_operation_type IN VARCHAR2,

Line 101: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

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,
104: p_process_status OUT NOCOPY VARCHAR2,
105: p_process_message OUT NOCOPY VARCHAR2);

Line 102: p_previous_cust_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,

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,
104: p_process_status OUT NOCOPY VARCHAR2,
105: p_process_message OUT NOCOPY VARCHAR2);
106: