DBA Data[Home] [Help]

APPS.DDR_SETUP_UTIL dependencies on DDR_R_ORG

Line 28: FROM DDR_R_ORG

24: v_org_exists NUMBER:=0;
25: BEGIN
26: SELECT COUNT(*)
27: INTO v_org_exists
28: FROM DDR_R_ORG
29: WHERE mfg_org_cd = p_mfg_org
30: AND org_cd = p_mfg_org;
31:
32: IF v_org_exists > 0 THEN

Line 36: INSERT INTO ddr_r_org

32: IF v_org_exists > 0 THEN
33: raise_error('The manufacture org exists');
34: END IF;
35:
36: INSERT INTO ddr_r_org
37: (mfg_org_cd, org_cd, org_typ, glbl_loc_id, glbl_loc_id_typ,
38: created_by, creation_date, last_updated_by, last_update_date, last_update_login, src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr)
39: VALUES
40: (p_mfg_org, p_mfg_org, 'MFG', -1, -1,