DBA Data[Home] [Help]

APPS.PA_COPY_CHANGE_DOC_PVT dependencies on PA_CHNGE_DOC_POLICY_PVT

Line 736: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets policy to n

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
737:
738: -- set the selected version for copy current flag to yes
739: update PA_CONTROL_ITEMS
740: set Current_Version_flag = 'Y'

Line 743: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets policy to y

739: update PA_CONTROL_ITEMS
740: set Current_Version_flag = 'Y'
741: where ci_id = p_ci_id;
742:
743: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets policy to y
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:

Line 746: PA_CHNGE_DOC_POLICY_PVT.SET_SUPP_AUDT; -- sets policy to n

742:
743: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets policy to y
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

Line 756: PA_CHNGE_DOC_POLICY_PVT.RESET_SUPP_AUDT; -- sets policy to y

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
757:
758: open c_from_item;
759: fetch c_from_item into l_ci_number,l_version_comments;
760: close c_from_item;

Line 785: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets policy to n

781: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
782: RAISE G_EXCEPTION_ERROR;
783: END IF;
784:
785: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets policy to n
786: -- sets the current ci id whic got versioned above source ci id
787: update PA_CONTROL_ITEMS
788: set source_ci_id = x_ci_id
789: where ci_id = p_src_ci_id;

Line 791: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets policy to y

787: update PA_CONTROL_ITEMS
788: set source_ci_id = x_ci_id
789: where ci_id = p_src_ci_id;
790:
791: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets policy to y
792: /*
793: IF (p_commit = FND_API.g_true and x_return_status = 'S') THEN
794: commit;
795: END IF;

Line 869: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets to N end;

865: ,p_msg_name => 'PA_CI_ID_IS_NULL');
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: END IF;
868:
869: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets to N end;
870:
871: update PA_CONTROL_ITEMS
872: set version_comments = p_version_comments
873: where ci_id = p_ci_id;

Line 875: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets to Y

871: update PA_CONTROL_ITEMS
872: set version_comments = p_version_comments
873: where ci_id = p_ci_id;
874:
875: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets to Y
876:
877: IF (p_commit = FND_API.g_true and x_return_status = 'S') THEN
878: commit;
879: END IF;