APPS.OZF_PRE_PROCESS_PVT dependencies on DUAL

Line 2883: -- INTO l_org_id FROM DUAL;

2879: px_line_record.item_number(i) IS NULL THEN
2880: -- Bug 4520881 (+)
2881: l_org_id := G_ITEM_ORG_ID; --FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
2882: -- SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
2883: -- INTO l_org_id FROM DUAL;
2884: -- Bug 4520881 (-)
2885: OPEN get_item_number( px_line_record.inventory_item_id(i)
2886: , l_org_id);
2887: FETCH get_item_number INTO px_line_record.item_number(i);

Line 3140: FROM DUAL;

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
3143: l_party_site_tbl(i) := l_temp_code_tbl(idx);
3144: px_party_site_id_tbl(i) := TO_NUMBER(l_party_site_tbl(i));

Line 3249: FROM DUAL;

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
3252: l_party_tbl(i) := l_temp_code_tbl(idx);
3253: px_party_id_tbl(i) := TO_NUMBER(l_party_tbl(i));

Line 5244: FROM DUAL;

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
5247: l_party_site_tbl(i) := l_temp_code_tbl(idx);
5248: px_party_site_id_tbl(i) := TO_NUMBER(l_party_site_tbl(i));

Line 5368: FROM DUAL;

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
5371: l_party_tbl(i) := l_temp_code_tbl(idx);
5372: px_party_id_tbl(i) := TO_NUMBER(l_party_tbl(i));

Line 6871: FROM DUAL;

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);
6874: IF OZF_DEBUG_LOW_ON THEN
6875: ozf_utility_pvt.debug_message('Internal Code: ' || x_internal_code_tbl(i));

Line 8641: SELECT ozf_resale_logs_all_s.nextval into l_log_id from dual;

8637: --
8638: IF p_error_code IS NOT NULL THEN
8639: BEGIN
8640:
8641: SELECT ozf_resale_logs_all_s.nextval into l_log_id from dual;
8642:
8643: -- julou bug 6317120. get org_id from table
8644: IF p_id_type = 'BATCH' THEN
8645: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);