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 2836: -- *** With data for each HEADER line, populate the ECE_OUTPUT table

2832: xProgress := 'POOB-20-1380';
2833: dummy := dbms_sql.execute(Header_sel_c);
2834:
2835: -- ********************************************************************
2836: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
2837: -- *** then populate ECE_OUTPUT with data from all LINES that belongs
2838: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
2839: -- *** LINE TAX that belongs to the LINE.
2840: -- ********************************************************************

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

2833: dummy := dbms_sql.execute(Header_sel_c);
2834:
2835: -- ********************************************************************
2836: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
2837: -- *** then populate ECE_OUTPUT with data from all LINES that belongs
2838: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
2839: -- *** LINE TAX that belongs to the LINE.
2840: -- ********************************************************************
2841:

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

2834:
2835: -- ********************************************************************
2836: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
2837: -- *** then populate ECE_OUTPUT with data from all LINES that belongs
2838: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
2839: -- *** LINE TAX that belongs to the LINE.
2840: -- ********************************************************************
2841:
2842: -- HEADER - LINE - SHIPMENT ...