1 PACKAGE ece_ar_transaction AUTHID CURRENT_USER AS
2 -- $Header: ECEINOS.pls 120.2 2005/09/28 07:23:39 arsriniv ship $
3 /* Bug1854866
4 Assigned default values to the parameter
5 cdebug_mode of the procedure extract_ino_outbound
6 since the default values are assigned to these parameters
7 in the package body
8 */
9
10 PROCEDURE extract_ino_outbound(
11 errbuf OUT NOCOPY VARCHAR2,
12 retcode OUT NOCOPY VARCHAR2,
13 cOutputPath IN VARCHAR2,
14 cOutput_Filename IN VARCHAR2,
15 cCDate_From IN VARCHAR2,
16 cCDate_To IN VARCHAR2,
17 cCustomer_Name IN VARCHAR2,
18 cSite_Use_Code IN VARCHAR2,
19 cDocument_Type IN VARCHAR2,
20 cTransaction_Number IN VARCHAR2,
21 cdebug_mode IN NUMBER DEFAULT 0);
22
23 PROCEDURE update_ar(
24 document_type IN VARCHAR2,
25 transaction_id IN NUMBER,
26 installment_number IN NUMBER,
27 multiple_installments_flag IN VARCHAR2,
28 maximum_installment_number IN NUMBER,
29 update_date IN DATE);
30
31 PROCEDURE get_remit_address(
32 customer_trx_id IN NUMBER,
33 remit_to_address1 OUT NOCOPY VARCHAR2,
34 remit_to_address2 OUT NOCOPY VARCHAR2,
35 remit_to_address3 OUT NOCOPY VARCHAR2,
36 remit_to_address4 OUT NOCOPY VARCHAR2,
37 remit_to_city OUT NOCOPY VARCHAR2,
38 remit_to_county OUT NOCOPY VARCHAR2,
39 remit_to_state OUT NOCOPY VARCHAR2,
40 remit_to_province OUT NOCOPY VARCHAR2,
41 remit_to_country OUT NOCOPY VARCHAR2,
42 remit_to_code_int OUT NOCOPY VARCHAR2,
43 remit_to_postal_code OUT NOCOPY VARCHAR2,
44 remit_to_customer_name OUT NOCOPY VARCHAR2,
45 remit_to_edi_location_code OUT NOCOPY VARCHAR2);
46
47 PROCEDURE get_payment(
48 customer_trx_id IN NUMBER,
49 installment_number IN NUMBER,
50 multiple_installments_flag OUT NOCOPY VARCHAR2,
51 maximum_installment_number OUT NOCOPY NUMBER,
52 amount_tax_due OUT NOCOPY NUMBER,
53 amount_charges_due OUT NOCOPY NUMBER,
54 amount_freight_due OUT NOCOPY NUMBER,
55 amount_line_items_due OUT NOCOPY NUMBER,
56 total_amount_due OUT NOCOPY NUMBER);
57
58 --Bug 2389231 Added a new column invoice_date.
59
60 PROCEDURE get_term_discount(
61 document_type IN VARCHAR2,
62 term_id IN NUMBER,
63 term_sequence_number IN NUMBER,
64 invoice_date IN DATE,
65 discount_percent1 OUT NOCOPY NUMBER,
66 discount_days1 OUT NOCOPY NUMBER,
67 discount_date1 OUT NOCOPY DATE,
68 discount_day_of_month1 OUT NOCOPY NUMBER,
69 discount_months_forward1 OUT NOCOPY NUMBER,
70 discount_percent2 OUT NOCOPY NUMBER,
71 discount_days2 OUT NOCOPY NUMBER,
72 discount_date2 OUT NOCOPY DATE,
73 discount_day_of_month2 OUT NOCOPY NUMBER,
74 discount_months_forward2 OUT NOCOPY NUMBER,
75 discount_percent3 OUT NOCOPY NUMBER,
76 discount_days3 OUT NOCOPY NUMBER,
77 discount_date3 OUT NOCOPY DATE,
78 discount_day_of_month3 OUT NOCOPY NUMBER,
79 discount_months_forward3 OUT NOCOPY NUMBER);
80
81 function get_currency_code
82 return varchar2;
83
84 PROCEDURE put_data_to_output_table(
85 cCommunication_Method IN VARCHAR2,
86 cTransaction_Type IN VARCHAR2,
87 iOutput_width IN INTEGER,
88 iRun_id IN INTEGER,
89 cHeader_Interface IN VARCHAR2,
90 cHeader_1_Interface IN VARCHAR2,
91 cAlw_chg_Interface IN VARCHAR2,
92 cLine_Interface IN VARCHAR2,
93 cLine_t_Interface IN VARCHAR2);
94
95 PROCEDURE populate_ar_trx(
96 cCommunication_Method IN VARCHAR2,
97 cTransaction_Type IN VARCHAR2,
98 iOutput_Width IN INTEGER,
99 dTransaction_date IN DATE,
100 iRun_Id IN INTEGER,
101 cHeader_Interface IN VARCHAR2,
102 cHeader_1_Interface IN VARCHAR2,
103 cAlw_chg_Interface IN VARCHAR2,
104 cLine_Interface IN VARCHAR2,
105 cLine_t_Interface IN VARCHAR2,
106 cCreate_Date_From IN DATE,
107 cCreate_Date_To IN DATE,
108 cCustomer_Name IN VARCHAR2,
109 cSite_Use_Code IN VARCHAR2,
110 cDocument_Type IN VARCHAR2,
111 cTransaction_Number IN VARCHAR2);
112
113 END;
114