APPS.HZ_PARTY_STAGE_SHADOW dependencies on FND_INSTALLATION

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

191: l_sql VARCHAR2(4000);
192: BEGIN
193: log('---------------------------------------------------');
194: log('Calling truncate_staging_tables ');
195: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
196: /* select owner into l_owner from sys.all_objects
197: where object_name = 'HZ_STAGED_PARTIES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1;*/
198: l_sql := ' select owner from sys.all_tables where table_name = ''HZ_STAGED_PARTIES'' and owner = :1';
199: EXECUTE IMMEDIATE l_sql into l_owner USING l_owner1;

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

236: BEGIN
237: log('---------------------------------------------------');
238: log('Calling truncate_thin_tables ');
239:
240: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
241: l_sql := ' select owner from sys.all_tables where table_name = ''HZ_THIN_ST_PARTIES'' and owner = :1';
242: EXECUTE IMMEDIATE l_sql into l_owner USING l_owner1;
243: /* select owner into l_owner from sys.all_objects
244: where object_name = 'HZ_THIN_ST_PARTIES' and OBJECT_TYPE = 'TABLE' and

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

643: l_bool BOOLEAN;
644:
645: BEGIN
646:
647: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
648: log('---------------------------------------------------');
649: log('Calling drop_context_indexes');
650: log('Dropping Context Indexes on Thin tables');
651: BEGIN

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

690: BEGIN
691: log('---------------------------------------------------');
692: log('Calling drop_btree_indexes');
693: log('Dropping Btree Indexes on Base Staging tables');
694: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
695: FOR IDX in (
696: SELECT OWNER||'.'||INDEX_NAME idx_name
697: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
698: WHERE f.attribute_id = a.attribute_id

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

895:
896: -- req_data will be null the first time, by default
897: req_data := fnd_conc_global.request_data;
898:
899: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
900: -- First Phase
901: IF (req_data IS NULL)
902: THEN
903: retcode := 0;

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

1716:
1717:
1718: log('Data Workers have completed successfully');
1719:
1720: l_bool := fnd_installation.GET_APP_INFO('AR',ustatus,dstatus,l_index_owner);
1721:
1722: log('About to create index');
1723: log('Index owner is ' || l_index_owner);
1724: log('Schema Name is ' || g_schema_name );

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

4389: l_bool BOOLEAN;
4390:
4391: BEGIN
4392:
4393: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
4394:
4395: select index_tablespace
4396: into ar_index_tbsp
4397: from fnd_product_installations