APPS.ZX_PTP_MIGRATE_PKG dependencies on FND_MODULE_INSTALLATIONS

Line 733: l_status fnd_module_installations.status%TYPE;

729:
730: PROCEDURE LEGAL_ESTABLISHMENT(p_org_id in NUMBER)
731: IS
732:
733: l_status fnd_module_installations.status%TYPE;
734: l_db_status fnd_module_installations.DB_STATUS%TYPE;
735:
736: BEGIN
737:

Line 734: l_db_status fnd_module_installations.DB_STATUS%TYPE;

730: PROCEDURE LEGAL_ESTABLISHMENT(p_org_id in NUMBER)
731: IS
732:
733: l_status fnd_module_installations.status%TYPE;
734: l_db_status fnd_module_installations.DB_STATUS%TYPE;
735:
736: BEGIN
737:
738: arp_util_tax.debug(' LEGAL_ESTABLISHMENT (+) ' );

Line 1041: FROM fnd_module_installations

1037:
1038: BEGIN
1039: SELECT STATUS, DB_STATUS
1040: INTO l_status, l_db_status
1041: FROM fnd_module_installations
1042: WHERE APPLICATION_ID = '7004'
1043: and MODULE_SHORT_NAME = 'jlbrloc';
1044: EXCEPTION
1045: WHEN NO_DATA_FOUND THEN

Line 1345: l_status fnd_module_installations.status%TYPE;

1341: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
1342: AND VENDOR_TYPE_LOOKUP_CODE is not null
1343: AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';*/
1344:
1345: l_status fnd_module_installations.status%TYPE;
1346: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1347:
1348:
1349: BEGIN

Line 1346: l_db_status fnd_module_installations.DB_STATUS%TYPE;

1342: AND VENDOR_TYPE_LOOKUP_CODE is not null
1343: AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';*/
1344:
1345: l_status fnd_module_installations.status%TYPE;
1346: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1347:
1348:
1349: BEGIN
1350:

Line 1511: FROM fnd_module_installations

1507: -- Bug # 3594759
1508: -- Verify Argentina Installation
1509: SELECT STATUS, DB_STATUS
1510: INTO l_status, l_db_status
1511: FROM fnd_module_installations
1512: WHERE APPLICATION_ID = '7004'
1513: And MODULE_SHORT_NAME = 'jlarloc';
1514:
1515: IF (nvl(l_status,'N') in ('I','S') or

Line 1644: l_status fnd_module_installations.status%TYPE;

1640:
1641:
1642: PROCEDURE SUPPLIER_SITE_EXTRACT(p_party_id in NUMBER, p_org_id in Number) IS
1643:
1644: l_status fnd_module_installations.status%TYPE;
1645: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1646:
1647:
1648: BEGIN

Line 1645: l_db_status fnd_module_installations.DB_STATUS%TYPE;

1641:
1642: PROCEDURE SUPPLIER_SITE_EXTRACT(p_party_id in NUMBER, p_org_id in Number) IS
1643:
1644: l_status fnd_module_installations.status%TYPE;
1645: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1646:
1647:
1648: BEGIN
1649:

Line 2012: FROM fnd_module_installations

2008: BEGIN
2009:
2010: SELECT STATUS, DB_STATUS
2011: INTO l_status, l_db_status
2012: FROM fnd_module_installations
2013: WHERE APPLICATION_ID = '7004'
2014: and MODULE_SHORT_NAME = 'jlbrloc';
2015:
2016: EXCEPTION

Line 3162: l_status fnd_module_installations.status%TYPE;

3158: +===========================================================================*/
3159:
3160:
3161: PROCEDURE SUPPLIER_TYPE_MIGRATION IS
3162: l_status fnd_module_installations.status%TYPE;
3163: l_db_status fnd_module_installations.DB_STATUS%TYPE;
3164:
3165: BEGIN
3166: -- Bug # 3594759

Line 3163: l_db_status fnd_module_installations.DB_STATUS%TYPE;

3159:
3160:
3161: PROCEDURE SUPPLIER_TYPE_MIGRATION IS
3162: l_status fnd_module_installations.status%TYPE;
3163: l_db_status fnd_module_installations.DB_STATUS%TYPE;
3164:
3165: BEGIN
3166: -- Bug # 3594759
3167: -- Verify Argentina Installation

Line 3170: FROM fnd_module_installations

3166: -- Bug # 3594759
3167: -- Verify Argentina Installation
3168: SELECT STATUS, DB_STATUS
3169: INTO l_status, l_db_status
3170: FROM fnd_module_installations
3171: WHERE APPLICATION_ID = '7004'
3172: And MODULE_SHORT_NAME = 'jlarloc';
3173:
3174: IF (nvl(l_status,'N') in ('I','S') or