DBA Data[Home] [Help]

APPS.POR_AMENDMENT_PKG dependencies on PO_ACTION_HISTORY

Line 3643: FROM po_action_history

3639: END IF;
3640:
3641: SELECT Max(sequence_num)
3642: INTO max_seq
3643: FROM po_action_history
3644: WHERE object_id = (SELECT requisition_header_id
3645: FROM po_requisition_headers_all
3646: WHERE conformed_header_id = p_confirmed_id
3647: AND revision_num =p_revision_num)

Line 3657: INSERT INTO po_action_history(

3653: l_log_msg := v_progress||' At procedure merge_action_history: max_seq: '|| max_seq;
3654: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3655: END IF;
3656:
3657: INSERT INTO po_action_history(
3658: object_id,
3659: object_type_code,
3660: object_sub_type_code,
3661: sequence_num,

Line 3702: FROM po_action_history

3698: program_id,
3699: program_update_date,
3700: program_date,
3701: approval_group_id
3702: FROM po_action_history
3703: WHERE object_id = (SELECT requisition_header_id
3704: FROM po_requisition_headers_all
3705: WHERE conformed_header_id = p_confirmed_id
3706: AND revision_num =p_revision_num)