DBA Data[Home] [Help]

APPS.ZX_AP_POPULATE_PKG dependencies on DBMS_UTILITY

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

976: END IF;
977:
978:
979: IF l_bill_ship_pty_id IS NOT NULL THEN
980: --l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_bill_ship_pty_id), 1,8192);
981: l_tbl_index_party := to_char(l_bill_ship_pty_id);
982:
983: IF g_party_info_ap_tbl.EXISTS(l_tbl_index_party) THEN
984:

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

1030: FETCH party_reg_num_cur into GT_BILLING_TP_TAX_REG_NUM(i);
1031: END IF;
1032:
1033: IF l_bill_ship_site_id IS NOT NULL THEN
1034: --l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_ship_site_id), 1,8192);
1035: l_tbl_index_site := to_char(l_bill_ship_site_id);
1036:
1037: IF g_party_site_tbl.EXISTS(l_tbl_index_site) THEN
1038:

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

3319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3320: 'Lookup Type and Lookup code are not null '||p_lookup_type||'-'||P_LOOKUP_CODE);
3321: END IF;
3322:
3323: l_tbl_index_lookup := dbms_utility.get_hash_value(p_lookup_type||p_lookup_code, 1,8192);
3324:
3325: IF (g_level_procedure >= g_current_runtime_level ) THEN
3326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_POPULATE_PKG.lookup_desc_meaning',
3327: 'Meaning Alredy existed in the Cache');