DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_PVT dependencies on IBE_SHOP_LIST_HEADER_PKG

Line 685: IBE_Shop_List_Header_PKG.Delete_Row(

681: CLOSE C_GET_LIST_LINES;
682:
683: BEGIN
684: -- delete list header
685: IBE_Shop_List_Header_PKG.Delete_Row(
686: p_SHP_LIST_ID => p_shop_list_ids(i),
687: p_OBJECT_VERSION_NUMBER => p_obj_ver_numbers(i));
688: EXCEPTION
689: WHEN NO_DATA_FOUND THEN

Line 1200: IBE_Shop_List_Header_PKG.Insert_Row(

1196: --dbms_output.put_line('p_sl_header_rec.description = ' || p_sl_header_rec.description);
1197: --dbms_output.put_line('p_sl_header_rec.org_id = ' || p_sl_header_rec.org_id);
1198: --dbms_output.put_line('p_sl_header_rec.shp_list_id = ' || p_sl_header_rec.shp_list_id);
1199:
1200: IBE_Shop_List_Header_PKG.Insert_Row(
1201: x_shp_list_id => x_sl_header_id ,
1202: p_request_id => p_sl_header_rec.request_id ,
1203: p_program_application_id => p_sl_header_rec.program_application_id ,
1204: p_program_id => p_sl_header_rec.program_id ,

Line 1250: IBE_Shop_List_Header_PKG.Update_Row(

1246: ELSE
1247: -- Existing shopping list. Update the shopping list.
1248: --dbms_output.put_line('Update header');
1249: BEGIN
1250: IBE_Shop_List_Header_PKG.Update_Row(
1251: p_shp_list_id => p_sl_header_rec.shp_list_id ,
1252: p_request_id => p_sl_header_rec.request_id ,
1253: p_program_application_id => p_sl_header_rec.program_application_id ,
1254: p_program_id => p_sl_header_rec.program_id ,