138: FUNCTION AFTERREPORT RETURN BOOLEAN IS
139: BEGIN
140: BEGIN
141: AP_VENDOR_PARTY_MERGE_PKG.OTHER_PRODUCTS_VENDORMERGE;
142: MO_GLOBAL.SET_POLICY_CONTEXT('M'
143: ,NULL);
144: UPDATE
145: AP_DUPLICATE_VENDORS
146: SET
205: BEGIN
206: DECLARE
207: L_VENDOR_SITE_ID NUMBER;
208: BEGIN
209: MO_GLOBAL.SET_POLICY_CONTEXT('S'
210: ,C_ORG_ID);
211: IF C_KEEP_SITE_FLAG = 'Y' THEN
212: SELECT
213: VENDOR_SITE_ID
1083: BEGIN
1084: DECLARE
1085: L_VENDOR_SITE_ID NUMBER;
1086: BEGIN
1087: MO_GLOBAL.SET_POLICY_CONTEXT('S'
1088: ,C_ORG_ID_PO);
1089: IF C_KEEP_SITE_FLAG_PO = 'Y' THEN
1090: SELECT
1091: VENDOR_SITE_ID
1359: BEGIN
1360: DECLARE
1361: L_OPERATING_UNIT VARCHAR2(4000);
1362: BEGIN
1363: L_OPERATING_UNIT := MO_GLOBAL.GET_OU_NAME(C_ORG_ID);
1364: RETURN (L_OPERATING_UNIT);
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: RETURN NULL;
1373: BEGIN
1374: DECLARE
1375: L_OPERATING_UNIT VARCHAR2(4000);
1376: BEGIN
1377: L_OPERATING_UNIT := MO_GLOBAL.GET_OU_NAME(C_ORG_ID_PO);
1378: RETURN (L_OPERATING_UNIT);
1379: EXCEPTION
1380: WHEN OTHERS THEN
1381: RETURN NULL;