APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_WORD_CONDITIONS_PKG

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

2412: END IF;
2413: FOR I in H_PS_PARTY_ID.FIRST..H_PS_PARTY_ID.LAST LOOP
2414: ----------- SETTING GLOBAL CONDITION RECORD AT THE PARTY SITE LEVEL ---------
2415:
2416: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(I));
2417: H_TX30(I):=HZ_PARTY_ACQUIRE.get_ssm_mappings(H_PARTY_SITE_ID(I),'PARTY_SITES','ADDR_SOURCE_SYSTEM_REF', 'STAGE');
2418: H_TX4(I):=HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_TX3(I),NULL, 'ADDRESS','PARTY_SITES','STAGE');
2419: H_TX10(I):=HZ_TRANS_PKG.CLEANSE(H_TX9(I),NULL, 'CITY','PARTY_SITES');
2420: H_TX13(I):=HZ_TRANS_PKG.CLEANSE(H_TX12(I),NULL, 'PROVINCE','PARTY_SITES');

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

2581: AND ps.location_id = l.location_id
2582: AND (ps.status is null OR ps.status = 'A' OR ps.status = 'I')
2583: AND ROWNUM=1;
2584: ----------- SETTING GLOBAL CONDITION RECORD AT THE PARTY SITE LEVEL ---------
2585: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(1));
2586: H_TX30(1):=HZ_PARTY_ACQUIRE.get_ssm_mappings(H_PARTY_SITE_ID(1),'PARTY_SITES','ADDR_SOURCE_SYSTEM_REF', 'STAGE');
2587: H_TX4(1):=HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_TX3(1),NULL, 'ADDRESS','PARTY_SITES','STAGE');
2588: H_TX10(1):=HZ_TRANS_PKG.CLEANSE(H_TX9(1),NULL, 'CITY','PARTY_SITES');
2589: H_TX13(1):=HZ_TRANS_PKG.CLEANSE(H_TX12(1),NULL, 'PROVINCE','PARTY_SITES');

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

2808: AND (ps.status is null OR ps.status = 'A' OR ps.status = 'I')
2809: AND ROWNUM=1;
2810:
2811: ---- SETTING GLOBAL CONDITION RECORD AT THE PARTY SITE LEVEL ----
2812: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(1));
2813: H_TX30(1):=HZ_PARTY_ACQUIRE.get_ssm_mappings(H_PARTY_SITE_ID(1),'PARTY_SITES','ADDR_SOURCE_SYSTEM_REF', 'STAGE');
2814: H_TX4(1):=HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_TX3(1),NULL, 'ADDRESS','PARTY_SITES','STAGE');
2815: H_TX10(1):=HZ_TRANS_PKG.CLEANSE(H_TX9(1),NULL, 'CITY','PARTY_SITES');
2816: H_TX13(1):=HZ_TRANS_PKG.CLEANSE(H_TX12(1),NULL, 'PROVINCE','PARTY_SITES');

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

3464: log ('Populating Party Sites Transformation Functions into Arrays...',FALSE);
3465: FOR I in H_PARTY_SITE_ID.FIRST..H_PARTY_SITE_ID.LAST LOOP
3466: ---- SETTING GLOBAL CONDITION RECORD AT THE PARTY SITE LEVEL ----
3467:
3468: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,H_TX22(I));
3469:
3470: H_TX30(I):=HZ_PARTY_ACQUIRE.get_ssm_mappings(H_PARTY_SITE_ID(I),'PARTY_SITES','ADDR_SOURCE_SYSTEM_REF', 'STAGE');
3471: H_TX4(I):=HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_TX3(I),NULL, 'ADDRESS','PARTY_SITES','STAGE');
3472: H_TX10(I):=HZ_TRANS_PKG.CLEANSE(H_TX9(I),NULL, 'CITY','PARTY_SITES');