APPS.ECE_ADVO_ADVICE_PKG dependencies on ECE_OUTPUT

Line 45: FROM ece_output

41: ece_transaction_disabled EXCEPTION;
42:
43: CURSOR c_output IS
44: SELECT text
45: FROM ece_output
46: WHERE run_id = p_run_id
47: ORDER BY line_id;
48:
49: BEGIN

Line 80: SELECT ece_output_runs_s.NEXTVAL

76: END IF;
77:
78: xProgress := 'ADVO-10-1005';
79: BEGIN
80: SELECT ece_output_runs_s.NEXTVAL
81: INTO p_run_id
82: FROM sys.dual;
83: EXCEPTION
84: WHEN NO_DATA_FOUND THEN

Line 91: 'ECE_OUTPUT_RUNS_S' );

87: 'ECE_GET_NEXT_SEQ_FAILED',
88: 'PROGRESS_LEVEL',
89: xProgress,
90: 'SEQ',
91: 'ECE_OUTPUT_RUNS_S' );
92: END;
93: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
94:
95: xProgress := 'ADVO-10-1010';

Line 134: ** Open the cursor to select the actual file output from ece_output.

130: xProgress := 'ADVO-10-1050';
131:
132: /*
133: **
134: ** Open the cursor to select the actual file output from ece_output.
135: **
136: */
137:
138: xProgress := 'ADVO-10-1060';

Line 157: ** Write the data from ece_output to the output file.

153: ec_debug.pl ( 3, 'l_line_text: ',l_line_text );
154:
155: /*
156: **
157: ** Write the data from ece_output to the output file.
158: **
159: */
160:
161: xProgress := 'ADVO-10-1070';

Line 181: ** Assume everything went ok so delete the records from ece_output.

177: end if;
178:
179: /*
180: **
181: ** Assume everything went ok so delete the records from ece_output.
182: **
183: */
184:
185: xProgress := 'ADVO-10-1090';

Line 190: FROM ece_output

186: ec_debug.pl ( 0, 'EC', 'ECE_ADVO_COMPLETE', NULL );
187:
188: xProgress := 'ADVO-10-1100';
189: DELETE
190: FROM ece_output
191: WHERE run_id = p_run_id;
192:
193: IF SQL%NOTFOUND
194: THEN

Line 201: 'ECE_OUTPUT' );

197: 'ECE_NO_ROW_DELETED',
198: 'PROGRESS_LEVEL',
199: xProgress,
200: 'TABLE_NAME',
201: 'ECE_OUTPUT' );
202: END IF;
203:
204: --- Everything is successful. Commit the Changes.
205: commit;

Line 1138: -- 3. Populate the ECE_OUTPUT table with the extracted data.

1134: -- This procedure has the following functionalities:
1135: -- 1. Build SQL statement dynamically to extract data from
1136: -- Interface Tables.
1137: -- 2. Execute the dynamic SQL statement.
1138: -- 3. Populate the ECE_OUTPUT table with the extracted data.
1139: -- 4. Delete data from Interface Tables.
1140: -- **************************************************************************
1141:
1142:

Line 1682: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

1678: **
1679: */
1680:
1681: xProgress := 'ADVOB-20-1450';
1682: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
1683: cCommunication_Method,
1684: cHeader_Interface,
1685: l_header_tbl,
1686: iOutput_width,

Line 1782: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

1778: **
1779: */
1780:
1781: xProgress := 'ADVOB-20-1530';
1782: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
1783: cCommunication_Method,
1784: cLine_Interface,
1785: l_line_tbl,
1786: iOutput_width,