[Home] [Help]
11: --
12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
13: --
14: BEGIN
15: p_user_id := NVL(FND_GLOBAL.USER_ID, -1);
16:
17: END Utilities;
18:
19:
105: --ER 12363706, WHO Columns added
106: UPDATE OE_HOLD_SOURCES
107: SET HOLD_COMMENT = p_hold_source_rec.HOLD_COMMENT,
108: LAST_UPDATE_DATE = SYSDATE,
109: LAST_UPDATED_BY = FND_GLOBAL.user_id
110: WHERE HOLD_SOURCE_ID = p_hold_source_rec.HOLD_SOURCE_ID;
111:
112: elsif (p_hold_source_rec.HOLD_ENTITY_CODE is NOT NULL AND
113: p_hold_source_rec.HOLD_ENTITY_ID is NOT NULL) THEN
117: --ER 12363706, WHO Columns added
118: UPDATE OE_HOLD_SOURCES
119: SET HOLD_COMMENT = p_hold_source_rec.HOLD_COMMENT,
120: LAST_UPDATE_DATE = SYSDATE,
121: LAST_UPDATED_BY = FND_GLOBAL.user_id
122: WHERE HOLD_ENTITY_CODE = p_hold_source_rec.HOLD_ENTITY_CODE
123: AND HOLD_ENTITY_ID = p_hold_source_rec.HOLD_ENTITY_ID
124: AND HOLD_ENTITY_CODE2 = p_hold_source_rec.HOLD_ENTITY_CODE2
125: AND HOLD_ENTITY_ID2 = p_hold_source_rec.HOLD_ENTITY_ID2
133: --ER 12363706, WHO Columns added
134: UPDATE OE_HOLD_SOURCES HS
135: SET HS.HOLD_COMMENT = p_hold_source_rec.HOLD_COMMENT,
136: HS.LAST_UPDATE_DATE = SYSDATE,
137: HS.LAST_UPDATED_BY = FND_GLOBAL.user_id
138:
139: WHERE HS.HOLD_ENTITY_CODE = p_hold_source_rec.HOLD_ENTITY_CODE
140: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.HOLD_ENTITY_ID
141: AND HS.HOLD_ENTITY_CODE2 is null
151: --ER 12363706, WHO Columns added
152: UPDATE OE_HOLD_SOURCES
153: SET HOLD_COMMENT = p_hold_source_rec.HOLD_COMMENT,
154: LAST_UPDATE_DATE = SYSDATE,
155: LAST_UPDATED_BY = FND_GLOBAL.user_id
156: WHERE HOLD_ENTITY_CODE = p_hold_source_rec.HOLD_ENTITY_CODE
157: AND HOLD_ENTITY_ID = p_hold_source_rec.HOLD_ENTITY_ID
158: AND HOLD_ENTITY_CODE2 is null
159: AND HOLD_ENTITY_ID2 is null