APPS.ECE_POO_TRANSACTION dependencies on ECE_OUTPUT

Line 43: FROM ece_output

39:
40:
41: CURSOR c_output IS
42: SELECT text
43: FROM ece_output
44: WHERE run_id = iRun_id
45: ORDER BY line_id;
46:
47: BEGIN

Line 75: SELECT ece_output_runs_s.NEXTVAL

71: END IF;
72:
73: xProgress := 'POO-10-1020';
74: BEGIN
75: SELECT ece_output_runs_s.NEXTVAL
76: INTO iRun_id
77: FROM DUAL;
78:
79: EXCEPTION

Line 81: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_OUTPUT_RUNS_S');

77: FROM DUAL;
78:
79: EXCEPTION
80: WHEN NO_DATA_FOUND THEN
81: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_OUTPUT_RUNS_S');
82:
83: END;
84:
85: xProgress := 'POO-10-1025';

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

2799: xProgress := 'POOB-20-1380';
2800: dummy := dbms_sql.execute(Header_sel_c);
2801:
2802: -- ********************************************************************
2803: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
2804: -- *** then populate ECE_OUTPUT with data from all LINES that belongs
2805: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
2806: -- *** LINE TAX that belongs to the LINE.
2807: -- ********************************************************************

Line 2804: -- *** then populate ECE_OUTPUT with data from all LINES that belongs

2800: dummy := dbms_sql.execute(Header_sel_c);
2801:
2802: -- ********************************************************************
2803: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
2804: -- *** then populate ECE_OUTPUT with data from all LINES that belongs
2805: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
2806: -- *** LINE TAX that belongs to the LINE.
2807: -- ********************************************************************
2808:

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

2801:
2802: -- ********************************************************************
2803: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
2804: -- *** then populate ECE_OUTPUT with data from all LINES that belongs
2805: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
2806: -- *** LINE TAX that belongs to the LINE.
2807: -- ********************************************************************
2808:
2809: -- HEADER - LINE - SHIPMENT ...