APPS.POS_UPDATE_CAPACITY_PKG dependencies on POS_MFG_CAPACITY_TEMP

Line 43: select POS_MFG_CAPACITY_TEMP_ID_S.NEXTVAL

39: l_seq number;
40: BEGIN
41:
42: /* Update PO_ASL_ATTRIBUTES form ISP */
43: select POS_MFG_CAPACITY_TEMP_ID_S.NEXTVAL
44: into l_seq from sys.dual;
45:
46: insert into POS_MFG_CAPACITY_TEMP (
47: mfg_capacity_id,

Line 46: insert into POS_MFG_CAPACITY_TEMP (

42: /* Update PO_ASL_ATTRIBUTES form ISP */
43: select POS_MFG_CAPACITY_TEMP_ID_S.NEXTVAL
44: into l_seq from sys.dual;
45:
46: insert into POS_MFG_CAPACITY_TEMP (
47: mfg_capacity_id,
48: asl_id,
49: last_update_date,
50: last_updated_by,

Line 119: select POS_MFG_CAPACITY_TEMP_ID_S.NEXTVAL

115: l_seq number;
116: BEGIN
117:
118: /* Update PO_ASL_ATTRIBUTES form ISP */
119: select POS_MFG_CAPACITY_TEMP_ID_S.NEXTVAL
120: into l_seq from sys.dual;
121:
122: insert into POS_CAPACITY_TOLERANCE_TEMP(
123: capacity_tolerance_id,

Line 182: from POS_MFG_CAPACITY_TEMP

178: begin
179:
180: select count(*)
181: into p_return_code
182: from POS_MFG_CAPACITY_TEMP
183: where asl_id=p_asl_id and status in ('NEW', 'OLD', 'DEL', 'MOD');
184:
185: if(p_return_code>0) then return;
186: else

Line 329: FROM pos_mfg_capacity_temp

325: l_to_date_text VARCHAR2(150) := '';
326:
327: CURSOR new_mfg_capacity(id number) is
328: SELECT from_date, to_date, capacity_per_day
329: FROM pos_mfg_capacity_temp
330: WHERE asl_id=id and status in ('NEW', 'OLD', 'MOD')
331: order by from_date asc;
332:
333: begin

Line 608: from POS_MFG_CAPACITY_TEMP

604:
605: l_progress:='7';
606: select count(*)
607: into l_vendor_id
608: from POS_MFG_CAPACITY_TEMP
609: where asl_id=l_asl_id and status in ('NEW', 'OLD', 'DEL', 'MOD');
610:
611: l_progress:='8';
612: if(l_vendor_id>0) then

Line 616: from POS_MFG_CAPACITY_TEMP

612: if(l_vendor_id>0) then
613: l_progress:='9';
614: select last_updated_by
615: into l_vendor_id
616: from POS_MFG_CAPACITY_TEMP
617: where mfg_capacity_id=
618: (select min(mfg_capacity_id)
619: from POS_MFG_CAPACITY_TEMP
620: where asl_id=l_asl_id and

Line 619: from POS_MFG_CAPACITY_TEMP

615: into l_vendor_id
616: from POS_MFG_CAPACITY_TEMP
617: where mfg_capacity_id=
618: (select min(mfg_capacity_id)
619: from POS_MFG_CAPACITY_TEMP
620: where asl_id=l_asl_id and
621: status in ('NEW', 'OLD', 'DEL', 'MOD'));
622: else
623: l_progress:='10';

Line 883: FROM POS_MFG_CAPACITY_TEMP

879:
880: CURSOR cap_updates(id number) is
881: SELECT
882: from_date, to_date, capacity_per_day, capacity_id, created_by, status
883: FROM POS_MFG_CAPACITY_TEMP
884: WHERE asl_id=id and status in ('NEW', 'OLD', 'DEL', 'MOD');
885: begin
886: if (funcmode <> wf_engine.eng_run) then
887: resultout := wf_engine.eng_null;

Line 963: update POS_MFG_CAPACITY_TEMP

959: end if;
960: end loop;
961: x_progress:='a4';
962:
963: update POS_MFG_CAPACITY_TEMP
964: set status='ACE'
965: where asl_id=l_asl_id
966: and status in ('NEW', 'OLD', 'DEL', 'MOD');
967: x_progress:='a5';

Line 1016: update POS_MFG_CAPACITY_TEMP

1012: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1013: itemkey => itemkey,
1014: aname => 'ASL_ID');
1015:
1016: update POS_MFG_CAPACITY_TEMP
1017: set status='REJ'
1018: where asl_id=l_asl_id
1019: and status in ('NEW', 'OLD', 'DEL', 'MOD');
1020: