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_IMP_DQM_STAGE dependencies on HZ_TRANS_PKG

Line 161: hz_trans_pkg.set_bulk_dup_id ;

157: ) IS
158: l_sql_stmt VARCHAR2(255) ;
159: BEGIN
160: x_return_status := fnd_api.g_ret_sts_success;
161: hz_trans_pkg.set_bulk_dup_id ;
162: -- execute immediate ' begin HZ_IMP_MATCH_RULE_'||p_match_rule_id||'.pop_parties_int('|| p_batch_id ||',' || p_from_osr ||','|| p_to_osr||'); end;';
163: l_sql_stmt := ' begin HZ_IMP_MATCH_RULE_'||p_match_rule_id||'.pop_parties_int(:1, :2, :3); end;';
164: execute immediate l_sql_stmt using p_batch_id, p_from_osr, p_to_osr;
165: -- execute immediate ' begin HZ_IMP_MATCH_RULE_'||p_match_rule_id||'.pop_party_sites_int('|| p_batch_id ||',' || p_from_osr ||','|| p_to_osr||'); end;';

Line 211: hz_trans_pkg.set_bulk_dup_id ;

207: log(' p_to_osr = ' || p_to_osr);
208: log(' p_batch_mode_flag = '|| p_batch_mode_flag);
209:
210: x_return_status := fnd_api.g_ret_sts_success;
211: hz_trans_pkg.set_bulk_dup_id ;
212: select batch_dedup_flag, batch_dedup_match_rule_id, registry_dedup_match_rule_id, addr_val_flag
213: into l_a, l_c, l_d, l_e
214: from hz_imp_batch_summary
215: where batch_id = p_batch_id;

Line 1844: l_trans_list(i) := ' HZ_TRANS_PKG.set_party_type(H_P_P_TYPE(I));';

