APPS.IBE_SHOPLIST_LINE_RELATION_PKG dependencies on IBE_UTIL

Line 33: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

29: p_relationship_type_code IN VARCHAR2
30: )
31: IS
32: BEGIN
33: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
34: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Insert row');
35: END IF;
36:
37: INSERT INTO ibe_sh_shlitem_rels

Line 34: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Insert row');

30: )
31: IS
32: BEGIN
33: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
34: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Insert row');
35: END IF;
36:
37: INSERT INTO ibe_sh_shlitem_rels
38: (

Line 72: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

68: p_related_shp_list_item_id,
69: p_relationship_type_code
70: )
71: RETURNING shlitem_rel_id INTO x_shlitem_rel_id;
72: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
73: IBE_Util.Debug('Exit IBE_ShopList_Line_relation_PKG.Insert row');
74: END IF;
75:
76: END Insert_Row;

Line 73: IBE_Util.Debug('Exit IBE_ShopList_Line_relation_PKG.Insert row');

69: p_relationship_type_code
70: )
71: RETURNING shlitem_rel_id INTO x_shlitem_rel_id;
72: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
73: IBE_Util.Debug('Exit IBE_ShopList_Line_relation_PKG.Insert row');
74: END IF;
75:
76: END Insert_Row;
77:

Line 98: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

94: p_relationship_type_code IN VARCHAR2
95: )
96: IS
97: BEGIN
98: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
99: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Update row');
100: END IF;
101:
102: UPDATE ibe_sh_shlitem_rels

Line 99: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Update row');

95: )
96: IS
97: BEGIN
98: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
99: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Update row');
100: END IF;
101:
102: UPDATE ibe_sh_shlitem_rels
103: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),

Line 121: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

117:
118: IF (SQL%NOTFOUND) THEN
119: RAISE NO_DATA_FOUND;
120: END IF;
121: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
122: IBE_Util.Debug('Exit IBE_ShopList_Line_relation_PKG.update row');
123: END IF;
124:
125: END Update_Row;

Line 122: IBE_Util.Debug('Exit IBE_ShopList_Line_relation_PKG.update row');

118: IF (SQL%NOTFOUND) THEN
119: RAISE NO_DATA_FOUND;
120: END IF;
121: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
122: IBE_Util.Debug('Exit IBE_ShopList_Line_relation_PKG.update row');
123: END IF;
124:
125: END Update_Row;
126:

Line 131: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

127:
128: PROCEDURE Delete_Row(p_shlitem_rel_id IN NUMBER)
129: IS
130: BEGIN
131: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
132: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Delete row');
133: END IF;
134:
135: DELETE

Line 132: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Delete row');

128: PROCEDURE Delete_Row(p_shlitem_rel_id IN NUMBER)
129: IS
130: BEGIN
131: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
132: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Delete row');
133: END IF;
134:
135: DELETE
136: FROM IBE_SH_SHLITEM_RELS

Line 142: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

138:
139: If (SQL%NOTFOUND) then
140: RAISE NO_DATA_FOUND;
141: End If;
142: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
143: IBE_Util.Debug('Exit IBE_ShopList_Line_relation_PKG.Delete row');
144: END IF;
145:
146: END Delete_Row;

Line 143: IBE_Util.Debug('Exit IBE_ShopList_Line_relation_PKG.Delete row');

139: If (SQL%NOTFOUND) then
140: RAISE NO_DATA_FOUND;
141: End If;
142: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
143: IBE_Util.Debug('Exit IBE_ShopList_Line_relation_PKG.Delete row');
144: END IF;
145:
146: END Delete_Row;
147: