APPS.ZX_AP_POPULATE_PKG dependencies on DBMS_UTILITY

Line 1122: --l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_bill_ship_pty_id), 1,8192);

1118: END IF;
1119:
1120:
1121: IF l_bill_ship_pty_id IS NOT NULL THEN
1122: --l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_bill_ship_pty_id), 1,8192);
1123: l_tbl_index_party := to_char(l_bill_ship_pty_id);
1124:
1125: IF g_party_info_ap_tbl.EXISTS(l_tbl_index_party) THEN
1126:

Line 1176: --l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_ship_site_id), 1,8192);

1172: FETCH party_reg_num_cur into GT_BILLING_TP_TAX_REG_NUM(i);
1173: END IF;
1174:
1175: IF l_bill_ship_site_id IS NOT NULL THEN
1176: --l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_ship_site_id), 1,8192);
1177: l_tbl_index_site := to_char(l_bill_ship_site_id);
1178:
1179: IF g_party_site_tbl.EXISTS(l_tbl_index_site) THEN
1180:

Line 1972: l_tbl_index_ccid := dbms_utility.get_hash_value('tax'||LPAD(TO_CHAR(l_tax_dist_ccid),15,'0'), 1,8192);

1968: -- populare accounting_flexfield and accounting_description column ---
1969: ----------------------------------------------------------------------
1970: IF l_tax_dist_ccid IS NOT NULL THEN
1971:
1972: l_tbl_index_ccid := dbms_utility.get_hash_value('tax'||LPAD(TO_CHAR(l_tax_dist_ccid),15,'0'), 1,8192);
1973: IF ZX_EXTRACT_PKG.g_ccid_val_desc_tbl.EXISTS(l_tbl_index_ccid) AND
1974: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).CCID_KEY = 'tax'||TO_CHAR(l_tax_dist_ccid) THEN
1975:
1976: GT_ACCOUNT_FLEXFIELD(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).FLEXFIELD_VAL;

Line 2024: l_tbl_index_ccid := dbms_utility.get_hash_value('TRX'||LPAD(TO_CHAR(l_trx_dist_ccid),15,'0'), 1,8192);

2020: END IF; --TAX CCID Null Check
2021:
2022: IF l_trx_dist_ccid IS NOT NULL THEN
2023:
2024: l_tbl_index_ccid := dbms_utility.get_hash_value('TRX'||LPAD(TO_CHAR(l_trx_dist_ccid),15,'0'), 1,8192);
2025: IF ZX_EXTRACT_PKG.g_ccid_val_desc_tbl.EXISTS(l_tbl_index_ccid) AND
2026: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).CCID_KEY = 'TRX'||TO_CHAR(l_trx_dist_ccid) THEN
2027:
2028: GT_TRX_CONTROL_ACCFLEXFIELD(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).FLEXFIELD_VAL;

Line 3710: l_tbl_index_lookup := dbms_utility.get_hash_value(p_lookup_type||p_lookup_code, 1,8192);

3706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3707: 'Lookup Type and Lookup code are not null '||p_lookup_type||'-'||P_LOOKUP_CODE);
3708: END IF;
3709:
3710: l_tbl_index_lookup := dbms_utility.get_hash_value(p_lookup_type||p_lookup_code, 1,8192);
3711:
3712: IF (g_level_procedure >= g_current_runtime_level ) THEN
3713: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3714: 'Meaning Alredy existed in the Cache');