APPS.ICX_REQ_COPY_REQ dependencies on DUAL

Line 453: select substr(l_message,12,512) into l_err_mesg from dual;

449: -- icx_util.error_page_print;
450:
451: l_err_num := SQLCODE;
452: l_message := SQLERRM;
453: select substr(l_message,12,512) into l_err_mesg from dual;
454: if (abs(l_err_num) between 1800 and 1899)
455: then
456: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
457: l_web_user_date_format := icx_sec.getID(icx_sec.pv_date_format);

Line 501: FROM SYS.DUAL;

497: --
498:
499: CURSOR getDate(increment NUMBER) IS
500: SELECT SYSDATE + increment
501: FROM SYS.DUAL;
502:
503: cursor reqlines(reqheader number) IS
504: SELECT requisition_line_id
505: FROM po_requisition_lines

Line 565: -- FROM SYS.DUAL;

561:
562: --changed by alex for attachment
563: -- SELECT icx_shopping_carts_s.NEXTVAL
564: -- INTO v_cart_id
565: -- FROM SYS.DUAL;
566: --new code:
567: SELECT PO_REQUISITION_HEADERS_S.NEXTVAL
568: INTO v_cart_id
569: FROM SYS.DUAL;

Line 569: FROM SYS.DUAL;

565: -- FROM SYS.DUAL;
566: --new code:
567: SELECT PO_REQUISITION_HEADERS_S.NEXTVAL
568: INTO v_cart_id
569: FROM SYS.DUAL;
570:
571: -- The reserve_po_num column is now updated to NULL from the earlier
572: -- value of attribute7.
573: INSERT INTO icx_shopping_carts (

Line 678: FROM SYS.DUAL;

674:
675: -- Create cart distributions
676: SELECT icx_cart_distributions_s.nextval
677: INTO v_distribution_id
678: FROM SYS.DUAL;
679:
680: INSERT INTO icx_cart_distributions (
681: cart_id,
682: distribution_id,

Line 709: -- FROM DUAL;

705:
706: --changed by alex for attachment
707: -- SELECT icx_shopping_cart_lines_s.NEXTVAL
708: -- INTO v_cart_line_id
709: -- FROM DUAL;
710: --new code:
711: SELECT PO_REQUISITION_LINES_S.NEXTVAL
712: INTO v_cart_line_id
713: FROM DUAL;

Line 713: FROM DUAL;

709: -- FROM DUAL;
710: --new code:
711: SELECT PO_REQUISITION_LINES_S.NEXTVAL
712: INTO v_cart_line_id
713: FROM DUAL;
714:
715:
716: INSERT INTO icx_shopping_cart_lines (
717: cart_line_id,

Line 886: -- Update the invidual segments from the account id.

882: WHERE cart_id = v_cart_id
883: AND cart_line_id = v_cart_line_id
884: AND distribution_id = distribution.distribution_id;
885:
886: -- Update the invidual segments from the account id.
887: -- This need to done because the invidual segments are not
888: -- available from po_req_distributions table.
889: icx_req_acct2.update_account_by_id( v_cart_id => v_cart_id,
890: v_cart_line_id => v_cart_line_id,

Line 887: -- This need to done because the invidual segments are not

883: AND cart_line_id = v_cart_line_id
884: AND distribution_id = distribution.distribution_id;
885:
886: -- Update the invidual segments from the account id.
887: -- This need to done because the invidual segments are not
888: -- available from po_req_distributions table.
889: icx_req_acct2.update_account_by_id( v_cart_id => v_cart_id,
890: v_cart_line_id => v_cart_line_id,
891: v_oo_id => v_org_id,