APPS.DDR_REF_UTIL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

    select err_name into l_err_msg from ddr_l_err where err_cd = p_err_no;

Line: 24

 select param_val into p_loading_mode from ddr_l_sys_param where param_cd = 'RUN_TYP_REF';

Line: 56

	SELECT 1
	FROM   DDR_R_MFG_ITEM_CMPNY
	WHERE  MFG_CMPNY_CD = p_hchy_cd;

Line: 61

	SELECT 1
	FROM   DDR_R_MFG_ITEM_DIV
	WHERE  MFG_DIV_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 67

	SELECT 1
	FROM   DDR_R_MFG_ITEM_GRP
	WHERE  MFG_GRP_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 73

	SELECT 1
	FROM   DDR_R_MFG_ITEM_CLASS
	WHERE  MFG_CLASS_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 79

	SELECT 1
	FROM   DDR_R_MFG_ITEM_SBC
	WHERE  MFG_SBC_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 85

	SELECT 1
	FROM   DDR_R_MFG_ITEM
	WHERE  MFG_ITEM_NBR = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 91

	SELECT 1
	FROM  DDR_R_MFG_SKU_ITEM
	WHERE MFG_SKU_ITEM_NBR = p_hchy_cd
	AND   EFF_TO_DT IS NULL;

Line: 172

        SELECT 1
        FROM  DDR_R_ORG
        WHERE ORG_CD = p_org_cd;

Line: 177

        SELECT 1
        FROM   DDR_R_ORG_CHAIN
        WHERE  CHAIN_CD = p_hchy_cd
        AND    ORG_CD = p_org_cd
        AND    EFF_TO_DT IS NULL;

Line: 184

        SELECT 1
        FROM   DDR_R_ORG_AREA
        WHERE  AREA_CD = p_hchy_cd
        AND    ORG_CD = p_org_cd
        AND    EFF_TO_DT IS NULL;

Line: 191

        SELECT 1
        FROM   DDR_R_ORG_RGN
        WHERE  RGN_CD = p_hchy_cd
        AND    ORG_CD = p_org_cd
        AND    EFF_TO_DT IS NULL;

Line: 198

        SELECT 1
        FROM   DDR_R_ORG_DSTRCT
        WHERE  DSTRCT_CD = p_hchy_cd
        AND    ORG_CD = p_org_cd
        AND    EFF_TO_DT IS NULL;

Line: 205

        SELECT 1
        FROM   DDR_R_ORG_BSNS_UNIT
        WHERE  BSNS_UNIT_CD = p_hchy_cd
        AND    ORG_CD = p_org_cd
        AND    EFF_TO_DT IS NULL;

Line: 285

	SELECT 1
	FROM   DDR_R_RTL_ITEM_CMPNY
	WHERE  RTL_CMPNY_CD = p_hchy_cd;

Line: 290

	SELECT 1
	FROM   DDR_R_RTL_ITEM_DIV
	WHERE  RTL_DIV_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 296

	SELECT 1
	FROM   DDR_R_RTL_ITEM_GRP
	WHERE  RTL_GRP_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 302

 	SELECT 1
	FROM   DDR_R_RTL_ITEM_DEPT
	WHERE  RTL_DEPT_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 308

	SELECT 1
	FROM   DDR_R_RTL_ITEM_CLASS
	WHERE  RTL_CLASS_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 314

	SELECT 1
	FROM   DDR_R_RTL_ITEM_SBC
	WHERE  RTL_SBC_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 320

	SELECT 1
	FROM   DDR_R_RTL_ITEM
	WHERE  RTL_ITEM_NBR = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 326

	SELECT 1
	FROM  DDR_R_RTL_SKU_ITEM
	WHERE RTL_SKU_ITEM_NBR = p_hchy_cd
	AND   EFF_TO_DT IS NULL;

Line: 409

	SELECT 1
	FROM   DDR_R_BSNS_YR
	WHERE  YR_CD = p_hchy_cd;

Line: 414

	SELECT 1
	FROM   DDR_R_BSNS_QTR
	WHERE  QTR_CD = p_hchy_cd;

