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_SPSO_TRANS1 dependencies on ECE_OUTPUT

Line 40: FROM ece_output

36:
37:
38: CURSOR c_output IS
39: SELECT text
40: FROM ece_output
41: WHERE run_id = p_run_id
42: ORDER BY line_id;
43:
44: BEGIN

Line 65: SELECT ece_output_runs_s.NEXTVAL

61: END IF;
62:
63: xProgress := 'SPSO-10-1005';
64: BEGIN
65: SELECT ece_output_runs_s.NEXTVAL
66: INTO p_run_id
67: FROM sys.dual;
68: EXCEPTION
69: WHEN NO_DATA_FOUND THEN

Line 76: 'ECE_OUTPUT_RUNS_S' );

72: 'ECE_GET_NEXT_SEQ_FAILED',
73: 'PROGRESS_LEVEL',
74: xProgress,
75: 'SEQ',
76: 'ECE_OUTPUT_RUNS_S' );
77: END;
78: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
79:
80: xProgress := 'SPSO-10-1010';

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

121: p_item_d_interface );
122:
123: xProgress := 'SPSO-10-1070';
124:
125: -- Open the cursor to select the actual file output from ece_output.
126:
127: xProgress := 'SPSO-10-1080';
128: OPEN c_output;
129: LOOP

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

139: end if;
140:
141: EXIT WHEN c_output%NOTFOUND;
142:
143: -- Write the data from ece_output to the output file.
144:
145: xProgress := 'SPSO-10-1090';
146: utl_file.put_line ( uFile_type,l_line_text );
147: ec_debug.pl ( 3, 'l_line_text: ',l_line_text );

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

159:
160: xProgress := 'SPSO-10-1110';
161: ec_debug.pl ( 0, 'EC', 'ECE_SPSO_COMPLETE ',NULL );
162:
163: -- Assume everything went ok so delete the records from ece_output.
164:
165: xProgress := 'SPSO-10-1120';
166: DELETE
167: FROM ece_output

Line 167: FROM ece_output

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

Line 178: 'ECE_OUTPUT' );

174: 'ECE_NO_ROW_PROCESSED',
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(p_transaction_type) = 'U' THEN
182: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);

Line 309: FROM ece_output

305: ece_transaction_disabled EXCEPTION;
306:
307: CURSOR c_output IS
308: SELECT text
309: FROM ece_output
310: WHERE run_id = p_run_id
311: ORDER BY line_id;
312:
313: BEGIN

Line 335: SELECT ece_output_runs_s.NEXTVAL

331: END IF;
332:
333: xProgress := 'SSSO-10-1005';
334: BEGIN
335: SELECT ece_output_runs_s.NEXTVAL
336: INTO p_run_id
337: FROM sys.dual;
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN

Line 346: 'ECE_OUTPUT_RUNS_S' );

342: 'ECE_GET_NEXT_SEQ_FAILED',
343: 'PROGRESS_LEVEL',
344: xProgress,
345: 'SEQ',
346: 'ECE_OUTPUT_RUNS_S' );
347: END;
348: ec_debug.pl(3, 'p_run_id: ',p_run_id);
349:
350: xProgress := 'SSSO-10-1010';

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

392:
393:
394: xProgress := 'SSSO-10-1070';
395:
396: -- Open the cursor to select the actual file output from ece_output.
397:
398: xProgress := 'SSSO-10-1080';
399: OPEN c_output;
400: LOOP

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

408: end if;
409: end if;
410: EXIT WHEN c_output%NOTFOUND;
411:
412: -- Write the data from ece_output to the output file.
413:
414: xProgress := 'SSSO-10-1090';
415: utl_file.put_line ( uFile_type,
416: l_line_text );

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

429:
430: xProgress := 'SSSO-10-1110';
431: ec_debug.pl ( 0, 'EC', 'ECE_SSSO_COMPLETE', NULL );
432:
433: -- Assume everything went ok so delete the records from ece_output.
434:
435: xProgress := 'SSSO-10-1120';
436: DELETE
437: FROM ece_output

Line 437: FROM ece_output

