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 1005: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);

1001: l_bool BOOLEAN;
1002:
1003: BEGIN
1004:
1005: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
1006:
1007: log('Dropping Indexes');
1008: BEGIN
1009: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_stage_parties_t1 FORCE';

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

1040: l_status VARCHAR2(255);
1041: l_owner1 VARCHAR2(255);
1042: l_temp VARCHAR2(255);
1043: BEGIN
1044: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
1045: FOR IDX in (
1046: SELECT OWNER||'.'||INDEX_NAME idx_name
1047: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
1048: WHERE f.attribute_id = a.attribute_id

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

1113: l_db_block_size NUMBER;
1114: l_number_of_blocks NUMBER;
1115:
1116: BEGIN
1117: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
1118: OPEN c_number_of_blocks;
1119: FETCH c_number_of_blocks into l_number_of_blocks;
1120: CLOSE c_number_of_blocks;
1121: OPEN c_db_block_size;

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

1363: l_command:=p_command;
1364: l_continue:=nvl(p_continue,'N');
1365: FND_MSG_PUB.initialize;
1366:
1367: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
1368:
1369: IF l_command = 'ESTIMATE_SIZE' THEN
1370: reco_staging_parties := ceil(get_size('HZ_PARTIES') * 1.5 * safety_factor);
1371: reco_staging_party_sites := ceil(get_size('HZ_PARTY_SITES') * 3.0 * safety_factor);

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

3201:
3202: COMMIT;
3203: log('Workers have completed successfully');
3204:
3205: l_bool := fnd_installation.GET_APP_INFO('AR',ustatus,dstatus,l_index_owner);
3206:
3207:
3208: -- DECODE WHAT p_index MEANS IN MEANINGFUL TERMS
3209: IF p_index = 'ALL'

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

11346: l_bool BOOLEAN;
11347:
11348: BEGIN
11349:
11350: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
11351:
11352: select index_tablespace
11353: into ar_index_tbsp
11354: from fnd_product_installations