Line: 419

	SELECT 1
	FROM   DDR_R_BSNS_MNTH
	WHERE  MNTH_CD = p_hchy_cd;

Line: 424

 	SELECT 1
	FROM   DDR_R_BSNS_WK
	WHERE  WK_CD = p_hchy_cd;

Line: 429

	SELECT 1
	FROM   DDR_R_DAY
	WHERE  DAY_CD = p_hchy_cd;

Line: 497

    select DDR_LOAD_SEQ.NEXTVAL
    into c_map_id
    from dual;

Line: 526

    SELECT ORG_HCHY_ID, HRCHY_CD, CHILD_ID BSNS_ENT_ID, LEVEL, CHILD_CD BSNS_ENT_CD,
           SRC_SYS_DT, SRC_SYS_IDNT, EFF_FROM_DT, EFF_TO_DT
    FROM
    (
      SELECT ORG_HCHY_ID, HRCHY_CD, PARENT_ID, PARENT_CD, CHILD_ID, CHILD_CD,
             SRC_SYS_DT, SRC_SYS_IDNT, EFF_FROM_DT, EFF_TO_DT
      FROM
      (
        SELECT t1.ORG_HCHY_ID ORG_HCHY_ID, t1.HRCHY_CD HRCHY_CD,
               t1.ORG_BSNS_ENT_ID PARENT_ID, t1.BSNS_ENT_CD PARENT_CD,
               t2.ORG_BSNS_ENT_ID CHILD_ID, t2.BSNS_ENT_CD CHILD_CD,
               t2.SRC_SYS_DT SRC_SYS_DT, t2.SRC_SYS_IDNT SRC_SYS_IDNT,
               t1.EFF_FROM_DT EFF_FROM_DT, t1.EFF_TO_DT, t2.EFF_FROM_DT FROM_DT_2, t2.EFF_TO_DT TO_DT_2
        FROM DDR_R_ORG_BSNS_ENT t1 INNER JOIN DDR_R_ORG_BSNS_ENT t2
        ON (t1.BSNS_ENT_CD = t2.BSNS_ENT_PRNT_CD  AND t1.ORG_HCHY_ID =
t2.ORG_HCHY_ID)
      )
      WHERE NOT ((TO_DT_2 is not null AND TO_DT_2 < EFF_FROM_DT) OR (EFF_TO_DT is not null AND FROM_DT_2 > EFF_TO_DT))
      UNION
      (
        SELECT
          ORG_HCHY_ID, HRCHY_CD,
          CASE WHEN BSNS_ENT_PRNT_CD is null THEN null
          ELSE ORG_BSNS_ENT_ID
          END PARENT_ID,
          BSNS_ENT_PRNT_CD PARENT_CD,
          ORG_BSNS_ENT_ID CHILD_ID,
          BSNS_ENT_CD CHILD_CD,
          SRC_SYS_DT, SRC_SYS_IDNT,
          EFF_FROM_DT, EFF_TO_DT
        FROM DDR_R_ORG_BSNS_ENT
        WHERE BSNS_ENT_PRNT_CD is null
      )
    )
    START WITH PARENT_CD is null
    CONNECT BY PARENT_ID = PRIOR CHILD_ID;

Line: 573

    v_sql_hdr1  VARCHAR2(250) := 'INSERT INTO DDR_R_AOH_LVL_DTL (ORG_HCHY_ID,HRCHY_CD, BSNS_ENT_ID,BSNS_ENT_CD,BSNS_ENT_LEVEL,PRNT1_BSNS_ENT_CD,PRNT1_BSNS_ENT_ID,PRNT2_BSNS_ENT_CD, PRNT2_BSNS_ENT_ID,PRNT3_BSNS_ENT_CD,PRNT3_BSNS_ENT_ID,';

Line: 575

    v_sql_hdr3 VARCHAR2(250) := 'SRC_SYS_IDNT,SRC_SYS_DT,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,CRTD_BY_DSR, LAST_UPDT_BY_DSR,LAST_UPDATE_LOGIN) VALUES(';