APPS.ICX_REQ_SEARCH dependencies on DUAL

Line 907: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;

903:
904: commit;
905: /* release semaphore */
906: --changed by alex for attachment
907: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;
908: --new code:
909: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
910:
911: insert into icx_shopping_cart_lines(cart_line_id,cart_id,cart_line_number,creation_date,created_by,quantity,line_id,item_id,item_revision,unit_of_measure,

Line 909: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;

905: /* release semaphore */
906: --changed by alex for attachment
907: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;
908: --new code:
909: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
910:
911: insert into icx_shopping_cart_lines(cart_line_id,cart_id,cart_line_number,creation_date,created_by,quantity,line_id,item_id,item_revision,unit_of_measure,
912: unit_price,category_id,line_type_id,item_description,destination_organization_id,deliver_to_location_id,deliver_to_location,
913: suggested_buyer_id,suggested_vendor_name,suggested_vendor_site,

Line 977: select substr(l_error_message,12,512) into l_err_mesg from dual;

973: when others then
974: l_err_num := SQLCODE;
975: l_error_message := SQLERRM;
976:
977: select substr(l_error_message,12,512) into l_err_mesg from dual;
978: icx_util.add_error(l_err_mesg);
979: icx_util.error_page_print;
980:
981: