APPS.ECE_FLATFILE dependencies on ECE_OUTPUT

Line 148: --- PROCEDURE write_to_ece_output

144:
145:
146:
147:
148: --- PROCEDURE write_to_ece_output
149: --- Creation Feb. 15, 1995
150: --- This report procedure writes data to the ECE_OUTPUT table.
151: --- It put the appropriate record id at the beginning of each record
152: --- lines of data. The entire record line of data is inserted into the

Line 150: --- This report procedure writes data to the ECE_OUTPUT table.

146:
147:
148: --- PROCEDURE write_to_ece_output
149: --- Creation Feb. 15, 1995
150: --- This report procedure writes data to the ECE_OUTPUT table.
151: --- It put the appropriate record id at the beginning of each record
152: --- lines of data. The entire record line of data is inserted into the
153: --- TEXT column in the table.
154: ---

Line 157: PROCEDURE write_to_ece_output(

153: --- TEXT column in the table.
154: ---
155: --- It expects a PL/SQL table of output data (in ASC order)!!!
156:
157: PROCEDURE write_to_ece_output(
158: cTransaction_Type IN VARCHAR2,
159: cCommunication_Method IN VARCHAR2,
160: cInterface_Table IN VARCHAR2,
161: cColumn IN CharTable,

Line 192: insert into ece_output( RUN_ID, LINE_ID, TEXT) values

188: if i < iData_count
189: then
190: If nRecord_Num(i) <> nRecord_Num(i+1)
191: then
192: insert into ece_output( RUN_ID, LINE_ID, TEXT) values
193: (iRun_id, ece_output_lines_s.nextval, substrb(cInsert_stmt,1,iOutput_width));
194: cInsert_stmt := '*' || TO_CHAR(nRecord_Num(i+1));
195: end if;
196: else

Line 193: (iRun_id, ece_output_lines_s.nextval, substrb(cInsert_stmt,1,iOutput_width));

189: then
190: If nRecord_Num(i) <> nRecord_Num(i+1)
191: then
192: insert into ece_output( RUN_ID, LINE_ID, TEXT) values
193: (iRun_id, ece_output_lines_s.nextval, substrb(cInsert_stmt,1,iOutput_width));
194: cInsert_stmt := '*' || TO_CHAR(nRecord_Num(i+1));
195: end if;
196: else
197: insert into ece_output( RUN_ID, LINE_ID, TEXT) values

Line 197: insert into ece_output( RUN_ID, LINE_ID, TEXT) values

193: (iRun_id, ece_output_lines_s.nextval, substrb(cInsert_stmt,1,iOutput_width));
194: cInsert_stmt := '*' || TO_CHAR(nRecord_Num(i+1));
195: end if;
196: else
197: insert into ece_output( RUN_ID, LINE_ID, TEXT) values
198: (iRun_id, ece_output_lines_s.nextval, substrb(cInsert_stmt,1,iOutput_width));
199:
200: end if;
201: end Loop;

Line 198: (iRun_id, ece_output_lines_s.nextval, substrb(cInsert_stmt,1,iOutput_width));

194: cInsert_stmt := '*' || TO_CHAR(nRecord_Num(i+1));
195: end if;
196: else
197: insert into ece_output( RUN_ID, LINE_ID, TEXT) values
198: (iRun_id, ece_output_lines_s.nextval, substrb(cInsert_stmt,1,iOutput_width));
199:
200: end if;
201: end Loop;
202:

Line 203: END write_to_ece_output;

199:
200: end if;
201: end Loop;
202:
203: END write_to_ece_output;
204:
205:
206: PROCEDURE Find_pos(
207: cColumn_Name IN CharTable,