APPS.HZ_PARTY_STAGE dependencies on FND_INSTALLATION

Line 370: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN

366: l_status VARCHAR2(255);
367: l_owner1 VARCHAR2(255);
368: l_temp VARCHAR2(255);
369: BEGIN
370: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
371: select owner into l_owner from sys.all_objects
372: where object_name = 'HZ_STAGED_PARTIES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1;
373: END IF;
374: log('Deleting existing staged data');

Line 1017: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);

1013: l_bool BOOLEAN;
1014:
1015: BEGIN
1016:
1017: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
1018:
1019: log('Dropping Indexes');
1020: BEGIN
1021: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_stage_parties_t1 FORCE';

Line 1056: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN

1052: l_status VARCHAR2(255);
1053: l_owner1 VARCHAR2(255);
1054: l_temp VARCHAR2(255);
1055: BEGIN
1056: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
1057: FOR IDX in (
1058: SELECT OWNER||'.'||INDEX_NAME idx_name
1059: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
1060: WHERE f.attribute_id = a.attribute_id

Line 1129: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN

1125: l_db_block_size NUMBER;
1126: l_number_of_blocks NUMBER;
1127:
1128: BEGIN
1129: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
1130: OPEN c_number_of_blocks;
1131: FETCH c_number_of_blocks into l_number_of_blocks;
1132: CLOSE c_number_of_blocks;
1133: OPEN c_db_block_size;

Line 1379: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);

1375: l_command:=p_command;
1376: l_continue:=nvl(p_continue,'N');
1377: FND_MSG_PUB.initialize;
1378:
1379: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
1380:
1381: IF l_command = 'ESTIMATE_SIZE' THEN
1382: reco_staging_parties := ceil(get_size('HZ_PARTIES') * 1.5 * safety_factor);
1383: reco_staging_party_sites := ceil(get_size('HZ_PARTY_SITES') * 3.0 * safety_factor);

Line 2586: l_retstatus := fnd_installation.get_app_info(

2582:
2583: --
2584: -- get schema name of the table for ROWID range processing
2585: --
2586: l_retstatus := fnd_installation.get_app_info(
2587: l_product, l_status, l_industry, l_table_owner);
2588:
2589: if ((l_retstatus = FALSE)
2590: OR

Line 3325: l_bool := fnd_installation.GET_APP_INFO('AR',ustatus,dstatus,l_index_owner);

3321:
3322: COMMIT;
3323: log('Workers have completed successfully');
3324:
3325: l_bool := fnd_installation.GET_APP_INFO('AR',ustatus,dstatus,l_index_owner);
3326:
3327:
3328: -- DECODE WHAT p_index MEANS IN MEANINGFUL TERMS
3329: IF p_index = 'ALL'

Line 11504: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);

11500: l_bool BOOLEAN;
11501:
11502: BEGIN
11503:
11504: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
11505:
11506: select index_tablespace
11507: into ar_index_tbsp
11508: from fnd_product_installations