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 465: FROM POS_CAPACITY_TOLERANCE_TEMP

461: l_tolerance NUMBEr;
462:
463: CURSOR NEW_CAPACITY_TOLERANCE(id number) is
464: SELECT days_in_advance, tolerance
465: FROM POS_CAPACITY_TOLERANCE_TEMP
466: WHERE asl_id=id and status='NEW'
467: order by days_in_advance asc;
468:
469: begin

Line 626: from POS_CAPACITY_TOLERANCE_TEMP

622: else
623: l_progress:='10';
624: select last_updated_by
625: into l_vendor_id
626: from POS_CAPACITY_TOLERANCE_TEMP
627: where capacity_tolerance_id=
628: (select min(capacity_tolerance_id)
629: from POS_CAPACITY_TOLERANCE_TEMP
630: where asl_id=l_asl_id and status='NEW');

Line 629: from POS_CAPACITY_TOLERANCE_TEMP

625: into l_vendor_id
626: from POS_CAPACITY_TOLERANCE_TEMP
627: where capacity_tolerance_id=
628: (select min(capacity_tolerance_id)
629: from POS_CAPACITY_TOLERANCE_TEMP
630: where asl_id=l_asl_id and status='NEW');
631: end if;
632:
633: l_progress:='11';

Line 877: FROM POS_CAPACITY_TOLERANCE_TEMP

873: l_progress number:=0;
874: CURSOR tol_updates(id number) is
875: SELECT
876: days_in_advance, tolerance, created_by
877: FROM POS_CAPACITY_TOLERANCE_TEMP
878: WHERE asl_id=id and status='NEW';
879:
880: CURSOR cap_updates(id number) is
881: SELECT

Line 905: update POS_CAPACITY_TOLERANCE_TEMP

901: pos_supplier_item_tol_pkg.store_line(l_asl_id, l_num_of_days, l_tolerance, l_created_by);
902: end loop;
903:
904: x_progress:='a2';
905: update POS_CAPACITY_TOLERANCE_TEMP
906: set status='ACE'
907: where asl_id=l_asl_id
908: and status='NEW';
909:

Line 1021: update POS_CAPACITY_TOLERANCE_TEMP

1017: set status='REJ'
1018: where asl_id=l_asl_id
1019: and status in ('NEW', 'OLD', 'DEL', 'MOD');
1020:
1021: update POS_CAPACITY_TOLERANCE_TEMP
1022: set status='REJ'
1023: where asl_id=l_asl_id
1024: and status='NEW';
1025: