APPS.OZF_PRE_PROCESS_PVT dependencies on DBMS_UTILITY

Line 836: time := DBMS_UTILITY.GET_TIME;

832: -- ========================================================================
833:
834: -- Partner id is null
835: IF OZF_DEBUG_LOW_ON THEN
836: time := DBMS_UTILITY.GET_TIME;
837: ozf_utility_pvt.debug_message('Start Time (in Seconds) in '|| l_api_name || ' '|| time/100);
838: END IF;
839:
840: IF p_resale_batch_rec.partner_party_id IS NULL THEN

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

1020: END IF;
1021:
1022: -- Debug Message
1023: IF OZF_DEBUG_LOW_ON THEN
1024: ozf_utility_pvt.debug_message('End Time (in Seconds) in '|| l_api_name || ' '|| (DBMS_UTILITY.GET_TIME - time)/100);
1025: END IF;
1026: IF OZF_DEBUG_HIGH_ON THEN
1027: ozf_utility_pvt.debug_message(l_api_name||': End');
1028: END IF;

Line 3138: SELECT dbms_utility.get_hash_value(p_location_tbl(i),1, 2048)

3134: IF (px_site_use_id_tbl(i) IS NULL
3135: AND px_party_site_id_tbl(i) IS NULL
3136: AND p_location_tbl(i) IS NOT NULL) THEN
3137:
3138: SELECT dbms_utility.get_hash_value(p_location_tbl(i),1, 2048)
3139: INTO idx
3140: FROM DUAL;
3141:
3142: IF l_temp_code_tbl.exists(idx) AND l_temp_code_tbl(idx) IS NOT NULL THEN

Line 3247: SELECT dbms_utility.get_hash_value(p_party_name_tbl(i),1, 2048)

3243: IF (px_party_site_id_tbl(i) IS NULL
3244: AND px_party_id_tbl(i) IS NULL
3245: AND p_party_name_tbl(i) IS NOT NULL) THEN
3246:
3247: SELECT dbms_utility.get_hash_value(p_party_name_tbl(i),1, 2048)
3248: INTO idx
3249: FROM DUAL;
3250:
3251: IF l_temp_code_tbl.exists(idx) AND l_temp_code_tbl(idx) IS NOT NULL THEN

Line 5242: SELECT dbms_utility.get_hash_value(p_location_tbl(i),1, 2048)

5238: AND px_party_site_id_tbl(i) IS NULL
5239: AND p_location_tbl(i) IS NOT NULL) THEN
5240:
5241:
5242: SELECT dbms_utility.get_hash_value(p_location_tbl(i),1, 2048)
5243: INTO idx
5244: FROM DUAL;
5245:
5246: IF l_temp_code_tbl.exists(idx) AND l_temp_code_tbl(idx) IS NOT NULL THEN

Line 5366: SELECT dbms_utility.get_hash_value(p_party_name_tbl(i),1, 2048)

5362: AND px_party_id_tbl(i) IS NULL
5363: AND p_party_name_tbl(i) IS NOT NULL) THEN
5364:
5365:
5366: SELECT dbms_utility.get_hash_value(p_party_name_tbl(i),1, 2048)
5367: INTO idx
5368: FROM DUAL;
5369:
5370: IF l_temp_code_tbl.exists(idx) AND l_temp_code_tbl(idx) IS NOT NULL THEN

Line 6869: SELECT dbms_utility.get_hash_value( p_external_code_tbl(i),1, power(2,30)) --ninarasi fix for bug 12977180

6865: ozf_utility_pvt.debug_message('External Code: ' || p_external_code_tbl(i));
6866: ozf_utility_pvt.debug_message('Length of External Code: ' || length(p_external_code_tbl(i)));
6867: ozf_utility_pvt.debug_message('Mapping Type: ' || p_mapping_type);
6868: END IF;
6869: SELECT dbms_utility.get_hash_value( p_external_code_tbl(i),1, power(2,30)) --ninarasi fix for bug 12977180
6870: INTO idx
6871: FROM DUAL;
6872: IF l_temp_code_tbl.exists(idx) THEN
6873: x_internal_code_tbl(i) := l_temp_code_tbl(idx);