1840:
1841:
1842:
1843: IF p_entity_name = 'PARTY' THEN
1844: l_trans_list(i) := ' HZ_TRANS_PKG.set_party_type(H_P_P_TYPE(I));';
1845: i := i + 1;
1846: END IF;
1847: FOR TX IN ( select ATTRIBUTE_NAME, USER_DEFINED_ATTRIBUTE_NAME, PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN, b.attribute_id
1848: from hz_trans_functions_b b, hz_trans_attributes_vl c

Line 1898: l_trans_list(i + 2) := ' H_P_CT_CUST_2(I) := HZ_TRANS_PKG.EXACT_PADDED(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';

1894: l_str := '';
1895: i := i + 1;
1896: END LOOP;
1897: /*
1898: l_trans_list(i + 2) := ' H_P_CT_CUST_2(I) := HZ_TRANS_PKG.EXACT_PADDED(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1899: l_trans_list(i + 3) := ' H_P_CT_CUST_5(I) := HZ_TRANS_PKG.WRPERSON_EXACT(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1900: l_trans_list(i + 1) := ' H_P_CT_CUST_6(I) := HZ_TRANS_PKG.WRPERSON_CLEANSE(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1901: l_trans_list(i) := ' H_P_CT_CUST_156(I) := HZ_TRANS_PKG.SOUNDX(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1902: */

Line 1899: l_trans_list(i + 3) := ' H_P_CT_CUST_5(I) := HZ_TRANS_PKG.WRPERSON_EXACT(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';

1895: i := i + 1;
1896: END LOOP;
1897: /*
1898: l_trans_list(i + 2) := ' H_P_CT_CUST_2(I) := HZ_TRANS_PKG.EXACT_PADDED(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1899: l_trans_list(i + 3) := ' H_P_CT_CUST_5(I) := HZ_TRANS_PKG.WRPERSON_EXACT(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1900: l_trans_list(i + 1) := ' H_P_CT_CUST_6(I) := HZ_TRANS_PKG.WRPERSON_CLEANSE(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1901: l_trans_list(i) := ' H_P_CT_CUST_156(I) := HZ_TRANS_PKG.SOUNDX(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1902: */
1903: END IF;

Line 1900: l_trans_list(i + 1) := ' H_P_CT_CUST_6(I) := HZ_TRANS_PKG.WRPERSON_CLEANSE(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';

1896: END LOOP;
1897: /*
1898: l_trans_list(i + 2) := ' H_P_CT_CUST_2(I) := HZ_TRANS_PKG.EXACT_PADDED(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1899: l_trans_list(i + 3) := ' H_P_CT_CUST_5(I) := HZ_TRANS_PKG.WRPERSON_EXACT(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1900: l_trans_list(i + 1) := ' H_P_CT_CUST_6(I) := HZ_TRANS_PKG.WRPERSON_CLEANSE(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1901: l_trans_list(i) := ' H_P_CT_CUST_156(I) := HZ_TRANS_PKG.SOUNDX(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1902: */
1903: END IF;
1904: ELSIF p_entity_name = 'CONTACT_POINTS' THEN

Line 1901: l_trans_list(i) := ' H_P_CT_CUST_156(I) := HZ_TRANS_PKG.SOUNDX(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';

1897: /*
1898: l_trans_list(i + 2) := ' H_P_CT_CUST_2(I) := HZ_TRANS_PKG.EXACT_PADDED(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1899: l_trans_list(i + 3) := ' H_P_CT_CUST_5(I) := HZ_TRANS_PKG.WRPERSON_EXACT(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1900: l_trans_list(i + 1) := ' H_P_CT_CUST_6(I) := HZ_TRANS_PKG.WRPERSON_CLEANSE(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1901: l_trans_list(i) := ' H_P_CT_CUST_156(I) := HZ_TRANS_PKG.SOUNDX(H_CT_NAME(I), NULL, ''CONTACT_NAME'', ''CONTACTS'');';
1902: */
1903: END IF;
1904: ELSIF p_entity_name = 'CONTACT_POINTS' THEN
1905: is_using_allow_cust_attr := using_allow_cust(p_rule_id, 'CONTACT_POINTS','RAW_PHONE_NUMBER');--using_raw_ph_no(p_rule_id);

Line 1921: l_trans_list(i + 1) := ' H_P_CP_CUST_TX10(I) := HZ_TRANS_PKG.REVERSE_PHONE_NUMBER(H_P_CP_R_PH_NO(I), NULL, ''RAW_PHONE_NUMBER'', ''CONTACT_POINTS''); ';

1917: l_str := '';
1918: i := i + 1;
1919: END LOOP;
1920: /*
1921: l_trans_list(i + 1) := ' H_P_CP_CUST_TX10(I) := HZ_TRANS_PKG.REVERSE_PHONE_NUMBER(H_P_CP_R_PH_NO(I), NULL, ''RAW_PHONE_NUMBER'', ''CONTACT_POINTS''); ';
1922: l_trans_list(i) := ' H_P_CP_CUST_TX158(I) := HZ_TRANS_PKG.RM_SPLCHAR(H_P_CP_R_PH_NO(I), NULL, ''RAW_PHONE_NUMBER'', ''CONTACT_POINTS''); '; */
1923: END IF;
1924: ELSIF p_entity_name = 'PARTY_SITES' THEN
1925: is_using_allow_cust_attr := using_allow_cust(p_rule_id, 'PARTY_SITES','ADDRESS');--using_address(p_rule_id);

Line 1922: l_trans_list(i) := ' H_P_CP_CUST_TX158(I) := HZ_TRANS_PKG.RM_SPLCHAR(H_P_CP_R_PH_NO(I), NULL, ''RAW_PHONE_NUMBER'', ''CONTACT_POINTS''); '; */

1918: i := i + 1;
1919: END LOOP;
1920: /*
1921: l_trans_list(i + 1) := ' H_P_CP_CUST_TX10(I) := HZ_TRANS_PKG.REVERSE_PHONE_NUMBER(H_P_CP_R_PH_NO(I), NULL, ''RAW_PHONE_NUMBER'', ''CONTACT_POINTS''); ';
1922: l_trans_list(i) := ' H_P_CP_CUST_TX158(I) := HZ_TRANS_PKG.RM_SPLCHAR(H_P_CP_R_PH_NO(I), NULL, ''RAW_PHONE_NUMBER'', ''CONTACT_POINTS''); '; */
1923: END IF;
1924: ELSIF p_entity_name = 'PARTY_SITES' THEN
1925: is_using_allow_cust_attr := using_allow_cust(p_rule_id, 'PARTY_SITES','ADDRESS');--using_address(p_rule_id);
1926: IF ( is_using_allow_cust_attr = 'Y') THEN

Line 1941: l_trans_list(i) := ' H_P_PS_CUST_TX3(I) := HZ_TRANS_PKG.WRADDRESS_EXACT(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES''); ';

1937: l_str := '';
1938: i := i + 1;
1939: END LOOP;
1940: /*
1941: l_trans_list(i) := ' H_P_PS_CUST_TX3(I) := HZ_TRANS_PKG.WRADDRESS_EXACT(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES''); ';
1942: l_trans_list(i + 1) := ' H_P_PS_CUST_TX4(I) := HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES''); ';
1943: l_trans_list(i + 2) := ' H_P_PS_CUST_TX26(I) := HZ_TRANS_PKG.BASIC_WRADDR(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES'', ''SEARCH''); ';
1944: l_trans_list(i + 3) := ' H_P_PS_CUST_TX27(I) := HZ_TRANS_PKG.BASIC_CLEANSE_WRADDR(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES'', ''SEARCH''); '; */
1945: END IF;

Line 1942: l_trans_list(i + 1) := ' H_P_PS_CUST_TX4(I) := HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES''); ';

1938: i := i + 1;
1939: END LOOP;
1940: /*
1941: l_trans_list(i) := ' H_P_PS_CUST_TX3(I) := HZ_TRANS_PKG.WRADDRESS_EXACT(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES''); ';
1942: l_trans_list(i + 1) := ' H_P_PS_CUST_TX4(I) := HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES''); ';
1943: l_trans_list(i + 2) := ' H_P_PS_CUST_TX26(I) := HZ_TRANS_PKG.BASIC_WRADDR(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES'', ''SEARCH''); ';
1944: l_trans_list(i + 3) := ' H_P_PS_CUST_TX27(I) := HZ_TRANS_PKG.BASIC_CLEANSE_WRADDR(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES'', ''SEARCH''); '; */
1945: END IF;
1946: END IF;

Line 1943: l_trans_list(i + 2) := ' H_P_PS_CUST_TX26(I) := HZ_TRANS_PKG.BASIC_WRADDR(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES'', ''SEARCH''); ';

1939: END LOOP;
1940: /*
1941: l_trans_list(i) := ' H_P_PS_CUST_TX3(I) := HZ_TRANS_PKG.WRADDRESS_EXACT(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES''); ';
1942: l_trans_list(i + 1) := ' H_P_PS_CUST_TX4(I) := HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES''); ';
1943: l_trans_list(i + 2) := ' H_P_PS_CUST_TX26(I) := HZ_TRANS_PKG.BASIC_WRADDR(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES'', ''SEARCH''); ';
1944: l_trans_list(i + 3) := ' H_P_PS_CUST_TX27(I) := HZ_TRANS_PKG.BASIC_CLEANSE_WRADDR(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES'', ''SEARCH''); '; */
1945: END IF;
1946: END IF;
1947: EXCEPTION WHEN OTHERS THEN

Line 1944: l_trans_list(i + 3) := ' H_P_PS_CUST_TX27(I) := HZ_TRANS_PKG.BASIC_CLEANSE_WRADDR(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES'', ''SEARCH''); '; */

1940: /*
1941: l_trans_list(i) := ' H_P_PS_CUST_TX3(I) := HZ_TRANS_PKG.WRADDRESS_EXACT(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES''); ';
1942: l_trans_list(i + 1) := ' H_P_PS_CUST_TX4(I) := HZ_TRANS_PKG.WRADDRESS_CLEANSE(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES''); ';
1943: l_trans_list(i + 2) := ' H_P_PS_CUST_TX26(I) := HZ_TRANS_PKG.BASIC_WRADDR(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES'', ''SEARCH''); ';
1944: l_trans_list(i + 3) := ' H_P_PS_CUST_TX27(I) := HZ_TRANS_PKG.BASIC_CLEANSE_WRADDR(H_P_PS_ADD(I), NULL, ''ADDRESS'', ''PARTY_SITES'', ''SEARCH''); '; */
1945: END IF;
1946: END IF;
1947: EXCEPTION WHEN OTHERS THEN
1948: RAISE FND_API.G_EXC_ERROR;

Line 2030: /* H_TX4(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX4(I),NULL, 'ORGANIZATION_NAME','PARTY','STAGE');

2026: END IF;
2027: l(l_trans_list(I));
2028: l_trans_list.DELETE(I);
2029: END LOOP ;
2030: /* H_TX4(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX4(I),NULL, 'ORGANIZATION_NAME','PARTY','STAGE');
2031: H_TX11(I):=HZ_TRANS_PKG.EXACT_PADDED(H_TX11(I),NULL, 'SIC_CODE','PARTY');
2032: H_TX41(I):=HZ_TRANS_PKG.EXACT(H_TX41(I),NULL, 'DUNS_NUMBER_C','PARTY');
2033: -- H_TX44(I):=HZ_TRANS_PKG.RM_SPLCHAR(H_TX44(I),NULL, 'TAX_REFERENCE','PARTY');
2034: */

Line 2031: H_TX11(I):=HZ_TRANS_PKG.EXACT_PADDED(H_TX11(I),NULL, 'SIC_CODE','PARTY');

2027: l(l_trans_list(I));
2028: l_trans_list.DELETE(I);
2029: END LOOP ;
2030: /* H_TX4(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX4(I),NULL, 'ORGANIZATION_NAME','PARTY','STAGE');
2031: H_TX11(I):=HZ_TRANS_PKG.EXACT_PADDED(H_TX11(I),NULL, 'SIC_CODE','PARTY');
2032: H_TX41(I):=HZ_TRANS_PKG.EXACT(H_TX41(I),NULL, 'DUNS_NUMBER_C','PARTY');
2033: -- H_TX44(I):=HZ_TRANS_PKG.RM_SPLCHAR(H_TX44(I),NULL, 'TAX_REFERENCE','PARTY');
2034: */
2035: l(' END LOOP;');

Line 2032: H_TX41(I):=HZ_TRANS_PKG.EXACT(H_TX41(I),NULL, 'DUNS_NUMBER_C','PARTY');

2028: l_trans_list.DELETE(I);
2029: END LOOP ;
2030: /* H_TX4(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX4(I),NULL, 'ORGANIZATION_NAME','PARTY','STAGE');
2031: H_TX11(I):=HZ_TRANS_PKG.EXACT_PADDED(H_TX11(I),NULL, 'SIC_CODE','PARTY');
2032: H_TX41(I):=HZ_TRANS_PKG.EXACT(H_TX41(I),NULL, 'DUNS_NUMBER_C','PARTY');
2033: -- H_TX44(I):=HZ_TRANS_PKG.RM_SPLCHAR(H_TX44(I),NULL, 'TAX_REFERENCE','PARTY');
2034: */
2035: l(' END LOOP;');
2036: l(' SAVEPOINT pop_parties;');

Line 2033: -- H_TX44(I):=HZ_TRANS_PKG.RM_SPLCHAR(H_TX44(I),NULL, 'TAX_REFERENCE','PARTY');

2029: END LOOP ;
2030: /* H_TX4(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX4(I),NULL, 'ORGANIZATION_NAME','PARTY','STAGE');
2031: H_TX11(I):=HZ_TRANS_PKG.EXACT_PADDED(H_TX11(I),NULL, 'SIC_CODE','PARTY');
2032: H_TX41(I):=HZ_TRANS_PKG.EXACT(H_TX41(I),NULL, 'DUNS_NUMBER_C','PARTY');
2033: -- H_TX44(I):=HZ_TRANS_PKG.RM_SPLCHAR(H_TX44(I),NULL, 'TAX_REFERENCE','PARTY');
2034: */
2035: l(' END LOOP;');
2036: l(' SAVEPOINT pop_parties;');
2037: l(' BEGIN ');

Line 2176: /* H_TX4(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX4(I),NULL, 'ORGANIZATION_NAME','PARTY','STAGE');

2172: END IF;
2173: l(l_trans_list(I));
2174: l_trans_list.DELETE(I);
2175: END LOOP ;
2176: /* H_TX4(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX4(I),NULL, 'ORGANIZATION_NAME','PARTY','STAGE');
2177: H_TX11(I):=HZ_TRANS_PKG.EXACT_PADDED(H_TX11(I),NULL, 'SIC_CODE','PARTY');
2178: H_TX41(I):=HZ_TRANS_PKG.EXACT(H_TX41(I),NULL, 'DUNS_NUMBER_C','PARTY');
2179: */
2180: l(' END LOOP; ');

Line 2177: H_TX11(I):=HZ_TRANS_PKG.EXACT_PADDED(H_TX11(I),NULL, 'SIC_CODE','PARTY');

2173: l(l_trans_list(I));
2174: l_trans_list.DELETE(I);
2175: END LOOP ;
2176: /* H_TX4(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX4(I),NULL, 'ORGANIZATION_NAME','PARTY','STAGE');
2177: H_TX11(I):=HZ_TRANS_PKG.EXACT_PADDED(H_TX11(I),NULL, 'SIC_CODE','PARTY');
2178: H_TX41(I):=HZ_TRANS_PKG.EXACT(H_TX41(I),NULL, 'DUNS_NUMBER_C','PARTY');
2179: */
2180: l(' END LOOP; ');
2181: l(' SAVEPOINT pop_parties_int; ');

Line 2178: H_TX41(I):=HZ_TRANS_PKG.EXACT(H_TX41(I),NULL, 'DUNS_NUMBER_C','PARTY');

2174: l_trans_list.DELETE(I);
2175: END LOOP ;
2176: /* H_TX4(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX4(I),NULL, 'ORGANIZATION_NAME','PARTY','STAGE');
2177: H_TX11(I):=HZ_TRANS_PKG.EXACT_PADDED(H_TX11(I),NULL, 'SIC_CODE','PARTY');
2178: H_TX41(I):=HZ_TRANS_PKG.EXACT(H_TX41(I),NULL, 'DUNS_NUMBER_C','PARTY');
2179: */
2180: l(' END LOOP; ');
2181: l(' SAVEPOINT pop_parties_int; ');
2182: l(' BEGIN ');

Line 2346: /* H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, ''ADDRESS'',''PARTY_SITE'');

2342: END IF;
2343: l(l_trans_list(I));
2344: l_trans_list.DELETE(I);
2345: END LOOP ;
2346: /* H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, ''ADDRESS'',''PARTY_SITE'');
2347: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2348: H_TX11(I):= HZ_TRANS_PKG.RM_SPLCHAR(H_TX11(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2349: */
2350: l(' END LOOP; ');

Line 2347: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'POSTAL_CODE','PARTY_SITE');