433: -- Assume everything went ok so delete the records from ece_output.
434:
435: xProgress := 'SSSO-10-1120';
436: DELETE
437: FROM ece_output
438: WHERE run_id = p_run_id;
439:
440: IF SQL%NOTFOUND
441: THEN

Line 448: 'ECE_OUTPUT' );

444: 'ECE_NO_ROW_PROCESSED',
445: 'PROGRESS_LEVEL',
446: xProgress,
447: 'TABLE_NAME',
448: 'ECE_OUTPUT' );
449: END IF;
450:
451:
452: IF ec_mapping_utils.ec_get_trans_upgrade_status(p_transaction_type) = 'U' THEN

Line 2503: 3. Populate the ECE_OUTPUT table with the extracted data.

2499: ** This procedure has the following functionalities: **
2500: ** 1. Build SQL statement dynamically to extract data from **
2501: ** Interface Tables. **
2502: ** 2. Execute the dynamic SQL statement. **
2503: ** 3. Populate the ECE_OUTPUT table with the extracted data. **
2504: ** 4. Delete data from Interface Tables. **
2505: ** To use this procedure must have access to the procedures in **
2506: ** ECE_FLATFILE package. **
2507: ** HISTORY: **

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

3350: x_dummy := dbms_sql.execute(v_header_sel_c);
3351:
3352:
3353: --***********************************************************************
3354: --*** With data for each HEADER line, populate the ECE_OUTPUT table **
3355: --*** then populate ECE_OUTPUT with data from all ITEMS that belong **
3356: --*** to the HEADER. Then populate ECE_OUTPUT with data from all **
3357: --*** ITEM DETAILS that belongs to the ITEM. **
3358: --***********************************************************************

Line 3355: --* then populate ECE_OUTPUT with data from all ITEMS that belong

3351:
3352:
3353: --***********************************************************************
3354: --*** With data for each HEADER line, populate the ECE_OUTPUT table **
3355: --*** then populate ECE_OUTPUT with data from all ITEMS that belong **
3356: --*** to the HEADER. Then populate ECE_OUTPUT with data from all **
3357: --*** ITEM DETAILS that belongs to the ITEM. **
3358: --***********************************************************************
3359:

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

3352:
3353: --***********************************************************************
3354: --*** With data for each HEADER line, populate the ECE_OUTPUT table **
3355: --*** then populate ECE_OUTPUT with data from all ITEMS that belong **
3356: --*** to the HEADER. Then populate ECE_OUTPUT with data from all **
3357: --*** ITEM DETAILS that belongs to the ITEM. **
3358: --***********************************************************************
3359:
3360: xProgress := 'SPSOB-50-1560';

Line 3410: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,

3406: RPAD(' ',22);
3407: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
3408:
3409: xProgress := 'SPSOB-50-1630';
3410: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,
3411: p_communication_method,
3412: p_header_interface,
3413: l_header_tbl,
3414: p_output_width,

Line 3503: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,

3499: RPAD(' ',22);
3500: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
3501:
3502: xProgress := 'SPSOB-50-1730';
3503: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,
3504: p_communication_method,
3505: p_item_interface,
3506: l_item_tbl,
3507: p_output_width,

Line 3587: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,

3583: 22);
3584: ec_debug.pl ( 3, 'c_file_common_key: ',c_file_common_key );
3585:
3586: xProgress := 'SPSOB-50-1810';
3587: ece_flatfile_pvt.write_to_ece_output ( p_transaction_type,
3588: p_communication_method,
3589: p_item_d_interface,
3590: l_item_d_tbl,
3591: p_output_width,

Line 3633: ece_flatfile_pvt.write_to_ece_output(

3629: || rpad(substr(nvl(l_item_tbl(nItem_key_pos).value,' '), 1, 22), 22)
3630: || rpad(substr(nvl(l_item_d_tbl(nItem_d_key_pos).value,' '), 1, 22), 22);
3631:
3632: xProgress := 'SPSOB-50-1845';
3633: ece_flatfile_pvt.write_to_ece_output(
3634: p_transaction_type, p_communication_method, p_ship_d_interface,
3635: l_ship_d_tbl, p_output_width, p_run_id, c_file_common_key);
3636:
3637: xProgress := 'SPSOB-50-1850';