[Home] [Help]
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;
853: nvl(s.implement_uom_code,msi.uom_code), mp.operating_unit;
854:
855: select msc_form_query_s.nextval
856: into v_batch_id
857: from dual;
858:
859: forall a in 1..p_po_instance_id.count
860: insert into msc_purchase_order_interface
861: (last_update_date,
1328: order by mtp.operating_unit, md.order_number, md.arrival_set_id,md.ship_set_id;
1329:
1330: select msc_form_query_s.nextval
1331: into v_batch_id
1332: from dual;
1333:
1334: for a in 1..p_so_instance_id.count loop
1335:
1336: v_item_id := p_substitute_item_id(a);
1547: OPEN db_cur;
1548: FETCH db_cur INTO db_link;
1549: CLOSE db_cur;
1550:
1551: sql_stmt := 'SELECT wip_job_number_s.nextval'||db_link||' from dual';
1552:
1553: OPEN JobCur FOR sql_stmt;
1554: FETCH JobCur INTO seq_num;
1555: CLOSE JobCur;
1750: OPEN db_cur;
1751: FETCH db_cur INTO db_link;
1752: CLOSE db_cur;
1753:
1754: sql_stmt := 'SELECT 1 from dual'||db_link;
1755:
1756: OPEN JobCur FOR sql_stmt;
1757: FETCH JobCur INTO seq_num;
1758: CLOSE JobCur;
2454: FND_GLOBAL.APPLICATION_NAME
2455: INTO lv_user_name,
2456: lv_resp_name,
2457: lv_application_name
2458: FROM dual;
2459:
2460: open appl_short_name(lv_application_name);
2461: fetch appl_short_name into lv_appl_short_name;
2462: close appl_short_name;
2464:
2465:
2466:
2467: lv_sql_stmt:= 'SELECT mrp_rel_wf.get_profile_value'||lv_dblink||'('||
2468: ':1, :2, :3, :4) from dual';
2469:
2470: EXECUTE IMMEDIATE lv_sql_stmt
2471: INTO p_profile_value
2472: USING p_profile_name,
3187: EXIT WHEN all_c%NOTFOUND;
3188:
3189: select to_char(mrp_form_query_s.nextval)
3190: into item_key
3191: from dual;
3192:
3193: wf_engine.CreateProcess( itemtype => item_type,
3194: itemkey => item_key,
3195: process => l_process);