eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECE_AR_TRANSACTION dependencies on ECE_OUTPUT

Line 61: FROM ece_output

57: ece_transaction_disabled EXCEPTION;
58:
59: CURSOR c_output IS
60: SELECT text
61: FROM ece_output
62: WHERE run_id = iRun_id
63: ORDER BY line_id;
64:
65: BEGIN

Line 90: SELECT ece_output_runs_s.NEXTVAL INTO iRun_id

86: END IF;
87:
88: xProgress := 'INO-10-1015';
89: BEGIN
90: SELECT ece_output_runs_s.NEXTVAL INTO iRun_id
91: FROM DUAL;
92:
93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN

Line 101: 'ECE_OUTPUT_RUNS_S');

97: 'ECE_GET_NEXT_SEQ_FAILED',
98: 'PROGRESS_LEVEL',
99: xProgress,
100: 'SEQ',
101: 'ECE_OUTPUT_RUNS_S');
102:
103: END;
104: ec_debug.pl(3,'iRun_id: ',iRun_id);
105:

Line 160: 'ECE_OUTPUT');

156: 'ECE_GET_COUNT_FAILED',
157: 'PROGRESS_LEVEL',
158: xProgress,
159: 'TABLE_NAME',
160: 'ECE_OUTPUT');
161:
162: END;
163: ec_debug.pl(3,'xHeaderCount: ',xHeaderCount);
164:

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

189:
190: -- Open the file for write.
191: xProgress := 'INO-10-1060';
192:
193: -- Open the cursor to select the actual file output from ece_output.
194: xProgress := 'INO-10-1070';
195: OPEN c_output;
196: LOOP
197: FETCH c_output INTO l_line_text;

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

204: end if;
205: end if;
206: EXIT WHEN c_output%NOTFOUND;
207:
208: -- Write the data from ece_output to the output file.
209: xProgress := 'INO-10-1080';
210: utl_file.put_line(uFile_type,
211: l_line_text);
212:

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

219: if (utl_file.is_open(uFile_type)) then
220: utl_file.fclose(uFile_type);
221: end if;
222:
223: -- Assume everything went ok so delete the records from ece_output.
224: xProgress := 'INO-10-1100';
225: DELETE FROM ece_output
226: WHERE run_id = iRun_id;
227:

Line 225: DELETE FROM ece_output

221: end if;
222:
223: -- Assume everything went ok so delete the records from ece_output.
224: xProgress := 'INO-10-1100';
225: DELETE FROM ece_output
226: WHERE run_id = iRun_id;
227:
228: IF SQL%NOTFOUND THEN
229: ec_debug.pl(1,

Line 235: 'ECE_OUTPUT' );

231: 'ECE_NO_ROW_DELETED',
232: 'PROGRESS_LEVEL',
233: xProgress,
234: 'TABLE_NAME',
235: 'ECE_OUTPUT' );
236: END IF;
237:
238: -- Check if the Automotive Module is installed and if it is installed,
239: -- export the file created to Radley Caras

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

