APPS.MSD_DP_DOC_DIM_SELECTION_PKG dependencies on MSD_DP_DOC_DIM_SELECTIONS

Line 54: from msd_dp_doc_dim_selections

50: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
51: begin
52: select LAST_UPDATED_BY, LAST_UPDATE_DATE
53: into db_luby, db_ludate
54: from msd_dp_doc_dim_selections
55: where DEMAND_PLAN_ID = l_demand_plan_id
56: and DOCUMENT_ID = l_document_id
57: and DIMENSION_CODE = P_DIMENSION_CODE
58: and SELECTION_SEQUENCE = P_SELECTION_SEQUENCE;

Line 64: update msd_dp_doc_dim_selections

60: -- Test for customization and version
61: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
62: db_ludate, P_CUSTOM_MODE)) then
63: -- Update existing row
64: update msd_dp_doc_dim_selections
65: set enabled_flag = p_enabled_flag
66: ,mandatory_flag = p_mandatory_flag
67: ,selection_type = p_selection_type
68: ,selection_component = p_selection_component

Line 84: insert into msd_dp_doc_dim_selections

80: end if;
81: exception
82: when no_data_found then
83: -- Record doesn't exist - insert in all cases
84: insert into msd_dp_doc_dim_selections
85: (DEMAND_PLAN_ID
86: ,DOCUMENT_ID
87: ,DIMENSION_CODE
88: ,SELECTION_SEQUENCE