DBA Data[Home] [Help]

APPS.JAI_AR_PROCESSING_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 20: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

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,
22: p_process_status OUT NOCOPY VARCHAR2,
23: p_process_message OUT NOCOPY VARCHAR2)
24: IS

Line 91: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

87:
88:
89: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
90: PROCEDURE maintain_schedules(
91: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
92: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
93: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
94: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
95: p_concurrent_req_num IN NUMBER,

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

89: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
90: PROCEDURE maintain_schedules(
91: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
92: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
93: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
94: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
95: p_concurrent_req_num IN NUMBER,
96: p_request_id IN NUMBER,
97: p_operation_type IN VARCHAR2,

Line 94: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

90: PROCEDURE maintain_schedules(
91: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
92: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
93: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
94: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
95: p_concurrent_req_num IN NUMBER,
96: p_request_id IN NUMBER,
97: p_operation_type IN VARCHAR2,
98: p_payment_audit_id IN OUT NOCOPY NUMBER, -- jai_ar_payment_audits.payment_audit_id%TYPE, -- Harshita for Bug

Line 108: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

104: END ;
105:
106: --This procedure maintains the history of ar_receivable_applications_all in jai_ar_rec_appl_audits
107: PROCEDURE maintain_applications(
108: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
109: p_receivable_application_id IN jai_ar_rec_appl_audits.receivable_application_id%TYPE,
110: p_concurrent_req_num IN NUMBER,
111: p_request_id IN NUMBER,
112: p_operation_type IN VARCHAR2,

Line 126: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

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(
126: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
127: p_previous_cust_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
128: p_called_from IN VARCHAR2,
129: p_process_status OUT NOCOPY VARCHAR2,
130: p_process_message OUT NOCOPY VARCHAR2)

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

123: to avoid spec. change in future.
124: */
125: PROCEDURE maintain_mrc(
126: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
127: p_previous_cust_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
128: p_called_from IN VARCHAR2,
129: p_process_status OUT NOCOPY VARCHAR2,
130: p_process_message OUT NOCOPY VARCHAR2)
131: IS