DBA Data[Home] [Help]

APPS.IGI_CIS_UPGRADE_PKG dependencies on IGI_CIS_UPGRADE_PKG

Line 1: PACKAGE BODY IGI_CIS_UPGRADE_PKG AS

1: PACKAGE BODY IGI_CIS_UPGRADE_PKG AS
2: -- $Header: igipupgb.pls 120.0.12000000.2 2007/07/24 10:07:55 vensubra noship $
3:
4: Procedure MIGRATE_DATA(p_errbuff OUT NOCOPY VARCHAR2,p_retcode OUT NOCOPY NUMBER)
5: is

Line 122: IF IGI_CIS_UPGRADE_PKG.IGI_CIS_VALIDATE_NI_NUMBER (TEMP_NI_NUMBER) THEN

118: AND TRUNC(NVL(AATR.END_DATE, SYSDATE))
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;

Line 149: IF IGI_CIS_UPGRADE_PKG.IGI_CIS_VALIDATE_NI_NUMBER (TEMP_NI_NUMBER) THEN

145: -- Bug 5620412
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;

Line 377: END IGI_CIS_UPGRADE_PKG;

373: FND_MESSAGE.SET_NAME('IGI',P_MSG_NAME);
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET);
375: END WRITE_REPORT;
376:
377: END IGI_CIS_UPGRADE_PKG;
378: