APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on FND_MODULE_INSTALLATIONS

Line 120: l_status fnd_module_installations.status%TYPE;

116: | |
117: |=========================================================================*/
118:
119: PROCEDURE CREATE_ZX_REPORTING_ASSOC(p_tax_id IN NUMBER) IS
120: l_status fnd_module_installations.status%TYPE;
121: l_db_status fnd_module_installations.DB_STATUS%TYPE;
122:
123: l_reporting_type_id zx_reporting_types_b.reporting_type_id%TYPE ;
124:

Line 121: l_db_status fnd_module_installations.DB_STATUS%TYPE;

117: |=========================================================================*/
118:
119: PROCEDURE CREATE_ZX_REPORTING_ASSOC(p_tax_id IN NUMBER) IS
120: l_status fnd_module_installations.status%TYPE;
121: l_db_status fnd_module_installations.DB_STATUS%TYPE;
122:
123: l_reporting_type_id zx_reporting_types_b.reporting_type_id%TYPE ;
124:
125: BEGIN

Line 1187: l_status fnd_module_installations.status%TYPE;

1183:
1184: /* Used to create the reporting code association for AP */
1185:
1186: PROCEDURE CREATE_ZX_REPORTING_ASSOC_AP(p_tax_id IN NUMBER) IS
1187: l_status fnd_module_installations.status%TYPE;
1188: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1189:
1190: BEGIN
1191: arp_util_tax.debug(' CREATE_ZX_REPORTING_ASSOC_AP(+)');

Line 1188: l_db_status fnd_module_installations.DB_STATUS%TYPE;

1184: /* Used to create the reporting code association for AP */
1185:
1186: PROCEDURE CREATE_ZX_REPORTING_ASSOC_AP(p_tax_id IN NUMBER) IS
1187: l_status fnd_module_installations.status%TYPE;
1188: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1189:
1190: BEGIN
1191: arp_util_tax.debug(' CREATE_ZX_REPORTING_ASSOC_AP(+)');
1192: -- Verify Argentina Installation

Line 1196: FROM fnd_module_installations

1192: -- Verify Argentina Installation
1193: BEGIN
1194: SELECT STATUS, DB_STATUS
1195: INTO l_status, l_db_status
1196: FROM fnd_module_installations
1197: WHERE APPLICATION_ID = '7004'
1198: And MODULE_SHORT_NAME = 'jlarloc';
1199: EXCEPTION
1200: WHEN OTHERS THEN

Line 1988: l_status fnd_module_installations.status%TYPE;

1984:
1985: /* Used to create the reporting code association for AR */
1986:
1987: PROCEDURE CREATE_ZX_REPORTING_ASSOC_AR(p_tax_id IN NUMBER) IS
1988: l_status fnd_module_installations.status%TYPE;
1989: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1990:
1991: BEGIN
1992:

Line 1989: l_db_status fnd_module_installations.DB_STATUS%TYPE;

1985: /* Used to create the reporting code association for AR */
1986:
1987: PROCEDURE CREATE_ZX_REPORTING_ASSOC_AR(p_tax_id IN NUMBER) IS
1988: l_status fnd_module_installations.status%TYPE;
1989: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1990:
1991: BEGIN
1992:
1993: /* Create the Reporting Code association*/