APPS.ISC_EDW_BACKLOGS_F_P dependencies on ISC_EDW_BACKLOGS_F

Line 1: PACKAGE BODY ISC_EDW_BACKLOGS_F_P AS

1: PACKAGE BODY ISC_EDW_BACKLOGS_F_P AS
2: /* $Header: ISCF01PB.pls 115.5 2004/02/26 00:18:48 scheung ship $*/
3:
4: g_dummy VARCHAR2(30);
5: g_dummy_int NUMBER;

Line 14: FROM ISC_EDW_BACKLOGS_F backlog,

10:
11: CURSOR snap_c IS
12: SELECT backlog.backlogs_pk c_pk,
13: nvl(time.cday_calendar_date,sysdate+1) c_date
14: FROM ISC_EDW_BACKLOGS_F backlog,
15: EDW_TIME_M time
16: WHERE backlog.date_balance_fk_key = time.cday_cal_day_pk_key
17: ORDER BY 2 DESC ;
18:

Line 28: 'INSERT INTO ISC_EDW_BACKLOGS_FSTG (

24: PROCEDURE INSERT_FSTG( PK IN VARCHAR2) IS
25: BEGIN
26: cid := DBMS_SQL.Open_Cursor;
27: DBMS_SQL.Parse( cid,
28: 'INSERT INTO ISC_EDW_BACKLOGS_FSTG (
29: BASE_UOM_FK,
30: BILL_TO_LOCATION_FK,
31: BILL_TO_CUST_FK,
32: CUSTOMER_FK,

Line 181: END ISC_EDW_BACKLOGS_F_P;

177:
178: END DELETE_FACT;
179:
180:
181: END ISC_EDW_BACKLOGS_F_P;