APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on DUAL

Line 5681: SELECT IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL FROM DUAL;

5677: l_lgl_phys_map_id NUMBER;
5678: l_language_code_tbl ibe_physicalMap_grp.LANGUAGE_CODE_TBL_TYPE;
5679:
5680: CURSOR lgl_phys_map_id_seq IS
5681: SELECT IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL FROM DUAL;
5682: BEGIN
5683:
5684: IF (p_item_id IS NULL)or (p_msite_id IS NULL) OR (p_attachment_id IS NULL)
5685: OR (p_language_code IS NULL ) or (p_default_site is null ) or (p_default_language is null) THEN

Line 6670: --- get the individual section item row association status

6666: x_return_status => x_return_status,
6667: x_msg_count => x_msg_count,
6668: x_msg_data => x_msg_data
6669: );
6670: --- get the individual section item row association status
6671: x_section_item_out_tbl(l_counter).x_return_status :=x_return_status;
6672: x_section_item_out_tbl(l_counter).section_item_id :=l_section_item_id_tbl(1);
6673: x_section_item_out_tbl(l_counter).inventory_item_id :=l_inventory_item_id_tbl(1);
6674: x_section_item_out_tbl(l_counter).organization_id :=l_organization_id_tbl(1);