APPS.ECE_POCO_TRANSACTION 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 = iRun_id
42: ORDER BY line_id;
43:
44: BEGIN

Line 71: SELECT ece_output_runs_s.NEXTVAL

67: END IF;
68:
69: xProgress := 'POCO-10-1004';
70: BEGIN
71: SELECT ece_output_runs_s.NEXTVAL
72: INTO iRun_id
73: FROM DUAL;
74:
75: EXCEPTION

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

73: FROM DUAL;
74:
75: EXCEPTION
76: WHEN NO_DATA_FOUND THEN
77: ec_debug.pl(0,'EC','ECE_GET_NEXT_SEQ_FAILED','PROGRESS_LEVEL',xProgress,'SEQ','ECE_OUTPUT_RUNS_S');
78:
79: END;
80:
81: ec_debug.pl(3,'iRun_id: ',iRun_id);

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

2775: xProgress := 'POCOB-20-1380';
2776: dummy := dbms_sql.execute(header_sel_c);
2777:
2778: -- ********************************************************************
2779: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
2780: -- *** then populate ECE_OUTPUT with data from all LINES that belongs
2781: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
2782: -- *** LINE TAX that belongs to the LINE.
2783: -- ********************************************************************

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

2776: dummy := dbms_sql.execute(header_sel_c);
2777:
2778: -- ********************************************************************
2779: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
2780: -- *** then populate ECE_OUTPUT with data from all LINES that belongs
2781: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
2782: -- *** LINE TAX that belongs to the LINE.
2783: -- ********************************************************************
2784:

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

2777:
2778: -- ********************************************************************
2779: -- *** With data for each HEADER line, populate the ECE_OUTPUT table
2780: -- *** then populate ECE_OUTPUT with data from all LINES that belongs
2781: -- *** to the HEADER. Then populate ECE_OUTPUT with data from all
2782: -- *** LINE TAX that belongs to the LINE.
2783: -- ********************************************************************
2784:
2785: -- HEADER - LINE - SHIPMENT ...