APPS.ZX_PTP_MIGRATE_PKG dependencies on FND_MODULE_INSTALLATIONS

Line 722: l_status fnd_module_installations.status%TYPE;

718:
719: PROCEDURE LEGAL_ESTABLISHMENT(p_org_id in NUMBER)
720: IS
721:
722: l_status fnd_module_installations.status%TYPE;
723: l_db_status fnd_module_installations.DB_STATUS%TYPE;
724:
725: BEGIN
726:

Line 723: l_db_status fnd_module_installations.DB_STATUS%TYPE;

719: PROCEDURE LEGAL_ESTABLISHMENT(p_org_id in NUMBER)
720: IS
721:
722: l_status fnd_module_installations.status%TYPE;
723: l_db_status fnd_module_installations.DB_STATUS%TYPE;
724:
725: BEGIN
726:
727: arp_util_tax.debug(' LEGAL_ESTABLISHMENT (+) ' );

Line 921: FROM fnd_module_installations

917:
918: BEGIN
919: SELECT STATUS, DB_STATUS
920: INTO l_status, l_db_status
921: FROM fnd_module_installations
922: WHERE APPLICATION_ID = '7004'
923: and MODULE_SHORT_NAME = 'jlbrloc';
924: EXCEPTION
925: WHEN NO_DATA_FOUND THEN

Line 1225: l_status fnd_module_installations.status%TYPE;

1221: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
1222: AND VENDOR_TYPE_LOOKUP_CODE is not null
1223: AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';*/
1224:
1225: l_status fnd_module_installations.status%TYPE;
1226: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1227:
1228:
1229: BEGIN

Line 1226: l_db_status fnd_module_installations.DB_STATUS%TYPE;

1222: AND VENDOR_TYPE_LOOKUP_CODE is not null
1223: AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';*/
1224:
1225: l_status fnd_module_installations.status%TYPE;
1226: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1227:
1228:
1229: BEGIN
1230:

Line 1391: FROM fnd_module_installations

1387: -- Bug # 3594759
1388: -- Verify Argentina Installation
1389: SELECT STATUS, DB_STATUS
1390: INTO l_status, l_db_status
1391: FROM fnd_module_installations
1392: WHERE APPLICATION_ID = '7004'
1393: And MODULE_SHORT_NAME = 'jlarloc';
1394:
1395: IF (nvl(l_status,'N') in ('I','S') or

Line 1524: l_status fnd_module_installations.status%TYPE;

1520:
1521:
1522: PROCEDURE SUPPLIER_SITE_EXTRACT(p_party_id in NUMBER, p_org_id in Number) IS
1523:
1524: l_status fnd_module_installations.status%TYPE;
1525: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1526:
1527:
1528: BEGIN

Line 1525: l_db_status fnd_module_installations.DB_STATUS%TYPE;

1521:
1522: PROCEDURE SUPPLIER_SITE_EXTRACT(p_party_id in NUMBER, p_org_id in Number) IS
1523:
1524: l_status fnd_module_installations.status%TYPE;
1525: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1526:
1527:
1528: BEGIN
1529:

Line 1892: FROM fnd_module_installations

1888: BEGIN
1889:
1890: SELECT STATUS, DB_STATUS
1891: INTO l_status, l_db_status
1892: FROM fnd_module_installations
1893: WHERE APPLICATION_ID = '7004'
1894: and MODULE_SHORT_NAME = 'jlbrloc';
1895:
1896: EXCEPTION

Line 3042: l_status fnd_module_installations.status%TYPE;

3038: +===========================================================================*/
3039:
3040:
3041: PROCEDURE SUPPLIER_TYPE_MIGRATION IS
3042: l_status fnd_module_installations.status%TYPE;
3043: l_db_status fnd_module_installations.DB_STATUS%TYPE;
3044:
3045: BEGIN
3046: -- Bug # 3594759

Line 3043: l_db_status fnd_module_installations.DB_STATUS%TYPE;

3039:
3040:
3041: PROCEDURE SUPPLIER_TYPE_MIGRATION IS
3042: l_status fnd_module_installations.status%TYPE;
3043: l_db_status fnd_module_installations.DB_STATUS%TYPE;
3044:
3045: BEGIN
3046: -- Bug # 3594759
3047: -- Verify Argentina Installation

Line 3050: FROM fnd_module_installations

3046: -- Bug # 3594759
3047: -- Verify Argentina Installation
3048: SELECT STATUS, DB_STATUS
3049: INTO l_status, l_db_status
3050: FROM fnd_module_installations
3051: WHERE APPLICATION_ID = '7004'
3052: And MODULE_SHORT_NAME = 'jlarloc';
3053:
3054: IF (nvl(l_status,'N') in ('I','S') or