APPS.ECE_MVSTO_TRANSACTION dependencies on ECE_OUTPUT

Line 38: FROM ece_output

34: cFilename VARCHAR2(30) := NULL; --2430822
35:
36: CURSOR c_output IS
37: SELECT text
38: FROM ece_output
39: WHERE run_id = iRun_id
40: ORDER BY line_id;
41:
42: BEGIN

Line 67: SELECT ece_output_runs_s.NEXTVAL

63: END IF;
64:
65: xProgress := 'MVSTO-10-1004';
66: BEGIN
67: SELECT ece_output_runs_s.NEXTVAL
68: INTO iRun_id
69: FROM dual;
70:
71: EXCEPTION

Line 79: 'ECE_OUTPUT_RUNS_S');

75: 'ECE_GET_NEXT_SEQ_FAILED',
76: 'PROGRESS_LEVEL',
77: xProgress,
78: 'SEQ',
79: 'ECE_OUTPUT_RUNS_S');
80: END;
81:
82: ec_debug.pl(3, 'iRun_id: ',iRun_id);
83:

Line 125: -- Open the cursor to select the actual file output from ece_output.

121: -- Open the file for write.
122:
123: xProgress := 'MVSTO-10-1040';
124:
125: -- Open the cursor to select the actual file output from ece_output.
126:
127: xProgress := 'MVSTO-10-1050';
128: OPEN c_output;
129: LOOP

Line 146: -- Write the data from ece_output to the output file.

142: end if;
143: EXIT WHEN c_output%NOTFOUND;
144: ec_debug.pl(3, 'l_line_text: ',l_line_text);
145:
146: -- Write the data from ece_output to the output file.
147:
148: xProgress := 'MVSTO-10-1070';
149: utl_file.put_line(uFile_type,
150: l_line_text);

Line 164: -- Assume everything went ok so delete the records from ece_output.

160: if (utl_file.is_open( uFile_type)) then
161: utl_file.fclose(uFile_type);
162: end if;
163:
164: -- Assume everything went ok so delete the records from ece_output.
165:
166: DELETE
167: FROM ece_output
168: WHERE run_id = iRun_id;

Line 167: FROM ece_output

163:
164: -- Assume everything went ok so delete the records from ece_output.
165:
166: DELETE
167: FROM ece_output
168: WHERE run_id = iRun_id;
169:
170: IF SQL%NOTFOUND
171: THEN

Line 178: 'ECE_OUTPUT');

174: 'ECE_NO_ROW_DELETED',
175: 'PROGRESS_LEVEL',
176: xProgress,
177: 'TABLE_NAME',
178: 'ECE_OUTPUT');
179: END IF;
180:
181: IF ec_mapping_utils.ec_get_trans_upgrade_status(cTransaction_Type) = 'U' THEN
182: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);

Line 1636: -- *** With data for each HEADER line, populate the ECE_OUTPUT table

1632: xProgress := 'MVSTOB-10-1380';
1633: dummy := DBMS_SQL.EXECUTE(Header_sel_c);
1634:
1635: -- ********************************************************************
1636: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
1637: -- *** then populate ECE_OUTPUT with data from all DETAILS that belongs
1638: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
1639: -- *** LINE TAX that belongs to the LINE.
1640: -- ********************************************************************

Line 1637: -- *** then populate ECE_OUTPUT with data from all DETAILS that belongs

1633: dummy := DBMS_SQL.EXECUTE(Header_sel_c);
1634:
1635: -- ********************************************************************
1636: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
1637: -- *** then populate ECE_OUTPUT with data from all DETAILS that belongs
1638: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
1639: -- *** LINE TAX that belongs to the LINE.
1640: -- ********************************************************************
1641:

Line 1638: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all

1634:
1635: -- ********************************************************************
1636: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
1637: -- *** then populate ECE_OUTPUT with data from all DETAILS that belongs
1638: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
1639: -- *** LINE TAX that belongs to the LINE.
1640: -- ********************************************************************
1641:
1642: -- HEADER - LINE - LOCATION...

Line 1697: ece_flatfile_pvt.write_to_ece_output(cTransaction_Type,

1693:
1694: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
1695:
1696: xProgress := 'MVSTOB-10-1480';
1697: ece_flatfile_pvt.write_to_ece_output(cTransaction_Type,
1698: cCommunication_Method,
1699: cHeader_Interface,
1700: l_header_tbl,
1701: iOutput_width,

Line 1770: ece_flatfile_pvt.write_to_ece_output(cTransaction_Type,

1766: RPAD(' ',22);
1767: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
1768:
1769: xProgress := 'MVSTOB-10-1560';
1770: ece_flatfile_pvt.write_to_ece_output(cTransaction_Type,
1771: cCommunication_Method,
1772: cLine_Interface,
1773: l_line_tbl,
1774: iOutput_width,

Line 1820: ece_flatfile_pvt.write_to_ece_output(cTransaction_Type,

1816:
1817: ec_debug.pl(3, 'c_file_common_key: ',c_file_common_key);
1818:
1819: xProgress := 'MVSTOB-10-1630';
1820: ece_flatfile_pvt.write_to_ece_output(cTransaction_Type,
1821: cCommunication_Method,
1822: cLocation_Interface,
1823: l_location_tbl,
1824: iOutput_width,