APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_SPEC_MATCH_MIG_GRP

Line 3775: l_wip_spec_rec GMD_SPEC_MATCH_MIG_GRP.wip_spec_rec_type;

3771: l_supplier_site_id NUMBER;
3772: l_spec_type VARCHAR2(2);
3773: l_message_data VARCHAR2(2000);
3774: l_return_status VARCHAR2(4);
3775: l_wip_spec_rec GMD_SPEC_MATCH_MIG_GRP.wip_spec_rec_type;
3776: l_customer_spec_rec GMD_SPEC_MATCH_MIG_GRP.customer_spec_rec_type;
3777: l_inventory_spec_rec GMD_SPEC_MATCH_MIG_GRP.inventory_spec_rec_type;
3778: l_supplier_spec_rec GMD_SPEC_MATCH_MIG_GRP.supplier_spec_rec_type;
3779:

Line 3776: l_customer_spec_rec GMD_SPEC_MATCH_MIG_GRP.customer_spec_rec_type;

3772: l_spec_type VARCHAR2(2);
3773: l_message_data VARCHAR2(2000);
3774: l_return_status VARCHAR2(4);
3775: l_wip_spec_rec GMD_SPEC_MATCH_MIG_GRP.wip_spec_rec_type;
3776: l_customer_spec_rec GMD_SPEC_MATCH_MIG_GRP.customer_spec_rec_type;
3777: l_inventory_spec_rec GMD_SPEC_MATCH_MIG_GRP.inventory_spec_rec_type;
3778: l_supplier_spec_rec GMD_SPEC_MATCH_MIG_GRP.supplier_spec_rec_type;
3779:
3780: l_lot_no ic_lots_mst.lot_no%TYPE;

Line 3777: l_inventory_spec_rec GMD_SPEC_MATCH_MIG_GRP.inventory_spec_rec_type;

3773: l_message_data VARCHAR2(2000);
3774: l_return_status VARCHAR2(4);
3775: l_wip_spec_rec GMD_SPEC_MATCH_MIG_GRP.wip_spec_rec_type;
3776: l_customer_spec_rec GMD_SPEC_MATCH_MIG_GRP.customer_spec_rec_type;
3777: l_inventory_spec_rec GMD_SPEC_MATCH_MIG_GRP.inventory_spec_rec_type;
3778: l_supplier_spec_rec GMD_SPEC_MATCH_MIG_GRP.supplier_spec_rec_type;
3779:
3780: l_lot_no ic_lots_mst.lot_no%TYPE;
3781: l_sublot_no ic_lots_mst.sublot_no%TYPE;

Line 3778: l_supplier_spec_rec GMD_SPEC_MATCH_MIG_GRP.supplier_spec_rec_type;

3774: l_return_status VARCHAR2(4);
3775: l_wip_spec_rec GMD_SPEC_MATCH_MIG_GRP.wip_spec_rec_type;
3776: l_customer_spec_rec GMD_SPEC_MATCH_MIG_GRP.customer_spec_rec_type;
3777: l_inventory_spec_rec GMD_SPEC_MATCH_MIG_GRP.inventory_spec_rec_type;
3778: l_supplier_spec_rec GMD_SPEC_MATCH_MIG_GRP.supplier_spec_rec_type;
3779:
3780: l_lot_no ic_lots_mst.lot_no%TYPE;
3781: l_sublot_no ic_lots_mst.sublot_no%TYPE;
3782: l_recipe_id NUMBER;

Line 4636: IF NOT (GMD_SPEC_MATCH_MIG_GRP.FIND_WIP_OR_INV_SPEC(

4632: l_wip_spec_rec.lot_id := smpl_rec.lot_id;
4633: l_wip_spec_rec.date_effective := smpl_rec.sample_date;
4634: l_wip_spec_rec.exact_match := 'N';
4635:
4636: IF NOT (GMD_SPEC_MATCH_MIG_GRP.FIND_WIP_OR_INV_SPEC(
4637: p_wip_spec_rec => l_wip_spec_rec,
4638: x_spec_id => l_spec_id,
4639: x_spec_vr_id => l_spec_vr_id,
4640: x_spec_type => l_spec_type,

Line 4661: IF NOT(GMD_SPEC_MATCH_MIG_GRP.FIND_CUST_OR_INV_SPEC(

4657: l_customer_spec_rec.lot_id := smpl_rec.lot_id;
4658: l_customer_spec_rec.look_in_other_orgn := 'N';
4659: l_customer_spec_rec.exact_match := 'N';
4660:
4661: IF NOT(GMD_SPEC_MATCH_MIG_GRP.FIND_CUST_OR_INV_SPEC(
4662: p_customer_spec_rec => l_customer_spec_rec,
4663: x_spec_id => l_spec_id,
4664: x_spec_vr_id => l_spec_vr_id,
4665: x_spec_type => l_spec_type,

Line 4681: IF NOT (GMD_SPEC_MATCH_MIG_GRP.FIND_INVENTORY_SPEC(

4677: l_inventory_spec_rec.location := smpl_rec.location;
4678: l_inventory_spec_rec.date_effective := smpl_rec.sample_date;
4679: l_inventory_spec_rec.exact_match := 'N';
4680:
4681: IF NOT (GMD_SPEC_MATCH_MIG_GRP.FIND_INVENTORY_SPEC(
4682: p_inventory_spec_rec => l_inventory_spec_rec,
4683: x_spec_id => l_spec_id,
4684: x_spec_vr_id => l_spec_vr_id,
4685: x_return_status => l_return_status,

Line 4701: IF NOT (GMD_SPEC_MATCH_MIG_GRP.FIND_SUPPLIER_OR_INV_SPEC(

4697: l_supplier_spec_rec.date_effective := smpl_rec.sample_date;
4698: l_supplier_spec_rec.lot_id := smpl_rec.lot_id;
4699: l_supplier_spec_rec.exact_match := 'N';
4700:
4701: IF NOT (GMD_SPEC_MATCH_MIG_GRP.FIND_SUPPLIER_OR_INV_SPEC(
4702: p_supplier_spec_rec => l_supplier_spec_rec,
4703: x_spec_id => l_spec_id,
4704: x_spec_vr_id => l_spec_vr_id,
4705: x_spec_type => l_spec_type,