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