eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_STAGE dependencies on HZ_TRANS_FUNCTIONS_B

Line 1068: UPDATE hz_trans_functions_b set index_required_flag='N' where index_required_flag='T';

1064: 'PARTY_SITES','HZ_STAGED_PARTY_SITES','CONTACTS','HZ_STAGED_CONTACTS',
1065: 'CONTACT_POINTS','HZ_STAGED_CONTACT_POINTS')||'_N'||f.function_id) LOOP
1066: EXECUTE IMMEDIATE 'DROP INDEX '||IDX.idx_name;
1067: END LOOP;
1068: UPDATE hz_trans_functions_b set index_required_flag='N' where index_required_flag='T';
1069: END IF;
1070: END;
1071:
1072: PROCEDURE create_log(

Line 1890: UPDATE HZ_TRANS_FUNCTIONS_B SET STAGED_FLAG='N'; --Bug No: 3907584.

1886: verify_all_procs;
1887: IF l_command = 'STAGE_ALL_DATA' THEN
1888: drop_indexes;
1889: delete_existing_data;
1890: UPDATE HZ_TRANS_FUNCTIONS_B SET STAGED_FLAG='N'; --Bug No: 3907584.
1891: END IF;
1892:
1893: generate_datastore_prefs;
1894: IF l_command = 'STAGE_ALL_DATA' THEN

Line 3482: UPDATE HZ_TRANS_FUNCTIONS_B

3478: errbuf := SQLERRM;
3479: END;
3480:
3481: END IF;
3482: UPDATE HZ_TRANS_FUNCTIONS_B
3483: SET STAGED_FLAG='Y'
3484: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3485: and attribute_id in (
3486: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY');

Line 3487: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for PARTY entity transformations after staging');

3483: SET STAGED_FLAG='Y'
3484: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3485: and attribute_id in (
3486: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY');
3487: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for PARTY entity transformations after staging');
3488: -- SYNC DENORM PARTY SITE TEXT INDEX
3489: ELSIF SYNC_PS_TEXT_INDEX THEN
3490: create_btree_indexes ('PARTY_SITES');
3491: IF (new_primary_trans('PARTY_SITES')) THEN

Line 3528: UPDATE HZ_TRANS_FUNCTIONS_B

3524: retcode := 2;
3525: errbuf := SQLERRM;
3526: END;
3527: END IF;
3528: UPDATE HZ_TRANS_FUNCTIONS_B
3529: SET STAGED_FLAG='Y'
3530: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3531: and attribute_id in (
3532: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY_SITES');

Line 3533: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for PARTY_SITES ENTITY after staging');

3529: SET STAGED_FLAG='Y'
3530: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3531: and attribute_id in (
3532: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY_SITES');
3533: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for PARTY_SITES ENTITY after staging');
3534: create_denorm_attribute_pref ('PARTY_SITES');
3535:
3536: -- SYNC DENORM CONTACT TEXT INDEX
3537: ELSIF SYNC_CONTACT_TEXT_INDEX THEN

Line 3577: UPDATE HZ_TRANS_FUNCTIONS_B

3573: errbuf := SQLERRM;
3574: END;
3575:
3576: END IF;
3577: UPDATE HZ_TRANS_FUNCTIONS_B
3578: SET STAGED_FLAG='Y'
3579: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3580: and attribute_id in (
3581: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACTS');

Line 3582: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for CONTACTS ENTITY after staging');

3578: SET STAGED_FLAG='Y'
3579: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3580: and attribute_id in (
3581: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACTS');
3582: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for CONTACTS ENTITY after staging');
3583: create_denorm_attribute_pref ('CONTACTS');
3584: -- SYNC DENORM CONTACT POINT TEXT INDEX
3585: ELSIF SYNC_CPT_TEXT_INDEX THEN
3586: create_btree_indexes ('CONTACT_POINTS');

Line 3626: UPDATE HZ_TRANS_FUNCTIONS_B

3622: END;
3623:
3624:
3625: END IF;
3626: UPDATE HZ_TRANS_FUNCTIONS_B
3627: SET STAGED_FLAG='Y'
3628: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3629: and attribute_id in (
3630: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACT_POINTS');

Line 3631: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for CONTACT_POINTS ENTITY after staging');

3627: SET STAGED_FLAG='Y'
3628: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3629: and attribute_id in (
3630: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACT_POINTS');
3631: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for CONTACT_POINTS ENTITY after staging');
3632: create_denorm_attribute_pref ('CONTACT_POINTS');
3633: END IF;
3634: -- CREATE FLOW
3635: ELSIF index_build_type = 'CREATE'

Line 3644: UPDATE HZ_TRANS_FUNCTIONS_B

3640: create_btree_indexes ('PARTY');
3641: create_btree_indexes ('PARTY_SITES');
3642: create_btree_indexes ('CONTACTS');
3643: create_btree_indexes ('CONTACT_POINTS');
3644: UPDATE HZ_TRANS_FUNCTIONS_B
3645: SET STAGED_FLAG='Y'
3646: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y'
3647: AND nvl(staged_flag,'N')='N' ;
3648: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B after create_btree_indexes');

Line 3648: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B after create_btree_indexes');

3644: UPDATE HZ_TRANS_FUNCTIONS_B
3645: SET STAGED_FLAG='Y'
3646: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y'
3647: AND nvl(staged_flag,'N')='N' ;
3648: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B after create_btree_indexes');
3649: create_denorm_attribute_pref ('PARTY_SITES');
3650: create_denorm_attribute_pref ('CONTACTS');
3651: create_denorm_attribute_pref ('CONTACT_POINTS');
3652: END IF ;

Line 4042: UPDATE HZ_TRANS_FUNCTIONS_B

4038: END IF;
4039: END IF;
4040:
4041: -- FINALLY UPDATE THE STAGED_FLAG IN HZ_TRANS_FUNCTIONS
4042: UPDATE HZ_TRANS_FUNCTIONS_B
4043: SET STAGED_FLAG='Y' WHERE nvl(ACTIVE_FLAG,'Y') = 'Y'
4044: AND nvl(staged_flag,'N')='N';
4045: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B after create_indexes');
4046: --DELETE THE WORD REPLACEMENTS THAT ARE MARKED FOR DELETE AND

Line 4045: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B after create_indexes');

4041: -- FINALLY UPDATE THE STAGED_FLAG IN HZ_TRANS_FUNCTIONS
4042: UPDATE HZ_TRANS_FUNCTIONS_B
4043: SET STAGED_FLAG='Y' WHERE nvl(ACTIVE_FLAG,'Y') = 'Y'
4044: AND nvl(staged_flag,'N')='N';
4045: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B after create_indexes');
4046: --DELETE THE WORD REPLACEMENTS THAT ARE MARKED FOR DELETE AND
4047: --UPDATE THE STAGED FLAG OF WORD REPLACEMENTS TO Y.
4048: update_word_replacements;
4049: