803:
804: -- get all the values required to insert into po_requisition_header table
805: SELECT Sysdate INTO l_today FROM dual;
806:
807: l_user_id := fnd_global.user_id;
808: l_login_id := fnd_global.login_id;
809:
810:
811: -- Get Requisition_header_id
804: -- get all the values required to insert into po_requisition_header table
805: SELECT Sysdate INTO l_today FROM dual;
806:
807: l_user_id := fnd_global.user_id;
808: l_login_id := fnd_global.login_id;
809:
810:
811: -- Get Requisition_header_id
812: OPEN req_header_id_cur;