2343: l(l_trans_list(I));
2344: l_trans_list.DELETE(I);
2345: END LOOP ;
2346: /* H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, ''ADDRESS'',''PARTY_SITE'');
2347: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2348: H_TX11(I):= HZ_TRANS_PKG.RM_SPLCHAR(H_TX11(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2349: */
2350: l(' END LOOP; ');
2351: l(' SAVEPOINT pop_party_sites; ');

Line 2348: H_TX11(I):= HZ_TRANS_PKG.RM_SPLCHAR(H_TX11(I),NULL, 'POSTAL_CODE','PARTY_SITE');

2344: l_trans_list.DELETE(I);
2345: END LOOP ;
2346: /* H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, ''ADDRESS'',''PARTY_SITE'');
2347: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2348: H_TX11(I):= HZ_TRANS_PKG.RM_SPLCHAR(H_TX11(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2349: */
2350: l(' END LOOP; ');
2351: l(' SAVEPOINT pop_party_sites; ');
2352: l(' BEGIN ');

Line 2496: H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, 'ADDRESS','PARTY_SITE');

2492: l(l_trans_list(I));
2493: l_trans_list.DELETE(I);
2494: END LOOP ;
2495: /*
2496: H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, 'ADDRESS','PARTY_SITE');
2497: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2498: H_TX11(I):= HZ_TRANS_PKG.RM_SPLCHAR(H_TX11(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2499: */
2500: l(' END LOOP; ');

