APPS.MSC_X_WFNOTIFY_PKG dependencies on DUAL

Line 548: SELECT 1 into l_exist from dual

544: end loop;
545: close planners_c;
546: ELSE
547: begin
548: SELECT 1 into l_exist from dual
549: WHERE exists (SELECT 1
550: FROM msc_trading_partner_maps map,
551: msc_trading_partner_maps map1,
552: msc_company_sites site,

Line 574: FROM dual

570: EXCEPTION
571: WHEN NO_DATA_FOUND THEN
572: BEGIN
573: SELECT 1 into l_exist
574: FROM dual
575: WHERE exists (SELECT 1
576: FROM msc_trading_partner_maps map,
577: msc_company_sites site,
578: msc_partner_contacts con

Line 599: from dual;

595: IF l_independent = 0 THEN
596:
597: select decode(t_supplier_id(j),1,t_supplier_site_id(j),t_customer_site_id(j))
598: into l_oem_site_id
599: from dual;
600:
601: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql----------------inside else part l_oem_site_id'|| l_oem_site_id);
602:
603: open partner_con_by_site_c(t_company_id(j), t_company_site_id(j),l_oem_site_id,t_item_id(j));

Line 710: FROM dual

706: ELSE -- Search by company
707:
708: BEGIN
709: SELECT 0 into l_independent
710: FROM dual
711: WHERE exists (SELECT 1
712: FROM msc_trading_partner_maps map,
713: msc_trading_partner_maps map1,
714: msc_company_relationships rel,

Line 742: FROM dual

738: EXCEPTION
739: WHEN NO_DATA_FOUND THEN
740: BEGIN
741: SELECT 1 into l_independent
742: FROM dual
743: WHERE EXISTS (SELECT 1
744: FROM msc_trading_partner_maps map,
745: msc_company_relationships rel,
746: msc_companies c,

Line 774: from dual;

770: IF l_exist = 1 THEN
771: IF l_independent = 0 THEN
772: select decode(t_supplier_id(j),1,t_supplier_site_id(j),t_customer_site_id(j))
773: into l_oem_id
774: from dual;
775:
776:
777: open partner_con_by_comp_c(t_company_id(j),l_oem_id,t_item_id(j));
778: ELSE

Line 1682: select msc_cl_refresh_s.nextval into l_next_number from dual;

1678: l_wf_process := 'MSC_PUB_NOTIFY';
1679:
1680:
1681:
1682: select msc_cl_refresh_s.nextval into l_next_number from dual;
1683: IF (p_publish_program_type = G_ORDER_FORECAST) THEN
1684: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launch order forecast notification');
1685: FND_FILE.PUT_LINE(FND_FILE.LOG,'Designator ' || p_designator || ' version ' || p_version);
1686: