APPS.PA_COPY_CHANGE_DOC_PVT dependencies on PA_CI_SUPPLIER_DETAILS

Line 80: select * from PA_CI_SUPPLIER_DETAILS

76: AND ci_action_id is null;
77:
78: CURSOR c_supp_dtls_from
79: is
80: select * from PA_CI_SUPPLIER_DETAILS
81: WHERE ci_id = p_ci_id;
82:
83: CURSOR c_budget_vers_from
84: is

Line 430: update PA_CI_SUPPLIER_DETAILS

426: update PA_CONTROL_ITEMS
427: set Current_Version_flag = 'N'
428: where ci_id = p_ci_id;
429:
430: update PA_CI_SUPPLIER_DETAILS
431: set current_audit_flag = 'N'
432: where ci_id = p_ci_id;
433:
434: -- Reset the error stack when returning to the calling program

Line 732: update PA_CI_SUPPLIER_DETAILS

728: update PA_CONTROL_ITEMS
729: set Current_Version_flag = 'N'
730: where ci_id = p_src_ci_id;
731:
732: update PA_CI_SUPPLIER_DETAILS
733: set current_audit_flag = 'N'
734: where ci_id = p_src_ci_id;
735:
736: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets policy to n

Line 748: update PA_CI_SUPPLIER_DETAILS sdp

744:
745: -- set the selected version for copy current flag to yes
746: PA_CHNGE_DOC_POLICY_PVT.SET_SUPP_AUDT; -- sets policy to n
747:
748: update PA_CI_SUPPLIER_DETAILS sdp
749: set current_audit_flag = 'Y'
750: where sdp.ci_id = p_ci_id
751: and sdp.audit_history_number = (select max(sdc.audit_history_number)
752: from PA_CI_SUPPLIER_DETAILS sdc

Line 752: from PA_CI_SUPPLIER_DETAILS sdc

748: update PA_CI_SUPPLIER_DETAILS sdp
749: set current_audit_flag = 'Y'
750: where sdp.ci_id = p_ci_id
751: and sdp.audit_history_number = (select max(sdc.audit_history_number)
752: from PA_CI_SUPPLIER_DETAILS sdc
753: where sdc.original_supp_trans_id = sdp.original_supp_trans_id
754: group by sdc.original_supp_trans_id);
755:
756: PA_CHNGE_DOC_POLICY_PVT.RESET_SUPP_AUDT; -- sets policy to y