APPS.IBE_SHOP_LIST_LINE_PKG dependencies on IBE_SHOP_LIST_LINE_PKG

Line 1: PACKAGE BODY IBE_Shop_List_Line_PKG AS

1: PACKAGE BODY IBE_Shop_List_Line_PKG AS
2: /* $Header: IBEVSLLB.pls 120.1 2005/08/28 21:50:58 appldev ship $ */
3:
4: -- Start of comments
5: -- Package name : IBE_Shop_List_Line_PKG

Line 5: -- Package name : IBE_Shop_List_Line_PKG

1: PACKAGE BODY IBE_Shop_List_Line_PKG AS
2: /* $Header: IBEVSLLB.pls 120.1 2005/08/28 21:50:58 appldev ship $ */
3:
4: -- Start of comments
5: -- Package name : IBE_Shop_List_Line_PKG
6: -- Function :
7: -- Parameters :
8: -- Version : Current version 1.0
9: -- Notes :

Line 58: IBE_Util.Debug('start IBE_Shop_List_LINE_PKG.Insert row');

54: IS
55: CURSOR C2 IS SELECT IBE_SH_SHP_LIST_ITEMS_S1.nextval FROM sys.dual;
56: BEGIN
57: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
58: IBE_Util.Debug('start IBE_Shop_List_LINE_PKG.Insert row');
59: END IF;
60: INSERT INTO ibe_shp_list_items_all(
61: shp_list_item_id,
62: request_id,

Line 142: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.Insert row');

138: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id))
139: RETURNING shp_list_item_id INTO x_shp_list_item_id;
140:
141: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
142: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.Insert row');
143: END IF;
144: END Insert_Row;
145:
146:

Line 190: IBE_Util.Debug('Start IBE_Shop_List_line_PKG.update_row');

186: )
187: IS
188: BEGIN
189: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
190: IBE_Util.Debug('Start IBE_Shop_List_line_PKG.update_row');
191: END IF;
192:
193: UPDATE ibe_shp_list_items_all
194: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),

Line 237: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.update_row');

233: IF (SQL%NOTFOUND) THEN
234: RAISE NO_DATA_FOUND;
235: END IF;
236: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
237: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.update_row');
238: END IF;
239: END Update_Row;
240:
241:

Line 249: IBE_Util.Debug('start IBE_Shop_List_line_PKG.delete row');

245: )
246: IS
247: BEGIN
248: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
249: IBE_Util.Debug('start IBE_Shop_List_line_PKG.delete row');
250: END IF;
251: DELETE
252: FROM ibe_shp_list_items_all
253: WHERE shp_list_item_id = p_shp_list_item_id

Line 260: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.delete row');

256: IF (SQL%NOTFOUND) THEN
257: RAISE NO_DATA_FOUND;
258: END IF;
259: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
260: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.delete row');
261: END IF;
262: END Delete_Row;
263:
264: END IBE_Shop_List_Line_PKG;

Line 264: END IBE_Shop_List_Line_PKG;

260: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.delete row');
261: END IF;
262: END Delete_Row;
263:
264: END IBE_Shop_List_Line_PKG;