DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on DUAL

Line 612: from dual;

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

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

861:
862: ------------------------------------------------------------------------
863: -- the following reintialize is required
864: -- if there are multiple items, the get_optional_info will accumulate the
865: -- output value from the previous item. Therefore, individual item
866: -- should has a fresh output data
867: -----------------------------------------------------------------------
868: t_pub := companyNameList();
869: t_pub_id := numberList();

Line 1384: FROM dual

1380:
1381: IF l_version IS NOT NULL THEN
1382: BEGIN
1383: SELECT 1 INTO l_records_exist
1384: FROM dual
1385: WHERE exists ( SELECT 1
1386: FROM msc_sup_dem_entries
1387: WHERE plan_id = -1
1388: AND publisher_order_type = 2