APPS.AP_APXINUPD_XMLP_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 216: AP_SUPPLIER_SITES_ALL

212: SELECT
213: VENDOR_SITE_ID
214: INTO L_VENDOR_SITE_ID
215: FROM
216: AP_SUPPLIER_SITES_ALL
217: WHERE VENDOR_ID = C_VENDOR_ID
218: AND VENDOR_SITE_CODE = C_VENDOR_SITE_CODE
219: AND ORG_ID = C_ORG_ID;
220: RETURN (L_VENDOR_SITE_ID);

Line 639: AP_SUPPLIER_SITES_ALL

635: NVL(PRIMARY_PAY_SITE_FLAG
636: ,'N')
637: INTO L_MERGING_PPSITE
638: FROM
639: AP_SUPPLIER_SITES_ALL
640: WHERE VENDOR_ID = C_DUP_VENDOR_ID
641: AND VENDOR_SITE_ID = C_DUP_VENDOR_SITE_ID;
642: IF ((L_MERGING_PPSITE = 'Y') AND (C_VENDOR_ID = C_DUP_VENDOR_ID)) THEN
643: UPDATE

Line 644: AP_SUPPLIER_SITES_ALL

640: WHERE VENDOR_ID = C_DUP_VENDOR_ID
641: AND VENDOR_SITE_ID = C_DUP_VENDOR_SITE_ID;
642: IF ((L_MERGING_PPSITE = 'Y') AND (C_VENDOR_ID = C_DUP_VENDOR_ID)) THEN
643: UPDATE
644: AP_SUPPLIER_SITES_ALL
645: SET
646: PRIMARY_PAY_SITE_FLAG = 'Y'
647: WHERE VENDOR_ID = C_VENDOR_ID
648: AND VENDOR_SITE_ID = C_VENDOR_SITE_ID;

Line 786: AP_SUPPLIER_SITES_ALL VS

782: VS.VENDOR_SITE_CODE,
783: VS.PARTY_SITE_ID
784: FROM
785: AP_DUPLICATE_VENDORS_ALL DV,
786: AP_SUPPLIER_SITES_ALL VS
787: WHERE PROCESS_FLAG = 'S'
788: AND VS.VENDOR_SITE_ID = DV.DUPLICATE_VENDOR_SITE_ID
789: AND VS.ORG_ID = DV.ORG_ID) LOOP
790: SELECT

Line 794: AP_SUPPLIER_SITES_ALL

790: SELECT
791: COUNT(VENDOR_SITE_ID)
792: INTO L_NUMBER_OF_OTHER_SITES
793: FROM
794: AP_SUPPLIER_SITES_ALL
795: WHERE VENDOR_ID = C1.DUPLICATE_VENDOR_ID
796: AND VENDOR_SITE_ID <> C1.DUPLICATE_VENDOR_SITE_ID
797: AND NVL(INACTIVE_DATE
798: ,SYSDATE + 1) > sysdate;

Line 818: AP_SUPPLIER_SITES_ALL PVS

814: SELECT
815: COUNT(*)
816: INTO L_TARGET_PRIMARY_PAY_SITES
817: FROM
818: AP_SUPPLIER_SITES_ALL PVS
819: WHERE PVS.VENDOR_ID = C1.VENDOR_ID
820: AND PVS.ORG_ID = C1.ORG_ID
821: AND NVL(PRIMARY_PAY_SITE_FLAG
822: ,'N') = 'Y'

Line 829: AP_SUPPLIER_SITES_ALL PVS

825: SELECT
826: PVS.PRIMARY_PAY_SITE_FLAG
827: INTO L_DUP_PAY_SITE_FLAG
828: FROM
829: AP_SUPPLIER_SITES_ALL PVS
830: WHERE PVS.VENDOR_SITE_ID = C1.DUPLICATE_VENDOR_SITE_ID;
831: IF L_TARGET_PRIMARY_PAY_SITES > 0 AND L_DUP_PAY_SITE_FLAG = 'Y' THEN
832: L_DUP_PRIMARY_PAY_SITES := 'Y';
833: ELSE

Line 840: AP_SUPPLIER_SITES_ALL PVS

836: SELECT
837: COUNT(*)
838: INTO L_DESTINATION_VENDOR_TAX_SITES
839: FROM
840: AP_SUPPLIER_SITES_ALL PVS
841: WHERE PVS.VENDOR_ID = C1.VENDOR_ID
842: AND PVS.ORG_ID = C1.ORG_ID
843: AND NVL(TAX_REPORTING_SITE_FLAG
844: ,'N') = 'Y'

Line 851: AP_SUPPLIER_SITES_ALL PVS

847: SELECT
848: PVS.TAX_REPORTING_SITE_FLAG
849: INTO L_DUPLICATE_SITE_FLAG
850: FROM
851: AP_SUPPLIER_SITES_ALL PVS
852: WHERE PVS.VENDOR_SITE_ID = C1.DUPLICATE_VENDOR_SITE_ID;
853: IF L_DESTINATION_VENDOR_TAX_SITES > 0 AND L_DUPLICATE_SITE_FLAG = 'Y' THEN
854: L_DUPLICATE_TAX_SITES := 'Y';
855: ELSE

Line 1024: AP_SUPPLIER_SITES_ALL

1020: L_VENDOR_SITE_REC.ADDRESS_LINE3,L_VENDOR_SITE_REC.ADDRESS_LINE4,L_VENDOR_SITE_REC.ADDRESS_LINES_ALT,
1021: L_VENDOR_SITE_REC.COUNTY,L_VENDOR_SITE_REC.CITY,L_VENDOR_SITE_REC.STATE,L_VENDOR_SITE_REC.ZIP,
1022: L_VENDOR_SITE_REC.TOLERANCE_ID
1023: FROM
1024: AP_SUPPLIER_SITES_ALL
1025: WHERE VENDOR_ID = C1.DUPLICATE_VENDOR_ID
1026: AND VENDOR_SITE_ID = C1.DUPLICATE_VENDOR_SITE_ID
1027: AND NOT EXISTS (
1028: SELECT

Line 1031: AP_SUPPLIER_SITES_ALL

1027: AND NOT EXISTS (
1028: SELECT
1029: null
1030: FROM
1031: AP_SUPPLIER_SITES_ALL
1032: WHERE VENDOR_ID = C1.VENDOR_ID
1033: AND VENDOR_SITE_ID = C1.DUPLICATE_VENDOR_SITE_ID );
1034: AP_VENDOR_PUB_PKG.CREATE_VENDOR_SITE(P_API_VERSION => 1.0
1035: ,P_INIT_MSG_LIST => 'F'

Line 1064: AP_SUPPLIER_SITES_ALL

1060: SET
1061: ORG_PARTY_SITE_ID = L_PARTY_SITE_ID
1062: WHERE ORG_PARTY_SITE_ID = C1.PARTY_SITE_ID;
1063: UPDATE
1064: AP_SUPPLIER_SITES_ALL
1065: SET
1066: INACTIVE_DATE = SYSDATE
1067: ,LAST_UPDATED_BY = P_LAST_UPDATED_BY_T
1068: ,LAST_UPDATE_DATE = SYSDATE

Line 1094: AP_SUPPLIER_SITES_ALL

1090: SELECT
1091: VENDOR_SITE_ID
1092: INTO L_VENDOR_SITE_ID
1093: FROM
1094: AP_SUPPLIER_SITES_ALL
1095: WHERE VENDOR_ID = C_VENDOR_ID_PO
1096: AND VENDOR_SITE_CODE = C_VENDOR_SITE_CODE_PO
1097: AND ORG_ID = C_ORG_ID_PO;
1098: RETURN (L_VENDOR_SITE_ID);

Line 1221: AP_SUPPLIER_SITES_ALL

1217: NVL(PRIMARY_PAY_SITE_FLAG
1218: ,'N')
1219: INTO L_MERGING_PPSITE
1220: FROM
1221: AP_SUPPLIER_SITES_ALL
1222: WHERE VENDOR_ID = C_DUP_VENDOR_ID_PO
1223: AND VENDOR_SITE_ID = C_DUP_VENDOR_SITE_ID_PO;
1224: IF ((L_MERGING_PPSITE = 'Y') AND (C_VENDOR_ID_PO = C_DUP_VENDOR_ID_PO)) THEN
1225: UPDATE

Line 1226: AP_SUPPLIER_SITES_ALL

1222: WHERE VENDOR_ID = C_DUP_VENDOR_ID_PO
1223: AND VENDOR_SITE_ID = C_DUP_VENDOR_SITE_ID_PO;
1224: IF ((L_MERGING_PPSITE = 'Y') AND (C_VENDOR_ID_PO = C_DUP_VENDOR_ID_PO)) THEN
1225: UPDATE
1226: AP_SUPPLIER_SITES_ALL
1227: SET
1228: PRIMARY_PAY_SITE_FLAG = 'Y'
1229: WHERE VENDOR_ID = C_VENDOR_ID_PO
1230: AND VENDOR_SITE_ID = C_VENDOR_SITE_ID_PO;

Line 1331: AP_SUPPLIER_SITES_ALL

1327: TAX_REPORTING_SITE_FLAG,
1328: INACTIVE_DATE
1329: INTO L_DUP_TAX_FLAG,L_DUP_INACTIVE_DATE
1330: FROM
1331: AP_SUPPLIER_SITES_ALL
1332: WHERE VENDOR_ID = C1.DUPLICATE_VENDOR_ID
1333: AND VENDOR_SITE_ID = C1.DUPLICATE_VENDOR_SITE_ID;
1334: IF L_DUP_TAX_FLAG = 'Y' AND L_DUP_INACTIVE_DATE IS NULL THEN
1335: SELECT

Line 1339: AP_SUPPLIER_SITES_ALL

1335: SELECT
1336: count(*)
1337: INTO L_COUNT
1338: FROM
1339: AP_SUPPLIER_SITES_ALL
1340: WHERE TAX_REPORTING_SITE_FLAG = 'Y'
1341: AND VENDOR_ID = C1.VENDOR_ID
1342: AND ORG_ID = C1.ORG_ID
1343: AND INACTIVE_DATE is not null;

Line 1346: AP_SUPPLIER_SITES_ALL

1342: AND ORG_ID = C1.ORG_ID
1343: AND INACTIVE_DATE is not null;
1344: IF L_COUNT > 0 THEN
1345: UPDATE
1346: AP_SUPPLIER_SITES_ALL
1347: SET
1348: TAX_REPORTING_SITE_FLAG = 'N'
1349: WHERE VENDOR_ID = C1.VENDOR_ID
1350: AND ORG_ID = C1.ORG_ID