APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on FND_MODULE_INSTALLATIONS

Line 105: l_status fnd_module_installations.status%TYPE;

101: | |
102: |=========================================================================*/
103:
104: PROCEDURE CREATE_ZX_REPORTING_ASSOC(p_tax_id IN NUMBER) IS
105: l_status fnd_module_installations.status%TYPE;
106: l_db_status fnd_module_installations.DB_STATUS%TYPE;
107:
108: l_reporting_type_id apps.zx_reporting_types_b.reporting_type_id%TYPE ;
109:

Line 106: l_db_status fnd_module_installations.DB_STATUS%TYPE;

102: |=========================================================================*/
103:
104: PROCEDURE CREATE_ZX_REPORTING_ASSOC(p_tax_id IN NUMBER) IS
105: l_status fnd_module_installations.status%TYPE;
106: l_db_status fnd_module_installations.DB_STATUS%TYPE;
107:
108: l_reporting_type_id apps.zx_reporting_types_b.reporting_type_id%TYPE ;
109:
110: BEGIN

Line 1172: l_status fnd_module_installations.status%TYPE;

1168:
1169: /* Used to create the reporting code association for AP */
1170:
1171: PROCEDURE CREATE_ZX_REPORTING_ASSOC_AP(p_tax_id IN NUMBER) IS
1172: l_status fnd_module_installations.status%TYPE;
1173: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1174:
1175: BEGIN
1176: arp_util_tax.debug(' CREATE_ZX_REPORTING_ASSOC_AP(+)');

Line 1173: l_db_status fnd_module_installations.DB_STATUS%TYPE;

1169: /* Used to create the reporting code association for AP */
1170:
1171: PROCEDURE CREATE_ZX_REPORTING_ASSOC_AP(p_tax_id IN NUMBER) IS
1172: l_status fnd_module_installations.status%TYPE;
1173: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1174:
1175: BEGIN
1176: arp_util_tax.debug(' CREATE_ZX_REPORTING_ASSOC_AP(+)');
1177: -- Verify Argentina Installation

Line 1181: FROM fnd_module_installations

1177: -- Verify Argentina Installation
1178: BEGIN
1179: SELECT STATUS, DB_STATUS
1180: INTO l_status, l_db_status
1181: FROM fnd_module_installations
1182: WHERE APPLICATION_ID = '7004'
1183: And MODULE_SHORT_NAME = 'jlarloc';
1184: EXCEPTION
1185: WHEN OTHERS THEN

Line 1961: l_status fnd_module_installations.status%TYPE;

1957:
1958: /* Used to create the reporting code association for AR */
1959:
1960: PROCEDURE CREATE_ZX_REPORTING_ASSOC_AR(p_tax_id IN NUMBER) IS
1961: l_status fnd_module_installations.status%TYPE;
1962: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1963:
1964: BEGIN
1965:

Line 1962: l_db_status fnd_module_installations.DB_STATUS%TYPE;

1958: /* Used to create the reporting code association for AR */
1959:
1960: PROCEDURE CREATE_ZX_REPORTING_ASSOC_AR(p_tax_id IN NUMBER) IS
1961: l_status fnd_module_installations.status%TYPE;
1962: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1963:
1964: BEGIN
1965:
1966: /* Create the Reporting Code association*/