Line 2497: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'POSTAL_CODE','PARTY_SITE');

2493: l_trans_list.DELETE(I);
2494: END LOOP ;
2495: /*
2496: H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, 'ADDRESS','PARTY_SITE');
2497: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2498: H_TX11(I):= HZ_TRANS_PKG.RM_SPLCHAR(H_TX11(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2499: */
2500: l(' END LOOP; ');
2501: l(' SAVEPOINT pop_party_sites_int; ');

Line 2498: H_TX11(I):= HZ_TRANS_PKG.RM_SPLCHAR(H_TX11(I),NULL, 'POSTAL_CODE','PARTY_SITE');

2494: END LOOP ;
2495: /*
2496: H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, 'ADDRESS','PARTY_SITE');
2497: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2498: H_TX11(I):= HZ_TRANS_PKG.RM_SPLCHAR(H_TX11(I),NULL, 'POSTAL_CODE','PARTY_SITE');
2499: */
2500: l(' END LOOP; ');
2501: l(' SAVEPOINT pop_party_sites_int; ');
2502: l(' BEGIN ');

Line 2970: /* H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, 'CONTACT_NUMBER','CONTACTS');

2966: END IF;
2967: l(l_trans_list(I));
2968: l_trans_list.DELETE(I);
2969: END LOOP ;
2970: /* H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, 'CONTACT_NUMBER','CONTACTS');
2971: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'TITLE','CONTACTS');
2972: */
2973: l(' END LOOP; ');
2974: l(' SAVEPOINT pop_contacts; ');

