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 300: FROM pos_mfg_capacity_temp

296: l_cap_per_day NUMBER;
297:
298: CURSOR new_mfg_capacity(id number) is
299: SELECT from_date, to_date, capacity_per_day
300: FROM pos_mfg_capacity_temp
301: WHERE asl_id=id and status in ('NEW', 'OLD', 'MOD')
302: order by from_date asc;
303:
304: begin

Line 554: from POS_MFG_CAPACITY_TEMP

550:
551: l_progress:='7';
552: select count(*)
553: into l_vendor_id
554: from POS_MFG_CAPACITY_TEMP
555: where asl_id=l_asl_id and status in ('NEW', 'OLD', 'DEL', 'MOD');
556:
557: l_progress:='8';
558: if(l_vendor_id>0) then

Line 562: from POS_MFG_CAPACITY_TEMP

558: if(l_vendor_id>0) then
559: l_progress:='9';
560: select last_updated_by
561: into l_vendor_id
562: from POS_MFG_CAPACITY_TEMP
563: where mfg_capacity_id=
564: (select min(mfg_capacity_id)
565: from POS_MFG_CAPACITY_TEMP
566: where asl_id=l_asl_id and

Line 565: from POS_MFG_CAPACITY_TEMP

561: into l_vendor_id
562: from POS_MFG_CAPACITY_TEMP
563: where mfg_capacity_id=
564: (select min(mfg_capacity_id)
565: from POS_MFG_CAPACITY_TEMP
566: where asl_id=l_asl_id and
567: status in ('NEW', 'OLD', 'DEL', 'MOD'));
568: else
569: l_progress:='10';

Line 829: FROM POS_MFG_CAPACITY_TEMP

825:
826: CURSOR cap_updates(id number) is
827: SELECT
828: from_date, to_date, capacity_per_day, capacity_id, created_by, status
829: FROM POS_MFG_CAPACITY_TEMP
830: WHERE asl_id=id and status in ('NEW', 'OLD', 'DEL', 'MOD');
831: begin
832: if (funcmode <> wf_engine.eng_run) then
833: resultout := wf_engine.eng_null;

Line 909: update POS_MFG_CAPACITY_TEMP

905: end if;
906: end loop;
907: x_progress:='a4';
908:
909: update POS_MFG_CAPACITY_TEMP
910: set status='ACE'
911: where asl_id=l_asl_id
912: and status in ('NEW', 'OLD', 'DEL', 'MOD');
913: x_progress:='a5';

Line 962: update POS_MFG_CAPACITY_TEMP

958: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,
959: itemkey => itemkey,
960: aname => 'ASL_ID');
961:
962: update POS_MFG_CAPACITY_TEMP
963: set status='REJ'
964: where asl_id=l_asl_id
965: and status in ('NEW', 'OLD', 'DEL', 'MOD');
966: