APPS.EC_OUTBOUND_STAGE dependencies on ECE_STAGE

Line 4: TYPE STAGE_ID_TYPE is table of ece_stage.stage_id%TYPE index by binary_integer;

1: PACKAGE BODY EC_OUTBOUND_STAGE AS
2: -- $Header: ECOSTGB.pls 120.2.12000000.2 2007/03/09 14:41:15 cpeixoto ship $
3: --bug 3133379
4: TYPE STAGE_ID_TYPE is table of ece_stage.stage_id%TYPE index by binary_integer;
5: TYPE TRANSACTION_LEVEL_TYPE is table of ece_stage.transaction_level%TYPE index by binary_integer;
6: B_STAGE_ID STAGE_ID_TYPE;
7: B_TRANSACTION_LEVEL TRANSACTION_LEVEL_TYPE;
8: --bug 3133379

Line 5: TYPE TRANSACTION_LEVEL_TYPE is table of ece_stage.transaction_level%TYPE index by binary_integer;

1: PACKAGE BODY EC_OUTBOUND_STAGE AS
2: -- $Header: ECOSTGB.pls 120.2.12000000.2 2007/03/09 14:41:15 cpeixoto ship $
3: --bug 3133379
4: TYPE STAGE_ID_TYPE is table of ece_stage.stage_id%TYPE index by binary_integer;
5: TYPE TRANSACTION_LEVEL_TYPE is table of ece_stage.transaction_level%TYPE index by binary_integer;
6: B_STAGE_ID STAGE_ID_TYPE;
7: B_TRANSACTION_LEVEL TRANSACTION_LEVEL_TYPE;
8: --bug 3133379
9: --- Local PL/SQL table variables.

Line 131: ec_debug.pl(3,'EC','ECE_STAGE_START_RECORD_NUMBER','LEVEL',i_level,'START_RECORD_NUMBER',

127: i_level_info(i_level).Key_Column_Staging := NULL;
128: i_level_info(i_level).tp_code_staging := NULL;
129:
130: if ec_debug.G_debug_level = 3 then
131: ec_debug.pl(3,'EC','ECE_STAGE_START_RECORD_NUMBER','LEVEL',i_level,'START_RECORD_NUMBER',
132: i_level_info(i_level).start_record_number);
133: end if;
134: /**
135: Load the Mapping Information between Flat File and Staging Fields

Line 324: FROM ECE_STAGE

320: p_run_id IN number
321: )
322: IS
323: SELECT STAGE_ID,TRANSACTION_LEVEL
324: FROM ECE_STAGE
325: WHERE TRANSACTION_TYPE = p_transaction_type
326: AND RUN_ID = p_run_id
327: ORDER BY STAGE_ID; -- bug 3133379
328:

Line 330: --cFrom_stmt varchar2(1000) := ' FROM ECE_STAGE';

326: AND RUN_ID = p_run_id
327: ORDER BY STAGE_ID; -- bug 3133379
328:
329: --cSelect_stmt varchar2(1000) := 'SELECT STAGE_ID, TRANSACTION_LEVEL';
330: --cFrom_stmt varchar2(1000) := ' FROM ECE_STAGE';
331: --cWhere_stmt varchar2(1000) := ' WHERE TRANSACTION_TYPE = :a1 AND RUN_ID = :a2 order by stage_id'; --2457262
332: i_select_cursor INTEGER := 0;
333: dummy INTEGER;
334: error_position INTEGER;

Line 337: v_transaction_level ece_stage.transaction_level%TYPE;

333: dummy INTEGER;
334: error_position INTEGER;
335: v_parent_stage_id number;
336: v_stage_id number;
337: v_transaction_level ece_stage.transaction_level%TYPE;
338: i_new_stage_cursor number := 0;
339: BEGIN
340: if ec_debug.G_debug_level >= 2 then
341: ec_debug.push('EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');

Line 418: ec_debug.pl(3,'EC','ECE_STAGE_SELECTED',NULL);

414: **/
415: /** BEGIN
416: dummy := dbms_sql.execute(i_stage_cursor);
417: if ec_debug.G_debug_level = 3 then
418: ec_debug.pl(3,'EC','ECE_STAGE_SELECTED',NULL);
419: ec_debug.pl(3,'i_stage_cursor', i_stage_cursor);
420: ec_debug.pl(3,cSelect_stmt);
421: end if;
422:

Line 743: cFrom_stmt varchar2(100) := ' FROM ECE_STAGE';

739: i_common_key IN OUT NOCOPY VARCHAR2
740: )
741: is
742: cSelect_stmt varchar2(32000) := 'SELECT ';
743: cFrom_stmt varchar2(100) := ' FROM ECE_STAGE';
744: cWhere_stmt varchar2(100) := ' WHERE STAGE_ID = :a1';
745:
746: TYPE t_dummy IS TABLE OF varchar(2000) INDEX BY BINARY_INTEGER;
747: v_dummy t_dummy;

Line 817: ec_debug.pl(3,'EC','ECE_STAGE_SELECT_LEVEL','LEVEL',i_level,null);

813: EC_UTILS.i_ret_code :=2;
814: raise EC_UTILS.PROGRAM_EXIT;
815: END;
816: if ec_debug.G_debug_level = 3 then
817: ec_debug.pl(3,'EC','ECE_STAGE_SELECT_LEVEL','LEVEL',i_level,null);
818: end if;
819: end if;
820:
821: if i_select_cursor > 0

Line 848: ec_debug.pl(3,'EC','ECE_STAGE_SELECTED',NULL);

844: **/
845: BEGIN
846: dummy := dbms_sql.execute(i_select_cursor);
847: if ec_debug.G_debug_level = 3 then
848: ec_debug.pl(3,'EC','ECE_STAGE_SELECTED',NULL);
849: ec_debug.pl(3,'i_select_cursor', i_select_cursor);
850: end if;
851: EXCEPTION
852: WHEN OTHERS THEN