APPS.MSD_DP_SEEDED_DOCUMENT_PKG dependencies on MSD_DP_SEEDED_DOCUMENTS

Line 48: from msd_dp_seeded_documents

44: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
45: begin
46: select LAST_UPDATED_BY, LAST_UPDATE_DATE
47: into db_luby, db_ludate
48: from msd_dp_seeded_documents
49: where DEMAND_PLAN_ID = l_demand_plan_id
50: and DOCUMENT_NAME = P_DOCUMENT_NAME;
51:
52: -- Test for customization and version

Line 56: update msd_dp_seeded_documents

52: -- Test for customization and version
53: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
54: db_ludate, P_CUSTOM_MODE)) then
55: -- Update existing row
56: update msd_dp_seeded_documents
57: set description = p_description
58: ,type = p_type
59: ,open_on_startup = p_open_on_startup
60: ,script_cleanup = p_script_cleanup

Line 76: insert into msd_dp_seeded_documents

72: end if;
73: exception
74: when no_data_found then
75: -- Record doesn't exist - insert in all cases
76: insert into msd_dp_seeded_documents
77: (DEMAND_PLAN_ID
78: ,DOCUMENT_ID
79: ,DOCUMENT_NAME
80: ,DESCRIPTION