1 PACKAGE jai_ar_processing_pkg
2 /* $Header: jai_ar_prc.pls 120.0 2006/03/27 14:01:29 hjujjuru noship $ */
3 AS
4
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
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
21
22 --This procedure inserts the data into ra_customer_trx_lines_all
23 PROCEDURE insert_trx_lines(
24 p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
25 p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
26 p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
27 p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
28 p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
29 p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
30 p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
31 p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
32 p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
33 p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
34 p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
35 p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
36 p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
37 p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
38 p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
39 p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
40 p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
41 p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
42 p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
43 p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
44 p_process_status OUT NOCOPY VARCHAR2,
45 p_process_message OUT NOCOPY VARCHAR2);
46
47
48 --This procedure inserts the data into ra_cust_trx_line_gl_dist_all
49 PROCEDURE insert_trx_line_gl_dist(
50 p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
51 p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
52 p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
53 p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
54 p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
55 p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
56 p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
57 p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
58 p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
59 p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
60 p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
61 p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
62 p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
63 p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
64 p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
65 p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
66 p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
67 p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
68 p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
69 p_process_status OUT NOCOPY VARCHAR2,
70 p_process_message OUT NOCOPY VARCHAR2);
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,
83 p_process_status OUT NOCOPY VARCHAR2,
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
84 p_process_message OUT NOCOPY VARCHAR2);
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,
93 p_operation_type IN VARCHAR2,
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,
94 p_rec_appl_audit_id IN OUT NOCOPY NUMBER,
95 p_process_status OUT NOCOPY VARCHAR2,
96 p_process_message OUT NOCOPY VARCHAR2);
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);
106
107
108 --This procedure do the processing for imported invoice
109 PROCEDURE process_imported_invoice(
110 p_customer_trx_id IN NUMBER,
111 p_debug IN VARCHAR2 DEFAULT NULL,
112 p_process_status OUT NOCOPY VARCHAR2,
113 p_process_message OUT NOCOPY VARCHAR2);
114
115
116 --This procedure do the processing for manual invoice
117 --This is being called from concurrent - "AR Tax and Freight Defaultation"
118 PROCEDURE process_manual_invoice(
119 errbuf OUT NOCOPY VARCHAR2,
120 retcode OUT NOCOPY VARCHAR2,
121 p_customer_trx_id IN NUMBER,
122 p_link_line_id IN NUMBER);
123
124 END jai_ar_processing_pkg;