DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_LINE_PKG dependencies on IBE_SH_SHP_LIST_ITEMS_S1

Line 55: CURSOR C2 IS SELECT IBE_SH_SHP_LIST_ITEMS_S1.nextval FROM sys.dual;

51: p_attribute15 IN VARCHAR2,
52: p_org_id IN NUMBER
53: )
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;

Line 101: ibe_sh_shp_list_items_s1.NEXTVAL,

97: attribute15,
98: org_id
99: )
100: VALUES(
101: ibe_sh_shp_list_items_s1.NEXTVAL,
102: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
103: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
104: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
105: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),