APPS.POS_UPDATE_CAPACITY_PKG dependencies on POS_CAPACITY_TOLERANCE_TEMP

Line 122: insert into POS_CAPACITY_TOLERANCE_TEMP(

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,
124: asl_id,
125: last_update_date,
126: last_updated_by,

Line 189: from POS_CAPACITY_TOLERANCE_TEMP

185: if(p_return_code>0) then return;
186: else
187: select count(*)
188: into p_return_code
189: from POS_CAPACITY_TOLERANCE_TEMP
190: where asl_id=p_asl_id and status='NEW';
191: end if;
192:
193: end UPDATE_EXIST;

Line 411: FROM POS_CAPACITY_TOLERANCE_TEMP

407: l_tolerance NUMBEr;
408:
409: CURSOR NEW_CAPACITY_TOLERANCE(id number) is
410: SELECT days_in_advance, tolerance
411: FROM POS_CAPACITY_TOLERANCE_TEMP
412: WHERE asl_id=id and status='NEW'
413: order by days_in_advance asc;
414:
415: begin

Line 572: from POS_CAPACITY_TOLERANCE_TEMP

568: else
569: l_progress:='10';
570: select last_updated_by
571: into l_vendor_id
572: from POS_CAPACITY_TOLERANCE_TEMP
573: where capacity_tolerance_id=
574: (select min(capacity_tolerance_id)
575: from POS_CAPACITY_TOLERANCE_TEMP
576: where asl_id=l_asl_id and status='NEW');

Line 575: from POS_CAPACITY_TOLERANCE_TEMP

571: into l_vendor_id
572: from POS_CAPACITY_TOLERANCE_TEMP
573: where capacity_tolerance_id=
574: (select min(capacity_tolerance_id)
575: from POS_CAPACITY_TOLERANCE_TEMP
576: where asl_id=l_asl_id and status='NEW');
577: end if;
578:
579: l_progress:='11';

Line 823: FROM POS_CAPACITY_TOLERANCE_TEMP

819: l_progress number:=0;
820: CURSOR tol_updates(id number) is
821: SELECT
822: days_in_advance, tolerance, created_by
823: FROM POS_CAPACITY_TOLERANCE_TEMP
824: WHERE asl_id=id and status='NEW';
825:
826: CURSOR cap_updates(id number) is
827: SELECT

Line 851: update POS_CAPACITY_TOLERANCE_TEMP

847: pos_supplier_item_tol_pkg.store_line(l_asl_id, l_num_of_days, l_tolerance, l_created_by);
848: end loop;
849:
850: x_progress:='a2';
851: update POS_CAPACITY_TOLERANCE_TEMP
852: set status='ACE'
853: where asl_id=l_asl_id
854: and status='NEW';
855:

Line 967: update POS_CAPACITY_TOLERANCE_TEMP

963: set status='REJ'
964: where asl_id=l_asl_id
965: and status in ('NEW', 'OLD', 'DEL', 'MOD');
966:
967: update POS_CAPACITY_TOLERANCE_TEMP
968: set status='REJ'
969: where asl_id=l_asl_id
970: and status='NEW';
971: