APPS.IBE_SHOPLIST_LINE_RELATION_PKG dependencies on IBE_SH_SHLITEM_RELS

Line 37: INSERT INTO ibe_sh_shlitem_rels

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: (
39: shlitem_rel_id ,
40: request_id ,
41: program_application_id ,

Line 56: ibe_sh_shlitem_rels_s1.NEXTVAL,

52: relationship_type_code
53: )
54: VALUES
55: (
56: ibe_sh_shlitem_rels_s1.NEXTVAL,
57: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
58: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
59: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
60: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),

Line 102: UPDATE ibe_sh_shlitem_rels

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),
104: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
105: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
106: program_update_date = DECODE(p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),

Line 136: FROM IBE_SH_SHLITEM_RELS

132: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Delete row');
133: END IF;
134:
135: DELETE
136: FROM IBE_SH_SHLITEM_RELS
137: WHERE SHLITEM_REL_ID = p_SHLITEM_REL_ID;
138:
139: If (SQL%NOTFOUND) then
140: RAISE NO_DATA_FOUND;