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_STAGE_MAP_TRANSFORM dependencies on HZ_WORD_CONDITIONS_PKG

Line 2390: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(I));

2386: END IF;
2387: FOR I in H_PS_PARTY_ID.FIRST..H_PS_PARTY_ID.LAST LOOP
2388: ----------- SETTING GLOBAL CONDITION RECORD AT THE PARTY SITE LEVEL ---------
2389:
2390: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(I));
2391: H_TX30(I):=HZ_PARTY_ACQUIRE.get_ssm_mappings(H_PARTY_SITE_ID(I),'PARTY_SITES','ADDR_SOURCE_SYSTEM_REF', 'STAGE');
2392: H_TX4(I):=HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_TX3(I),NULL, 'ADDRESS','PARTY_SITES','STAGE');
2393: H_TX10(I):=HZ_TRANS_PKG.CLEANSE(H_TX9(I),NULL, 'CITY','PARTY_SITES');
2394: H_TX13(I):=HZ_TRANS_PKG.CLEANSE(H_TX12(I),NULL, 'PROVINCE','PARTY_SITES');

Line 2559: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(1));

2555: AND ps.location_id = l.location_id
2556: AND (ps.status is null OR ps.status = 'A' OR ps.status = 'I')
2557: AND ROWNUM=1;
2558: ----------- SETTING GLOBAL CONDITION RECORD AT THE PARTY SITE LEVEL ---------
2559: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(1));
2560: H_TX30(1):=HZ_PARTY_ACQUIRE.get_ssm_mappings(H_PARTY_SITE_ID(1),'PARTY_SITES','ADDR_SOURCE_SYSTEM_REF', 'STAGE');
2561: H_TX4(1):=HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_TX3(1),NULL, 'ADDRESS','PARTY_SITES','STAGE');
2562: H_TX10(1):=HZ_TRANS_PKG.CLEANSE(H_TX9(1),NULL, 'CITY','PARTY_SITES');
2563: H_TX13(1):=HZ_TRANS_PKG.CLEANSE(H_TX12(1),NULL, 'PROVINCE','PARTY_SITES');

Line 2786: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(1));

2782: AND (ps.status is null OR ps.status = 'A' OR ps.status = 'I')
2783: AND ROWNUM=1;
2784:
2785: ---- SETTING GLOBAL CONDITION RECORD AT THE PARTY SITE LEVEL ----
2786: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(1));
2787: H_TX30(1):=HZ_PARTY_ACQUIRE.get_ssm_mappings(H_PARTY_SITE_ID(1),'PARTY_SITES','ADDR_SOURCE_SYSTEM_REF', 'STAGE');
2788: H_TX4(1):=HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_TX3(1),NULL, 'ADDRESS','PARTY_SITES','STAGE');
2789: H_TX10(1):=HZ_TRANS_PKG.CLEANSE(H_TX9(1),NULL, 'CITY','PARTY_SITES');
2790: H_TX13(1):=HZ_TRANS_PKG.CLEANSE(H_TX12(1),NULL, 'PROVINCE','PARTY_SITES');

Line 3442: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(I));

3438: log ('Populating Party Sites Transformation Functions into Arrays...',FALSE);
3439: FOR I in H_PARTY_SITE_ID.FIRST..H_PARTY_SITE_ID.LAST LOOP
3440: ---- SETTING GLOBAL CONDITION RECORD AT THE PARTY SITE LEVEL ----
3441:
3442: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(I));
3443:
3444: H_TX30(I):=HZ_PARTY_ACQUIRE.get_ssm_mappings(H_PARTY_SITE_ID(I),'PARTY_SITES','ADDR_SOURCE_SYSTEM_REF', 'STAGE');
3445: H_TX4(I):=HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_TX3(I),NULL, 'ADDRESS','PARTY_SITES','STAGE');
3446: H_TX10(I):=HZ_TRANS_PKG.CLEANSE(H_TX9(I),NULL, 'CITY','PARTY_SITES');