DBA Data[Home] [Help]

APPS.OZF_PRE_PROCESS_PVT dependencies on DBMS_UTILITY

Line 817: time := DBMS_UTILITY.GET_TIME;

813: -- ========================================================================
814:
815: -- Partner id is null
816: IF OZF_DEBUG_LOW_ON THEN
817: time := DBMS_UTILITY.GET_TIME;
818: ozf_utility_pvt.debug_message('Start Time (in Seconds) in '|| l_api_name || ' '|| time/100);
819: END IF;
820:
821: IF p_resale_batch_rec.partner_party_id IS NULL THEN

Line 1005: ozf_utility_pvt.debug_message('End Time (in Seconds) in '|| l_api_name || ' '|| (DBMS_UTILITY.GET_TIME - time)/100);

1001: END IF;
1002:
1003: -- Debug Message
1004: IF OZF_DEBUG_LOW_ON THEN
1005: ozf_utility_pvt.debug_message('End Time (in Seconds) in '|| l_api_name || ' '|| (DBMS_UTILITY.GET_TIME - time)/100);
1006: END IF;
1007: IF OZF_DEBUG_HIGH_ON THEN
1008: ozf_utility_pvt.debug_message(l_api_name||': End');
1009: END IF;

Line 6416: SELECT dbms_utility.get_hash_value( p_external_code_tbl(i),1, 2048)

6412: ozf_utility_pvt.debug_message('External Code: ' || p_external_code_tbl(i));
6413: ozf_utility_pvt.debug_message('Length of External Code: ' || length(p_external_code_tbl(i)));
6414: ozf_utility_pvt.debug_message('Mapping Type: ' || p_mapping_type);
6415: END IF;
6416: SELECT dbms_utility.get_hash_value( p_external_code_tbl(i),1, 2048)
6417: INTO idx
6418: FROM DUAL;
6419: IF l_temp_code_tbl.exists(idx) THEN
6420: x_internal_code_tbl(i) := l_temp_code_tbl(idx);