APPS.ONT_ITM_PKG dependencies on DUAL

Line 993: FROM dual;

989: IF l_Addl_Country_Name IS NOT NULL THEN
990: l_rec_count := 2;
991: SELECT wsh_itm_request_set_s.NEXTVAL
992: INTO l_request_set_id
993: FROM dual;
994: IF l_debug_level > 0 THEN
995: oe_debug_pub.add('Addl country name:'||l_addl_country_name);
996: END IF;
997: ELSE

Line 1007: FROM dual;

1003: FOR I in 1..l_rec_count LOOP
1004:
1005: SELECT wsh_itm_request_control_s.NEXTVAL
1006: INTO l_request_control_id
1007: FROM dual;
1008:
1009:
1010: -- Retrieve the Header Information
1011:

Line 1313: FROM dual;

1309: IF Address_table(J).add_source_orgid IS NOT NULL THEN
1310:
1311: SELECT wsh_itm_parties_s.NEXTVAL
1312: INTO l_party_id
1313: FROM dual;
1314:
1315: INSERT INTO WSH_ITM_PARTIES (
1316: PARTY_ID,
1317: REQUEST_CONTROL_ID,

Line 1700: -- individual Line.

1696: /*
1697:
1698: -- This select statement is used to lock the Top Model Line.
1699: -- After the Top Model Line is Locked we go ahead the Lock the
1700: -- individual Line.
1701:
1702: SELECT top_model_line_id
1703: INTO l_top_model_line_id
1704: FROM oe_order_lines