DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on DUAL

Line 615: from dual;

611: into l_user_id,
612: l_user_name --,
613: --l_resp_name,
614: --l_application_name
615: from dual;
616: end if;
617:
618: if l_user_id is null then
619: l_language_code := 'US';

Line 882: -- output value from the previous item. Therefore, individual item

878:
879: ------------------------------------------------------------------------
880: -- the following reintialize is required
881: -- if there are multiple items, the get_optional_info will accumulate the
882: -- output value from the previous item. Therefore, individual item
883: -- should has a fresh output data
884: -----------------------------------------------------------------------
885: t_pub := companyNameList();
886: t_pub_id := numberList();

Line 1401: FROM dual

1397:
1398: IF l_version IS NOT NULL THEN
1399: BEGIN
1400: SELECT 1 INTO l_records_exist
1401: FROM dual
1402: WHERE exists ( SELECT 1
1403: FROM msc_sup_dem_entries
1404: WHERE plan_id = -1
1405: AND publisher_order_type = 2