APPS.MSD_DP_EXPRESS_SETUP_PKG dependencies on MSD_DP_EXPRESS_SETUP

Line 1: PACKAGE BODY msd_dp_express_setup_pkg AS

1: PACKAGE BODY msd_dp_express_setup_pkg AS
2: /* $Header: msddpxsb.pls 120.0 2005/05/25 18:09:58 appldev noship $ */
3:
4: /* Public Procedures */
5:

Line 41: from msd_dp_express_setup

37: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
38: begin
39: select LAST_UPDATED_BY, LAST_UPDATE_DATE
40: into db_luby, db_ludate
41: from msd_dp_express_setup
42: where DEMAND_PLAN_ID = l_demand_plan_id;
43:
44: -- Test for customization and version
45: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 48: update msd_dp_express_setup

44: -- Test for customization and version
45: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
46: db_ludate, P_CUSTOM_MODE)) then
47: -- Update existing row
48: update msd_dp_express_setup
49: set ORGANIZATION_ID = P_ORGANIZATION_ID,
50: SHARED_DB_PREFIX = P_SHARED_DB_PREFIX,
51: last_update_date = f_ludate ,
52: last_updated_by = f_luby ,

Line 60: insert into msd_dp_express_setup

56: end if;
57: exception
58: when no_data_found then
59: -- Record doesn't exist - insert in all cases
60: insert into msd_dp_express_setup
61: (DEMAND_PLAN_ID
62: ,ORGANIZATION_ID
63: ,SHARED_DB_PREFIX ,
64: CREATION_DATE ,

Line 84: END msd_dp_express_setup_pkg ;

80: end;
81:
82: END;
83:
84: END msd_dp_express_setup_pkg ;