DECLARE
cursor l_data IS
select poah.object_id
, po_header_id
, poah.object_type_code
, poah.object_sub_type_code
, poah.sequence_num
, poah.last_update_date
, poah.last_updated_by
, poah.creation_date
, poah.created_by
, poah.action_code
, poah.action_date
, poah.employee_id
, NVL((select new_person_id from XX.XX_PERSON_CREATE_TMP where person_id= poah.employee_id),1490) new_person_id
, poah.note
, poah.object_revision_num
, poah.last_update_login
, poah.request_id
, poah.program_application_id
, poah.program_id
, poah.program_update_date
, poah.approval_path_id from xxcustom_stage_table poah, po_headers_all poh
where poah.object_id=poh.GLOBAL_ATTRIBUTE1 ;
BEGIN
FOR n_data IN l_data LOOP
INSERT INTO PO_ACTION_HISTORY
( object_id
, object_type_code
, object_sub_type_code
, sequence_num
, last_update_date
, last_updated_by
, creation_date
, created_by
, action_code
, action_date
, employee_id
, note
, object_revision_num
, last_update_login
, request_id
, program_application_id
, program_id
, program_update_date
, approval_path_id
)
VALUES
( n_data.po_header_id
, n_data.object_type_code
, n_data.object_sub_type_code
, n_data.sequence_num
, n_data.last_update_date
, -1
, n_data.creation_date
, -1
, n_data.action_code
, n_data.action_date
, n_data.NEW_PERSON_ID
, n_data.note
, n_Data.OBJECT_REVISION_NUM
, -1
, 0
, 0
, 0
, ''
, NULL
);
END LOOP;
END;
No comments:
Post a Comment