1 PACKAGE ece_poo_transaction AS
2 -- $Header: ECEPOOS.pls 120.4.12010000.1 2008/07/25 07:23:32 appldev ship $
3
4 G_MAX_ATT_SEG_SIZE CONSTANT NUMBER := 900;
5 G_DEFAULT_ATT_SEG_SIZE CONSTANT NUMBER := 400;
6 /*Bug 1854866
7 Assigned default values to the parameter
8 v_debug_mode of the procedure extract_poo_outbound
9 since the default values are assigned to these parameters
10 in the package body
11 */
12
13 /* Bug 1891291
14 Replaced project interface table name
15 by distribution interface table name
16 in procedure specification.
17 Also renamed populate_project_info
18 to populate_distribution_info and
19 put_project_data_to_output_tbl to
20 put_distdata_to_out_tbl
21 */
22
23 /* Bug 2490109
24 Defined variables which will be accessed by POO and POCO program
25 */
26
27 project_sel_c INTEGER:=0;
28 project_del_c1 INTEGER;
29 project_del_c2 INTEGER;
30 l_project_tbl ece_flatfile_pvt.Interface_tbl_type;
31 uFile_type utl_file.file_type;
32 /* BUG:5367903 */
33 C_ANY_VALUE VARCHAR2(120):= '_ANY_VALUE_';
34 PROCEDURE extract_poo_outbound(
35 errbuf OUT NOCOPY VARCHAR2,
36 retcode OUT NOCOPY VARCHAR2,
37 cOutput_Path IN VARCHAR2,
38 cOutput_Filename IN VARCHAR2,
39 cPO_Number_From IN VARCHAR2,
40 cPO_Number_To IN VARCHAR2,
41 cCDate_From IN VARCHAR2,
42 cCDate_To IN VARCHAR2,
43 cPC_Type IN VARCHAR2,
44 cVendor_Name IN VARCHAR2,
45 cVendor_Site_Code IN VARCHAR2,
46 v_debug_mode IN NUMBER DEFAULT 0);
47
48 PROCEDURE populate_poo_trx(
49 cCommunication_Method IN VARCHAR2,
50 cTransaction_Type IN VARCHAR2,
51 iOutput_Width IN INTEGER,
52 dTransaction_date IN DATE,
53 iRun_Id IN INTEGER,
54 cHeader_Interface IN VARCHAR2,
55 cLine_Interface IN VARCHAR2,
56 cShipment_Interface IN VARCHAR2,
57 cDistribution_Interface IN VARCHAR2,
58 cCreate_Date_From IN DATE,
59 cCreate_Date_To IN DATE,
60 cSupplier_Name IN VARCHAR2,
61 cSupplier_Site IN VARCHAR2,
62 cDocument_Type IN VARCHAR2,
63 cPO_Number_From IN VARCHAR2,
64 cPO_Number_To IN VARCHAR2);
65
66 PROCEDURE put_data_to_output_table(
67 cCommunication_Method IN VARCHAR2,
68 cTransaction_Type IN VARCHAR2,
69 iOutput_width IN INTEGER,
70 iRun_id IN INTEGER,
71 cHeader_Interface IN VARCHAR2,
72 cLine_Interface IN VARCHAR2,
73 cShipment_Interface IN VARCHAR2,
74 cDistribution_Interface IN VARCHAR2);
75
76 PROCEDURE update_po(
77 document_type IN VARCHAR2,
78 po_number IN VARCHAR2,
79 po_type IN VARCHAR2,
80 release_number IN VARCHAR2);
81
82 PROCEDURE POPULATE_DISTRIBUTION_INFO(
83 cCommunication_Method IN VARCHAR2,
84 cTransaction_Type IN VARCHAR2,
85 iRun_id IN INTEGER,
86 cDistribution_Interface IN VARCHAR2,
87 l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
88 cPO_Header_ID IN NUMBER,
89 cPO_Release_ID IN NUMBER,
90 cPO_Line_ID IN NUMBER,
91 cPO_Line_Location_ID IN NUMBER,
92 cFile_Common_Key IN VARCHAR2); --bug 2823215
93
94 PROCEDURE PUT_DISTDATA_TO_OUT_TBL(
95 cCommunication_Method IN VARCHAR2,
96 cTransaction_Type IN VARCHAR2,
97 iOutput_width IN INTEGER,
98 iRun_id IN INTEGER,
99 cDistribution_Interface IN VARCHAR2,
100 cPO_Header_ID IN NUMBER,
101 cPO_Release_ID IN NUMBER,
102 cPO_Line_ID IN NUMBER,
103 cPO_Line_Location_ID IN NUMBER,
104 cFile_Common_Key IN VARCHAR2);
105
106 PROCEDURE populate_text_attachment(
107 cCommunication_Method IN VARCHAR2,
108 cTransaction_Type IN VARCHAR2,
109 iRun_id IN INTEGER,
110 cHeader_Output_Level IN NUMBER,
111 cDetail_Output_Level IN NUMBER,
112 cAtt_Header_Interface IN VARCHAR2,
113 cAtt_Detail_Interface IN VARCHAR2,
114 cEntity_Name IN VARCHAR2,
115 cName IN VARCHAR2,
116 cPK1_Value IN VARCHAR2,
117 cPK2_Value IN VARCHAR2,
118 cPK3_Value IN VARCHAR2,
119 cPK4_Value IN VARCHAR2,
120 cPK5_Value IN VARCHAR2,
121 cSegment_Size IN NUMBER,
122 l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
123 cFile_Common_Key IN VARCHAR2,
124 l_att_header_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
125 l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
126 l_key_count IN OUT NOCOPY NUMBER); -- bug 2823215
127
128 PROCEDURE populate_text_att_detail(
129 cCommunication_Method IN VARCHAR2,
130 cTransaction_Type IN VARCHAR2,
131 iRun_id IN INTEGER,
132 cDetail_Output_Level IN NUMBER,
133 cAtt_Detail_Interface IN VARCHAR2,
134 cAtt_Seq_Num IN NUMBER,
135 cEntity_Name IN VARCHAR2,
136 cName IN VARCHAR2,
137 cPK1_Value IN VARCHAR2,
138 cPK2_Value IN VARCHAR2,
139 cPK3_Value IN VARCHAR2,
140 cPK4_Value IN VARCHAR2,
141 cPK5_Value IN VARCHAR2,
142 cData_Type_ID IN NUMBER,
143 cSegment_Size IN NUMBER,
144 l_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
145 cAtt_doc_id IN NUMBER, -- bug 2187958
146 cFile_Common_Key IN VARCHAR2,
147 l_att_detail_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type); -- bug 2823215
148
149 PROCEDURE put_att_to_output_table(
150 cCommunication_Method IN VARCHAR2,
151 cTransaction_Type IN VARCHAR2,
152 iOutput_Width IN INTEGER,
153 iRun_id IN INTEGER,
154 cHeader_Output_Level IN NUMBER,
155 cDetail_Output_Level IN NUMBER,
156 cHeader_Interface IN VARCHAR2,
157 cDetail_Interface IN VARCHAR2,
158 cEntity_Name IN VARCHAR2,
159 cName IN VARCHAR2,
160 cPK1_Value IN VARCHAR2,
161 cPK2_Value IN VARCHAR2,
162 cPK3_Value IN VARCHAR2,
163 cPK4_Value IN VARCHAR2,
164 cPK5_Value IN VARCHAR2,
165 cFile_Common_Key IN VARCHAR2);
166
167 PROCEDURE put_att_detail_to_output_table(
168 cCommunication_Method IN VARCHAR2,
169 cTransaction_Type IN VARCHAR2,
170 iOutput_Width IN INTEGER,
171 iRun_id IN INTEGER,
172 cDetail_Output_Level IN NUMBER,
173 cHeader_Interface IN VARCHAR2,
174 cDetail_Interface IN VARCHAR2,
175 cAtt_Seq_Num IN NUMBER,
176 cEntity_Name IN VARCHAR2,
177 cName IN VARCHAR2,
178 cPK1_Value IN VARCHAR2,
179 cPK2_Value IN VARCHAR2,
180 cPK3_Value IN VARCHAR2,
181 cPK4_Value IN VARCHAR2,
182 cPK5_Value IN VARCHAR2,
183 cFile_Common_Key IN VARCHAR2,
184 cAtt_Doc_ID IN NUMBER); --Bug 2187958
185
186 PROCEDURE write_to_file(
187 cTransaction_Type IN VARCHAR2,
188 cCommunication_Method IN VARCHAR2,
189 cInterface_Table IN VARCHAR2,
190 p_Interface_tbl IN ece_flatfile_pvt.Interface_tbl_type,
191 iOutput_width IN INTEGER,
192 iRun_id IN INTEGER,
193 p_common_key IN VARCHAR2,
194 p_foreign_key IN NUMBER);
195
196
197 END;
198