APPS.MSD_LEVELS_PKG dependencies on MSD_LEVELS

Line 1: package body MSD_LEVELS_PKG as

1: package body MSD_LEVELS_PKG as
2: /* $Header: msdlpkgb.pls 120.1 2006/01/18 01:18:57 amitku noship $ */
3:
4: PROCEDURE LOAD_ROW(
5: x_level_id in varchar2,

Line 57: from MSD_LEVELS

53:
54: begin
55: select LAST_UPDATED_BY, LAST_UPDATE_DATE
56: into db_luby, db_ludate
57: from MSD_LEVELS
58: where LEVEL_ID = to_number(x_level_id) and nvl(plan_type, -1) = nvl( to_char(x_plan_type),-1) ;
59:
60: -- Update record, honoring customization mode.
61: -- Record should be updated only if:

Line 69: update MSD_LEVELS set

65: if ((x_custom_mode = 'FORCE') or
66: ((f_luby = 0) and (db_luby = 1)) or
67: ((f_luby = db_luby) and (f_ludate > db_ludate)))
68: then
69: update MSD_LEVELS set
70: LEVEL_NAME = X_LEVEL_NAME,
71: DESCRIPTION = X_DESCRIPTION,
72: DIMENSION_CODE = X_DIMENSION_CODE,
73: LEVEL_TYPE_CODE = X_LEVEL_TYPE_CODE,

Line 106: update MSD_LEVELS set

102: nvl( PLAN_TYPE, -1) = nvl ( x_plan_type , -1) ;
103:
104: else
105:
106: update MSD_LEVELS set
107: ORG_RELATIONSHIP_VIEW = X_ORG_RELATIONSHIP_VIEW,
108: LAST_UPDATE_DATE = f_ludate,
109: LAST_UPDATED_BY = f_luby,
110: LAST_UPDATE_LOGIN = 0

Line 119: insert into MSD_LEVELS (

115:
116: exception
117: when no_data_found then
118: -- Record doesn't exist - insert in all cases
119: insert into MSD_LEVELS (
120: LEVEL_ID,
121: PLAN_TYPE,
122: LEVEL_NAME,
123: DESCRIPTION,

Line 229: from msd_levels

225: --
226: begin
227: select LAST_UPDATED_BY, LAST_UPDATE_DATE
228: into db_luby, db_ludate
229: from msd_levels
230: where level_id = to_number(x_level_id) and nvl( PLAN_TYPE, -1) = nvl( x_plan_type , -1) ;
231:
232: -- Update record, honoring customization mode.
233: -- Record should be updated only if:

Line 241: update msd_levels

237: if ((x_custom_mode = 'FORCE') or
238: ((f_luby = 0) and (db_luby = 1)) or
239: ((f_luby = db_luby) and (f_ludate > db_ludate)))
240: then
241: update msd_levels
242: set
243: level_name = nvl(x_level_name, level_name),
244: DESCRIPTION = nvl(x_description, DESCRIPTION),
245: LAST_UPDATE_DATE = f_ludate,

Line 259: end MSD_LEVELS_PKG;

255: when no_data_found then null;
256: end;
257: end TRANSLATE_ROW;
258:
259: end MSD_LEVELS_PKG;