APPS.POS_ORDER_MODIFIERS_PKG dependencies on POS_ORDER_MODIFIERS_TEMP

Line 22: select POS_ORDER_MODIFIERS_TEMP_ID_S.NEXTVAL

18: l_seq number;
19: BEGIN
20:
21: /* Update PO_ASL_ATTRIBUTES form ISP */
22: select POS_ORDER_MODIFIERS_TEMP_ID_S.NEXTVAL
23: into l_seq from sys.dual;
24:
25: insert into POS_ORDER_MODIFIERS_TEMP (
26: order_mod_request_id,

Line 25: insert into POS_ORDER_MODIFIERS_TEMP (

21: /* Update PO_ASL_ATTRIBUTES form ISP */
22: select POS_ORDER_MODIFIERS_TEMP_ID_S.NEXTVAL
23: into l_seq from sys.dual;
24:
25: insert into POS_ORDER_MODIFIERS_TEMP (
26: order_mod_request_id,
27: asl_id,
28: last_update_date,
29: last_updated_by,

Line 69: from POS_ORDER_MODIFIERS_TEMP

65: begin
66:
67: select count(*)
68: into p_return_code
69: from POS_ORDER_MODIFIERS_TEMP
70: where asl_id=p_asl_id and status='NEW';
71:
72: end UPDATE_EXIST;
73:

Line 86: from POS_ORDER_MODIFIERS_TEMP

82:
83: /* Update PO_ASL_ATTRIBUTES form ISP */
84: select count(*)
85: into l_count
86: from POS_ORDER_MODIFIERS_TEMP
87: where asl_id=p_asl_id and status='NEW';
88:
89: if(l_count=0) then
90: return;

Line 267: from POS_ORDER_MODIFIERS_TEMP

263:
264:
265: select last_updated_by
266: into l_vendor_id
267: from POS_ORDER_MODIFIERS_TEMP
268: where order_mod_request_id=
269: (select min(order_mod_request_id)
270: from POS_ORDER_MODIFIERS_TEMP
271: where asl_id=l_asl_id and status='NEW');

Line 270: from POS_ORDER_MODIFIERS_TEMP

266: into l_vendor_id
267: from POS_ORDER_MODIFIERS_TEMP
268: where order_mod_request_id=
269: (select min(order_mod_request_id)
270: from POS_ORDER_MODIFIERS_TEMP
271: where asl_id=l_asl_id and status='NEW');
272:
273: if(l_vendor_id is not null) then
274: wf_directory.GetUserName('FND_USR', l_vendor_id, l_supplier_username, l_supplier_displayname);

Line 307: from POS_ORDER_MODIFIERS_TEMP

303: to_char(FIXED_LOT_MULTIPLE)
304: into l_processing_lead_time,
305: l_min_order_qty,
306: l_fixed_lot_multiple
307: from POS_ORDER_MODIFIERS_TEMP
308: where asl_id=l_asl_id and status='NEW';
309:
310: wf_engine.SetItemAttrText ( itemtype => itemtype,
311: itemkey => itemkey,

Line 792: from POS_ORDER_MODIFIERS_TEMP

788: aname => 'ASL_ID');
789:
790: select processing_lead_time, min_order_quantity, fixed_lot_multiple
791: into l_proc_lead_time, l_min_order_qty, l_fixed_lot_multiple
792: from POS_ORDER_MODIFIERS_TEMP
793: where asl_id=l_asl_id
794: and status='NEW';
795:
796: UPDATE PO_ASL_ATTRIBUTES

Line 803: update POS_ORDER_MODIFIERS_TEMP

799: FIXED_LOT_MULTIPLE = l_fixed_lot_multiple
800: WHERE asl_id = l_asl_id
801: and using_organization_id = -1;
802:
803: update POS_ORDER_MODIFIERS_TEMP
804: set status='ACE'
805: where asl_id=l_asl_id
806: and status='NEW';
807:

Line 850: update POS_ORDER_MODIFIERS_TEMP

846: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,
847: itemkey => itemkey,
848: aname => 'ASL_ID');
849:
850: update POS_ORDER_MODIFIERS_TEMP
851: set status='REJ'
852: where asl_id=l_asl_id
853: and status='NEW';
854: