APPS.IGI_CIS_UPGRADE_PKG dependencies on AP_SUPPLIERS

Line 43: AP_SUPPLIERS

39: SELECT
40: VENDOR_NAME,VENDOR_TYPE_LOOKUP_CODE
41: INTO TEMP_VENDOR_NAME,TEMP_VENDOR_TYPE
42: FROM
43: AP_SUPPLIERS
44: WHERE
45: VENDOR_ID = C_REC_INFO.VENDOR_ID;
46:
47: FND_MESSAGE.SET_NAME('IGI','IGI_CIS2007_UPG_VENDOR_DET');

Line 54: UPDATE AP_SUPPLIERS

50: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
51:
52: -- ===== UPDATING CIS ENABLED FLAG ====
53:
54: UPDATE AP_SUPPLIERS
55: SET CIS_ENABLED_FLAG = 'Y'
56: WHERE
57: VENDOR_ID = C_REC_INFO.VENDOR_ID;
58: IF SQL%FOUND THEN

Line 123: UPDATE AP_SUPPLIERS

119: AND ICCNN.NI_NUMBER IS NOT NULL
120: AND AATR.TAX_RATE_ID = ICCNN.TAX_RATE_ID (+);
121:
122: IF IGI_CIS_UPGRADE_PKG.IGI_CIS_VALIDATE_NI_NUMBER (TEMP_NI_NUMBER) THEN
123: UPDATE AP_SUPPLIERS
124: SET NATIONAL_INSURANCE_NUMBER = TEMP_NI_NUMBER
125: WHERE
126: VENDOR_ID = C_REC_INFO.VENDOR_ID;
127:

Line 150: UPDATE AP_SUPPLIERS

146: AND ICCNN.NI_NUMBER IS NOT NULL
147: AND AATR.TAX_RATE_ID = ICCNN.TAX_RATE_ID (+);
148:
149: IF IGI_CIS_UPGRADE_PKG.IGI_CIS_VALIDATE_NI_NUMBER (TEMP_NI_NUMBER) THEN
150: UPDATE AP_SUPPLIERS
151: SET NATIONAL_INSURANCE_NUMBER = TEMP_NI_NUMBER
152: WHERE
153: VENDOR_ID = C_REC_INFO.VENDOR_ID;
154:

Line 228: UPDATE AP_SUPPLIERS

224:
225: IF IGI_CIS_VALIDATE_UTR (TEMP_UTR_NO) THEN
226:
227: IF TEMP_VENDOR_TYPE = 'PARTNERSHIP' THEN
228: UPDATE AP_SUPPLIERS
229: SET PARTNERSHIP_UTR = TO_NUMBER (TEMP_UTR_NO)
230: WHERE VENDOR_ID = C_REC_INFO.VENDOR_ID;
231: ELSE
232: UPDATE AP_SUPPLIERS

Line 232: UPDATE AP_SUPPLIERS

228: UPDATE AP_SUPPLIERS
229: SET PARTNERSHIP_UTR = TO_NUMBER (TEMP_UTR_NO)
230: WHERE VENDOR_ID = C_REC_INFO.VENDOR_ID;
231: ELSE
232: UPDATE AP_SUPPLIERS
233: SET UNIQUE_TAX_REFERENCE_NUM = TO_NUMBER(TEMP_UTR_NO)
234: WHERE VENDOR_ID = C_REC_INFO.VENDOR_ID;
235: END IF;
236: IF SQL%FOUND THEN

Line 260: UPDATE AP_SUPPLIERS

256:
257: IF IGI_CIS_VALIDATE_UTR (TEMP_UTR_NO) THEN
258:
259: IF TEMP_VENDOR_TYPE = 'PARTNERSHIP' THEN
260: UPDATE AP_SUPPLIERS
261: SET PARTNERSHIP_UTR = TO_NUMBER (TEMP_UTR_NO)
262: WHERE VENDOR_ID = C_REC_INFO.VENDOR_ID;
263: ELSE
264: UPDATE AP_SUPPLIERS

Line 264: UPDATE AP_SUPPLIERS

260: UPDATE AP_SUPPLIERS
261: SET PARTNERSHIP_UTR = TO_NUMBER (TEMP_UTR_NO)
262: WHERE VENDOR_ID = C_REC_INFO.VENDOR_ID;
263: ELSE
264: UPDATE AP_SUPPLIERS
265: SET UNIQUE_TAX_REFERENCE_NUM = TO_NUMBER(TEMP_UTR_NO)
266: WHERE VENDOR_ID = C_REC_INFO.VENDOR_ID;
267: END IF;
268: IF SQL%FOUND THEN