APPS.MSC_REL_WF dependencies on DUAL

Line 484: ' from dual';

480: (p_load_type = PURCHASE_REQ_RESCHEDULE and
481: l_buyer is not null) then
482: lv_sql_stmt:=
483: 'select mrp_form_query_s.nextval'||p_dblink||
484: ' from dual';
485:
486: OPEN poCur FOR lv_sql_stmt;
487: FETCH poCur INTO p_query_id;
488: CLOSE poCur;

Line 947: from dual;

943:
944: end if;
945: select msc_form_query_s.nextval
946: into v_batch_id
947: from dual;
948: forall a in 1..p_po_instance_id.count
949: insert into msc_purchase_order_interface
950: (last_update_date,
951: last_updated_by,

Line 1562: from dual;

1558: order by mtp.operating_unit, md.order_number, md.arrival_set_id,md.ship_set_id;
1559: end if;
1560: select msc_form_query_s.nextval
1561: into v_batch_id
1562: from dual;
1563:
1564: for a in 1..p_so_instance_id.count loop
1565:
1566: v_item_id := p_substitute_item_id(a);

Line 1786: sql_stmt := 'SELECT wip_job_number_s.nextval'||db_link||' from dual';

1782: OPEN db_cur;
1783: FETCH db_cur INTO db_link;
1784: CLOSE db_cur;
1785:
1786: sql_stmt := 'SELECT wip_job_number_s.nextval'||db_link||' from dual';
1787:
1788: OPEN JobCur FOR sql_stmt;
1789: FETCH JobCur INTO seq_num;
1790: CLOSE JobCur;

Line 1989: sql_stmt := 'SELECT 1 from dual'||db_link;

1985: OPEN db_cur;
1986: FETCH db_cur INTO db_link;
1987: CLOSE db_cur;
1988:
1989: sql_stmt := 'SELECT 1 from dual'||db_link;
1990:
1991: OPEN JobCur FOR sql_stmt;
1992: FETCH JobCur INTO seq_num;
1993: CLOSE JobCur;

Line 2003: sql_stmt := 'SELECT 1 from dual'||db_link;

1999: OPEN db_cur;
2000: FETCH db_cur INTO db_link;
2001: CLOSE db_cur;
2002:
2003: sql_stmt := 'SELECT 1 from dual'||db_link;
2004:
2005: OPEN JobCur FOR sql_stmt;
2006: FETCH JobCur INTO seq_num;
2007: CLOSE JobCur;

Line 2709: FROM dual;

2705: FND_GLOBAL.APPLICATION_NAME
2706: INTO lv_user_name,
2707: lv_resp_name,
2708: lv_application_name
2709: FROM dual;
2710:
2711: open appl_short_name(lv_application_name);
2712: fetch appl_short_name into lv_appl_short_name;
2713: close appl_short_name;

Line 2719: ':1, :2, :3, :4) from dual';

2715:
2716:
2717:
2718: lv_sql_stmt:= 'SELECT mrp_rel_wf.get_profile_value'||lv_dblink||'('||
2719: ':1, :2, :3, :4) from dual';
2720:
2721: EXECUTE IMMEDIATE lv_sql_stmt
2722: INTO p_profile_value
2723: USING p_profile_name,

Line 3470: from dual;

3466: EXIT WHEN all_c%NOTFOUND;
3467:
3468: select to_char(mrp_form_query_s.nextval)
3469: into item_key
3470: from dual;
3471:
3472: OPEN PLANNER_C(all_rec.plan_id,
3473: all_rec.inventory_item_id,
3474: all_rec.organization_id,