1318: -- This procedure has the following functionalities:
1319: -- 1. Build SQL statement dynamically to extract data from
1320: -- Interface Tables.
1321: -- 2. Execute the dynamic SQL statement.
1322: -- 3. Populate the ECE_OUTPUT table with the extracted data.
1323: -- 4. Delete data from Interface Tables.
1324: -- --------------------------------------------------------------------------
1325:
1326: PROCEDURE Put_Data_To_Output_Table ( cCommunication_Method IN VARCHAR2,

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

2377: xProgress := '2390-60';
2378: dummy := dbms_sql.execute ( Header_sel_c );
2379:
2380: /*** --------------------------------------------------------------
2381: *** With data for each HEADER line, populate the ECE_OUTPUT table
2382: *** then populate ECE_OUTPUT with data from all HEADER 1 that belongs
2383: *** to the HEADER and Allowances and Charges that belong to the header
2384: *** Then populate ECE_OUTPUT with data from all
2385: *** LINES that belongs to the HEADER and then populate ECE_OUTPUT with

Line 2382: *** then populate ECE_OUTPUT with data from all HEADER 1 that belongs

2378: dummy := dbms_sql.execute ( Header_sel_c );
2379:
2380: /*** --------------------------------------------------------------
2381: *** With data for each HEADER line, populate the ECE_OUTPUT table
2382: *** then populate ECE_OUTPUT with data from all HEADER 1 that belongs
2383: *** to the HEADER and Allowances and Charges that belong to the header
2384: *** Then populate ECE_OUTPUT with data from all
2385: *** LINES that belongs to the HEADER and then populate ECE_OUTPUT with
2386: *** data from all LINE TAX, Allowances and Charges that belong to the line

Line 2384: *** Then populate ECE_OUTPUT with data from all

2380: /*** --------------------------------------------------------------
2381: *** With data for each HEADER line, populate the ECE_OUTPUT table
2382: *** then populate ECE_OUTPUT with data from all HEADER 1 that belongs
2383: *** to the HEADER and Allowances and Charges that belong to the header
2384: *** Then populate ECE_OUTPUT with data from all
2385: *** LINES that belongs to the HEADER and then populate ECE_OUTPUT with
2386: *** data from all LINE TAX, Allowances and Charges that belong to the line
2387: *** ------------------------------------------------------------***/
2388:

Line 2385: *** LINES that belongs to the HEADER and then populate ECE_OUTPUT with

2381: *** With data for each HEADER line, populate the ECE_OUTPUT table
2382: *** then populate ECE_OUTPUT with data from all HEADER 1 that belongs
2383: *** to the HEADER and Allowances and Charges that belong to the header
2384: *** Then populate ECE_OUTPUT with data from all
2385: *** LINES that belongs to the HEADER and then populate ECE_OUTPUT with
2386: *** data from all LINE TAX, Allowances and Charges that belong to the line
2387: *** ------------------------------------------------------------***/
2388:
2389: -- HEADER - HEADER 1 - HEADER ALLOWANCES and CHARGES - LINE - LINE ALLOWANCES and CHARGES

Line 2452: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

2448: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
2449:
2450:
2451: xProgress := '2450-60';
2452: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
2453: cCommunication_Method,
2454: cHeader_Interface,
2455: l_Header_tbl,
2456: iOutput_width,

Line 2527: ece_flatfile_pvt.write_to_ece_output( cTransaction_Type,

2523: iHeader_1_count + 2,
2524: rHeader_1_X_rowid );
2525:
2526: xProgress := '2520-60';
2527: ece_flatfile_pvt.write_to_ece_output( cTransaction_Type,
2528: cCommunication_Method,
2529: cHeader_1_Interface,
2530: l_Header_1_tbl,
2531: iOutput_width,

Line 2603: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

2599: iAlw_chg_h_count + 2,
2600: rAlw_chg_X_rowid );
2601:
2602: xProgress := '2570-60';
2603: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
2604: cCommunication_Method,
2605: cAlw_chg_Interface,
2606: l_alw_chg_h_tbl,
2607: iOutput_width,

Line 2705: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

2701: RPAD(' ',22);
2702: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
2703:
2704: xProgress := '2660-60';
2705: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
2706: cCommunication_Method,
2707: cLine_Interface,
2708: l_Line_tbl,
2709: iOutput_width,

Line 2782: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

2778: 22);
2779: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
2780:
2781: xProgress := '2740-60';
2782: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
2783: cCommunication_Method,
2784: cLine_t_Interface,
2785: l_Line_t_tbl,
2786: iOutput_width,

Line 2863: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,

2859: iAlw_chg_l_count + 2,
2860: rAlw_chg_X_rowid );
2861:
2862: xProgress := '2820-60';
2863: ece_flatfile_pvt.write_to_ece_output ( cTransaction_Type,
2864: cCommunication_Method,
2865: cAlw_chg_Interface,
2866: l_alw_chg_l_tbl,
2867: iOutput_width,