954: first_approver_id,
955: approval_path_id,
956: wf_item_type,
957: wf_item_key,
958: fnd_global.user_id,
959: SYSDATE,
960: fnd_global.login_id,
961: fnd_global.user_id,
962: SYSDATE
956: wf_item_type,
957: wf_item_key,
958: fnd_global.user_id,
959: SYSDATE,
960: fnd_global.login_id,
961: fnd_global.user_id,
962: SYSDATE
963: FROM po_approval_list_headers
964: WHERE document_id = p_existing_requisition_id
957: wf_item_key,
958: fnd_global.user_id,
959: SYSDATE,
960: fnd_global.login_id,
961: fnd_global.user_id,
962: SYSDATE
963: FROM po_approval_list_headers
964: WHERE document_id = p_existing_requisition_id
965: AND document_type = 'REQUISITION'
1005: approver_rec.approver_type,
1006: approver_rec.status,
1007: approver_rec.response_date,
1008: approver_rec.comments,
1009: fnd_global.user_id,
1010: SYSDATE,
1011: fnd_global.login_id,
1012: fnd_global.user_id,
1013: SYSDATE
1007: approver_rec.response_date,
1008: approver_rec.comments,
1009: fnd_global.user_id,
1010: SYSDATE,
1011: fnd_global.login_id,
1012: fnd_global.user_id,
1013: SYSDATE
1014: );
1015: END LOOP;
1008: approver_rec.comments,
1009: fnd_global.user_id,
1010: SYSDATE,
1011: fnd_global.login_id,
1012: fnd_global.user_id,
1013: SYSDATE
1014: );
1015: END LOOP;
1016: commit;