APPS.ICX_REQ_CATEGORIES dependencies on DUAL

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

627: commit;
628: /* close semaphore */
629:
630: --changed by alex for attachment
631: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;
632: --new code:
633: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
634:
635: 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 633: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;

629:
630: --changed by alex for attachment
631: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;
632: --new code:
633: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
634:
635: 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,
636: unit_price,category_id,line_type_id,item_description,destination_organization_id,deliver_to_location_id,deliver_to_location,
637: suggested_buyer_id,suggested_vendor_name,suggested_vendor_site,

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

701: when INVALID_NUMBER or
702: VALUE_ERROR then
703: l_err_num := SQLCODE;
704: l_error_message := SQLERRM;
705: select substr(l_error_message,12,512) into l_err_mesg from dual;
706: icx_util.add_error(l_err_mesg);
707: icx_util.error_page_print;
708:
709: when OTHERS then

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

709: when OTHERS then
710: l_err_num := SQLCODE;
711: l_error_message := SQLERRM;
712:
713: select substr(l_error_message,12,512) into l_err_mesg from dual;
714: icx_util.add_error(l_err_mesg);
715: icx_util.error_page_print;
716:
717: end;