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 1056: UPDATE hz_trans_functions_b set index_required_flag='N' where index_required_flag='T';

1052: 'PARTY_SITES','HZ_STAGED_PARTY_SITES','CONTACTS','HZ_STAGED_CONTACTS',
1053: 'CONTACT_POINTS','HZ_STAGED_CONTACT_POINTS')||'_N'||f.function_id) LOOP
1054: EXECUTE IMMEDIATE 'DROP INDEX '||IDX.idx_name;
1055: END LOOP;
1056: UPDATE hz_trans_functions_b set index_required_flag='N' where index_required_flag='T';
1057: END IF;
1058: END;
1059:
1060: PROCEDURE create_log(

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

1870: verify_all_procs;
1871: IF l_command = 'STAGE_ALL_DATA' THEN
1872: drop_indexes;
1873: delete_existing_data;
1874: UPDATE HZ_TRANS_FUNCTIONS_B SET STAGED_FLAG='N'; --Bug No: 3907584.
1875: END IF;
1876:
1877: generate_datastore_prefs;
1878: IF l_command = 'STAGE_ALL_DATA' THEN

Line 3362: UPDATE HZ_TRANS_FUNCTIONS_B

3358: errbuf := SQLERRM;
3359: END;
3360:
3361: END IF;
3362: UPDATE HZ_TRANS_FUNCTIONS_B
3363: SET STAGED_FLAG='Y'
3364: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3365: and attribute_id in (
3366: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY');

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

3363: SET STAGED_FLAG='Y'
3364: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3365: and attribute_id in (
3366: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY');
3367: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for PARTY entity transformations after staging');
3368: -- SYNC DENORM PARTY SITE TEXT INDEX
3369: ELSIF SYNC_PS_TEXT_INDEX THEN
3370: create_btree_indexes ('PARTY_SITES');
3371: IF (new_primary_trans('PARTY_SITES')) THEN

Line 3408: UPDATE HZ_TRANS_FUNCTIONS_B

3404: retcode := 2;
3405: errbuf := SQLERRM;
3406: END;
3407: END IF;
3408: UPDATE HZ_TRANS_FUNCTIONS_B
3409: SET STAGED_FLAG='Y'
3410: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3411: and attribute_id in (
3412: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY_SITES');

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

3409: SET STAGED_FLAG='Y'
3410: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3411: and attribute_id in (
3412: select attribute_id from hz_trans_attributes_vl where entity_name='PARTY_SITES');
3413: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for PARTY_SITES ENTITY after staging');
3414: create_denorm_attribute_pref ('PARTY_SITES');
3415:
3416: -- SYNC DENORM CONTACT TEXT INDEX
3417: ELSIF SYNC_CONTACT_TEXT_INDEX THEN

Line 3457: UPDATE HZ_TRANS_FUNCTIONS_B

3453: errbuf := SQLERRM;
3454: END;
3455:
3456: END IF;
3457: UPDATE HZ_TRANS_FUNCTIONS_B
3458: SET STAGED_FLAG='Y'
3459: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3460: and attribute_id in (
3461: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACTS');

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

3458: SET STAGED_FLAG='Y'
3459: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3460: and attribute_id in (
3461: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACTS');
3462: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for CONTACTS ENTITY after staging');
3463: create_denorm_attribute_pref ('CONTACTS');
3464: -- SYNC DENORM CONTACT POINT TEXT INDEX
3465: ELSIF SYNC_CPT_TEXT_INDEX THEN
3466: create_btree_indexes ('CONTACT_POINTS');

Line 3506: UPDATE HZ_TRANS_FUNCTIONS_B

3502: END;
3503:
3504:
3505: END IF;
3506: UPDATE HZ_TRANS_FUNCTIONS_B
3507: SET STAGED_FLAG='Y'
3508: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3509: and attribute_id in (
3510: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACT_POINTS');

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

3507: SET STAGED_FLAG='Y'
3508: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y' and nvl(staged_flag,'N')='N'
3509: and attribute_id in (
3510: select attribute_id from hz_trans_attributes_vl where entity_name='CONTACT_POINTS');
3511: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B for CONTACT_POINTS ENTITY after staging');
3512: create_denorm_attribute_pref ('CONTACT_POINTS');
3513: END IF;
3514: -- CREATE FLOW
3515: ELSIF index_build_type = 'CREATE'

Line 3524: UPDATE HZ_TRANS_FUNCTIONS_B

3520: create_btree_indexes ('PARTY');
3521: create_btree_indexes ('PARTY_SITES');
3522: create_btree_indexes ('CONTACTS');
3523: create_btree_indexes ('CONTACT_POINTS');
3524: UPDATE HZ_TRANS_FUNCTIONS_B
3525: SET STAGED_FLAG='Y'
3526: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y'
3527: AND nvl(staged_flag,'N')='N' ;
3528: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B after create_btree_indexes');

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

3524: UPDATE HZ_TRANS_FUNCTIONS_B
3525: SET STAGED_FLAG='Y'
3526: WHERE nvl(ACTIVE_FLAG,'Y') = 'Y'
3527: AND nvl(staged_flag,'N')='N' ;
3528: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B after create_btree_indexes');
3529: create_denorm_attribute_pref ('PARTY_SITES');
3530: create_denorm_attribute_pref ('CONTACTS');
3531: create_denorm_attribute_pref ('CONTACT_POINTS');
3532: END IF ;

Line 3914: UPDATE HZ_TRANS_FUNCTIONS_B

3910: END IF;
3911: END IF;
3912:
3913: -- FINALLY UPDATE THE STAGED_FLAG IN HZ_TRANS_FUNCTIONS
3914: UPDATE HZ_TRANS_FUNCTIONS_B
3915: SET STAGED_FLAG='Y' WHERE nvl(ACTIVE_FLAG,'Y') = 'Y'
3916: AND nvl(staged_flag,'N')='N';
3917: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B after create_indexes');
3918: --DELETE THE WORD REPLACEMENTS THAT ARE MARKED FOR DELETE AND

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

3913: -- FINALLY UPDATE THE STAGED_FLAG IN HZ_TRANS_FUNCTIONS
3914: UPDATE HZ_TRANS_FUNCTIONS_B
3915: SET STAGED_FLAG='Y' WHERE nvl(ACTIVE_FLAG,'Y') = 'Y'
3916: AND nvl(staged_flag,'N')='N';
3917: log('Setting STAGED_FLAG=Y in HZ_TRANS_FUNCTIONS_B after create_indexes');
3918: --DELETE THE WORD REPLACEMENTS THAT ARE MARKED FOR DELETE AND
3919: --UPDATE THE STAGED FLAG OF WORD REPLACEMENTS TO Y.
3920: update_word_replacements;
3921: