APPS.IBE_SHOP_LIST_HEADER_PKG dependencies on IBE_SHOP_LIST_HEADER_PKG

Line 1: PACKAGE BODY IBE_Shop_List_Header_PKG AS

1: PACKAGE BODY IBE_Shop_List_Header_PKG AS
2: /* $Header: IBEVSLHB.pls 120.1 2005/08/28 21:51:23 appldev ship $ */
3:
4: l_true VARCHAR2(1) := FND_API.G_TRUE;
5:

Line 42: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Insert row');

38: p_org_id IN NUMBER)
39: IS
40: BEGIN
41: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
42: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Insert row');
43: END IF;
44:
45: INSERT INTO ibe_sh_shp_lists_all(
46: shp_list_id,

Line 115: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.Insert row');

111: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id)
112: )
113: RETURNING shp_list_id INTO x_shp_list_id;
114: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
115: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.Insert row');
116: END IF;
117: END Insert_Row;
118:
119:

Line 156: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Update row');

152: p_org_id IN NUMBER)
153: IS
154: BEGIN
155: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
156: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Update row');
157: END IF;
158:
159: UPDATE ibe_sh_shp_lists_all
160: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),

Line 198: IBE_Util.Debug('exit IBE_Shop_List_Header_PKG.update row');

194: IF (SQL%NOTFOUND) THEN
195: RAISE NO_DATA_FOUND;
196: END IF;
197: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
198: IBE_Util.Debug('exit IBE_Shop_List_Header_PKG.update row');
199: END IF;
200: END Update_Row;
201:
202:

Line 209: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.delete row');

205: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
206: IS
207: BEGIN
208: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
209: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.delete row');
210: END IF;
211:
212: DELETE
213: FROM ibe_sh_shp_lists_all

Line 221: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.delete row');

217: IF (SQL%NOTFOUND) THEN
218: RAISE NO_DATA_FOUND;
219: END IF;
220: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
221: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.delete row');
222: END IF;
223: END Delete_Row;
224:
225: END IBE_Shop_List_Header_PKG;

Line 225: END IBE_Shop_List_Header_PKG;

221: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.delete row');
222: END IF;
223: END Delete_Row;
224:
225: END IBE_Shop_List_Header_PKG;