APPS.MSD_TEMPLATE_ATTRIBUTE_PKG dependencies on MSD_TEMPLATE_ATTRIBUTES

Line 47: from msd_template_attributes

43: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
44: begin
45: select LAST_UPDATED_BY, LAST_UPDATE_DATE
46: into db_luby, db_ludate
47: from msd_template_attributes
48: where TEMPLATE_ID = l_demand_plan_id
49: and ATTRIBUTE_TYPE = P_ATTRIBUTE_TYPE
50: and ATTRIBUTE_NAME = P_ATTRIBUTE_NAME;
51:

Line 56: update msd_template_attributes

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_template_attributes
57: set enabled_flag = p_enabled_flag
58: ,displayed_flag = p_displayed_flag
59: ,attribute_prompt = p_attribute_prompt
60: ,lov_name = p_lov_name

Line 74: insert into msd_template_attributes

70: end if;
71: exception
72: when no_data_found then
73: -- Record doesn't exist - insert in all cases
74: insert into msd_template_attributes
75: (TEMPLATE_ID
76: ,ATTRIBUTE_NAME
77: ,ATTRIBUTE_TYPE
78: ,ENABLED_FLAG