[Home] [Help]
999: s_order_type number_idx_tbl ;
1000: o_order_type number_idx_tbl ; -- akaruppa B4287033
1001: /* akaruppa B5007729 End*/
1002:
1003: TYPE order_number IS TABLE OF msc_st_supplies.order_number%TYPE INDEX BY BINARY_INTEGER;
1004: s_order_number order_number ;
1005: se_order_number order_number ;/* akaruppa B5007729 */
1006:
1007: /* akaruppa B5007729 */
1011: s_firm_planned_type number_idx_tbl ;
1012: o_firm_planned_type number_idx_tbl ; -- akaruppa B4287033
1013: /* akaruppa B5007729 End*/
1014:
1015: TYPE wip_entity_name IS TABLE OF msc_st_supplies.wip_entity_name%TYPE INDEX BY BINARY_INTEGER;
1016: s_wip_entity_name wip_entity_name ;
1017: se_wip_entity_name wip_entity_name ;/* akaruppa B5007729 */
1018:
1019: TYPE lot_number IS TABLE OF msc_st_supplies.lot_number%TYPE INDEX BY BINARY_INTEGER;
1015: TYPE wip_entity_name IS TABLE OF msc_st_supplies.wip_entity_name%TYPE INDEX BY BINARY_INTEGER;
1016: s_wip_entity_name wip_entity_name ;
1017: se_wip_entity_name wip_entity_name ;/* akaruppa B5007729 */
1018:
1019: TYPE lot_number IS TABLE OF msc_st_supplies.lot_number%TYPE INDEX BY BINARY_INTEGER;
1020: s_lot_number lot_number ;
1021: o_lot_number lot_number ; -- akaruppa B4287033
1022: e_lot_number lot_number ; /* akaruppa B5007729 */
1023:
1030: /* akaruppa B5007729 End*/
1031:
1032: s_requested_completion_date date_idx_tbl ;
1033:
1034: TYPE stp_schedule_priority IS TABLE OF msc_st_supplies.schedule_priority%TYPE
1035: INDEX BY BINARY_INTEGER;
1036: s_schedule_priority stp_schedule_priority;
1037:
1038: /*B5100481 - 16 for pending, 3 for wip*/
1129: o_new_dock_date date_idx_tbl ;/* akaruppa B5007729 */
1130:
1131: o_deleted_flag number_idx_tbl;/* akaruppa B5007729 */
1132:
1133: TYPE subinventory_code IS TABLE OF msc_st_supplies.subinventory_code%TYPE
1134: INDEX BY BINARY_INTEGER;
1135: o_subinventory_code subinventory_code ;
1136: e_subinventory_code subinventory_code ;/* akaruppa B5007729 */
1137:
7920: * DESCRIPTION
7921: * This procedure will take the production orders, batches and FPOs,
7922: * that have valid item/warehouse definitions as defined in the
7923: * the plant/whse eff and write them to the table msc_std_demands and \
7924: * msc_st_supplies. The products and byproducts will be written as
7925: * supplies and ingredients as demands
7926: * HISTORY
7927: * M Craig
7928: * 04/03/2000 - Using mtl_organization_id instead of organization_id from
7939: * Resource Seq is incremented only if the
7940: * activity is Changed
7941: * Sridhar 31-MAR-2003 B2882286 Ensuring the Order so that if the last batch
7942: * resource requirements are written
7943: * Sridhar 30-APR-2003 B2919303 Added Operation Seq Number in msc_st_supplies
7944: * and in msc_st_demands table
7945: * Sridhar 09-MAY-2003 B2919303 Added line_no and included in order by clause
7946: * Sridhar 12-MAY-2003 B2953953 Populated BY_PRODUCT_USING_ASSY_ID with
7947: * product_line which is the assembly_item_id
9390: i := 1 ;
9391: log_message(s_organization_id.FIRST || ' *s*' || s_organization_id.LAST );
9392: IF s_organization_id.FIRST > 0 THEN
9393: FORALL i IN s_organization_id.FIRST..s_organization_id.LAST
9394: INSERT INTO msc_st_supplies (
9395: plan_id,
9396: inventory_item_id,
9397: organization_id,
9398: sr_instance_id,
9953: * insert_supplies
9954: *
9955: * DESCRIPTION
9956: * This procedure will take the parameter values and insert a row into
9957: * the table msc_st_supplies
9958: * HISTORY
9959: * M Craig
9960: * 2/10/2000 - Populating Order number column with Wip Entity Name ( porder_no )
9961: * 2/24/2003 - populating Firmed batches Indicator, Qty and Date
9982: vproduct_item_id NUMBER ; /* B2953953 - CoProduct */
9983: BEGIN
9984:
9985: st_supplies :=
9986: ' INSERT INTO msc_st_supplies ( '
9987: ||' plan_id, inventory_item_id, organization_id, sr_instance_id, '
9988: ||' new_schedule_date, old_schedule_date, new_wip_start_date, '
9989: ||' old_wip_start_date, last_unit_completion_date, disposition_id, '
9990: ||' order_type, order_number, new_order_quantity, old_order_quantity, '
10036: 2 ;
10037:
10038: EXCEPTION
10039: WHEN OTHERS THEN
10040: log_message('Failure occured during the insert into msc_st_supplies');
10041: log_message(sqlerrm);
10042: RAISE;
10043:
10044: END insert_supplies;
10241: * NAME
10242: * onhand_inventory
10243: *
10244: * DESCRIPTION
10245: * This procedure will insert records into the table msc_st_supplies
10246: * for the onhand balances in inventory. The insert is split into 3 parts
10247: * one for non-lot controlled, lot controlled, and lot and status
10248: * controlled item. Each inserted will need touse a distnct list from
10249: * the table gmp_item_aps. The table may contain multiple values for
10318: * NAME
10319: * extract_onhand_balances
10320: *
10321: * DESCRIPTION
10322: * This procedure will insert records into the table msc_st_supplies
10323: * for the onhand balances in inventory. The insert is split into 3 parts
10324: * one for non-lot controlled, lot controlled, and lot and status
10325: * controlled item. Each inserted will need touse a distnct list from
10326: * the table gmp_item_aps. The table may contain multiple values for
10699:
10700: insert_count := insert_count - 1;
10701:
10702: FORALL i IN 1..insert_count
10703: INSERT INTO msc_st_supplies
10704: (plan_id,
10705: inventory_item_id,
10706: organization_id,
10707: sr_instance_id,
10883: * NAME
10884: * Extract_inventory_transfer_supplies
10885: *
10886: * DESCRIPTION
10887: * This procedure will insert records into the table msc_st_supplies
10888: * and msc_st_demands for pending inventory transfers.
10889: * HISTORY
10890: * 25-Jan-2003 B1332662 Created New procedure to insert supplies
10891: * Per discussions with APS team the specifics are
10921: CLOSE ex_code_ref;
10922:
10923: return_status := TRUE ;
10924:
10925: v_sql_stmt := 'INSERT into msc_st_supplies ('
10926: || ' plan_id,'
10927: || ' inventory_item_id,'
10928: || ' organization_id,'
10929: || ' sr_instance_id,'