4
1 PACKAGE BODY jai_ar_processing_pkg
2 /* $Header: jai_ar_prc.plb 120.0 2006/03/27 14:02:19 hjujjuru noship $ */
3 AS
5 PROCEDURE process_batch(
6 ERRBUF OUT NOCOPY VARCHAR2,
7 RETCODE OUT NOCOPY VARCHAR2,
8 p_org_id IN NUMBER,
9 p_all_orgs IN VARCHAR2,
10 p_debug IN VARCHAR2 DEFAULT NULL)
11 IS
12 BEGIN
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,
22 p_process_status OUT NOCOPY VARCHAR2,
23 p_process_message OUT NOCOPY VARCHAR2)
24 IS
25 BEGIN
26 null ;
27 END ;
28
29
30 --This procedure inserts the data into ra_customer_trx_lines_all
31 PROCEDURE insert_trx_lines(
32 p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
33 p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
34 p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
35 p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
36 p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
37 p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
38 p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
39 p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
40 p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
41 p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
42 p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
43 p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
44 p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
45 p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
46 p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
47 p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
48 p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
49 p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
50 p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
51 p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
52 p_process_status OUT NOCOPY VARCHAR2,
53 p_process_message OUT NOCOPY VARCHAR2)
54 IS
55 BEGIN
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,
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,
72 p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%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,
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,
82 p_process_message OUT NOCOPY VARCHAR2)
83 IS
84 BEGIN
85 null ;
86 END ;
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,
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
99 p_process_status OUT NOCOPY VARCHAR2,
100 p_process_message OUT NOCOPY VARCHAR2)
101 IS
102 BEGIN
103 null ;
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,
113 p_rec_appl_audit_id IN OUT NOCOPY NUMBER,
114 p_process_status OUT NOCOPY VARCHAR2,
115 p_process_message OUT NOCOPY VARCHAR2)
116 IS
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(
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
132 BEGIN
133 null ;
134 END ;
135
136 --This procedure do the processing for imported invoice
137 PROCEDURE process_imported_invoice(
138 p_customer_trx_id IN NUMBER,
139 p_debug IN VARCHAR2 DEFAULT NULL,
140 p_process_status OUT NOCOPY VARCHAR2,
141 p_process_message OUT NOCOPY VARCHAR2)
142 IS
143 BEGIN
144 null ;
145 END ;
146
147 --This procedure do the processing for manual invoice
148 --This is being called from concurrent - "AR Tax and Freight Defaultation"
149 PROCEDURE process_manual_invoice(
150 errbuf OUT NOCOPY VARCHAR2,
151 retcode OUT NOCOPY VARCHAR2,
152 p_customer_trx_id IN NUMBER,
153 p_link_line_id IN NUMBER)
154 IS
155 BEGIN
156 null ;
157 END ;
158
159 END jai_ar_processing_pkg;