Line 2971: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'TITLE','CONTACTS');

2967: l(l_trans_list(I));
2968: l_trans_list.DELETE(I);
2969: END LOOP ;
2970: /* H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, 'CONTACT_NUMBER','CONTACTS');
2971: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'TITLE','CONTACTS');
2972: */
2973: l(' END LOOP; ');
2974: l(' SAVEPOINT pop_contacts; ');
2975: l(' BEGIN ');

Line 3092: /* H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, 'CONTACT_NUMBER','CONTACTS');

3088: END IF;
3089: l(l_trans_list(I));
3090: l_trans_list.DELETE(I);
3091: END LOOP ;
3092: /* H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, 'CONTACT_NUMBER','CONTACTS');
3093: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'TITLE','CONTACTS'); */
3094: l(' END LOOP; ');
3095: l(' SAVEPOINT pop_contacts_int; ');
3096: l(' BEGIN ');

Line 3093: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'TITLE','CONTACTS'); */

3089: l(l_trans_list(I));
3090: l_trans_list.DELETE(I);
3091: END LOOP ;
3092: /* H_TX4(I):= HZ_TRANS_PKG.WRADDRESS_CLEANSE (H_TX4(I),NULL, 'CONTACT_NUMBER','CONTACTS');
3093: H_TX6(I):= HZ_TRANS_PKG.CLEANSED_EMAIL (H_TX6(I),NULL, 'TITLE','CONTACTS'); */
3094: l(' END LOOP; ');
3095: l(' SAVEPOINT pop_contacts_int; ');
3096: l(' BEGIN ');
3097: l(' FORALL I in H_P_CONTACT_OS.FIRST..H_P_CONTACT_OS.LAST ');

Line 3236: H_TX41(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX41(I),NULL, 'EMAIL','CONTACT_POINTS','STAGE');

3232: l(l_trans_list(I));
3233: l_trans_list.DELETE(I);
3234: END LOOP ;
3235: /*
3236: H_TX41(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX41(I),NULL, 'EMAIL','CONTACT_POINTS','STAGE');
3237: */
3238: l(' END LOOP; ');
3239: l(' SAVEPOINT POP_CP; ');
3240: l(' BEGIN ');

Line 3385: -- H_TX41(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX41(I),NULL, 'EMAIL','CONTACT_POINTS','STAGE');

3381: END IF;
3382: l(l_trans_list(I));
3383: l_trans_list.DELETE(I);
3384: END LOOP ;
3385: -- H_TX41(I):=HZ_TRANS_PKG.WRNAMES_CLEANSE(H_TX41(I),NULL, 'EMAIL','CONTACT_POINTS','STAGE');
3386: l(' END LOOP; ');
3387: l(' SAVEPOINT pop_cp_int; ');
3388: l(' BEGIN ');
3389: l(' FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST ');