eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_SPECIFICATIONS

Line 156: l_spec GMD_SPECIFICATIONS%ROWTYPE;

152: -- Local Variables
153: dummy NUMBER;
154: l_return_status VARCHAR2(1);
155:
156: l_spec GMD_SPECIFICATIONS%ROWTYPE;
157: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
158: l_mon_vr GMD_MONITORING_SPEC_VRS%ROWTYPE;
159: l_mon_vr_tmp GMD_MONITORING_SPEC_VRS%ROWTYPE;
160: l_item_mst IC_ITEM_MST%ROWTYPE;

Line 157: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;

153: dummy NUMBER;
154: l_return_status VARCHAR2(1);
155:
156: l_spec GMD_SPECIFICATIONS%ROWTYPE;
157: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
158: l_mon_vr GMD_MONITORING_SPEC_VRS%ROWTYPE;
159: l_mon_vr_tmp GMD_MONITORING_SPEC_VRS%ROWTYPE;
160: l_item_mst IC_ITEM_MST%ROWTYPE;
161: l_item_mst_out IC_ITEM_MST%ROWTYPE;

Line 182: IF NOT (GMD_Specifications_PVT.Fetch_Row(

178: END IF;
179:
180: -- Verify that the specification exists.
181: l_spec.spec_id := p_mon_vr.spec_id;
182: IF NOT (GMD_Specifications_PVT.Fetch_Row(
183: p_specifications => l_spec,
184: x_specifications => l_spec_out)
185: ) THEN
186: -- Fetch Error

Line 307: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE

303:
304: PROCEDURE check_for_null_and_fks_in_mvr
305: (
306: p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE
307: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
308: , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE
309: , x_return_status OUT NOCOPY VARCHAR2
310: )
311: IS

Line 571: p_spec GMD_SPECIFICATIONS%ROWTYPE)

567: --+========================================================================+
568: -- End of comments
569:
570: FUNCTION mon_vr_exist(p_mon_vr GMD_MONITORING_SPEC_VRS%ROWTYPE,
571: p_spec GMD_SPECIFICATIONS%ROWTYPE)
572: RETURN BOOLEAN IS
573:
574: CURSOR c_mon_vr IS
575: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers

Line 576: FROM gmd_specifications_b s, gmd_monitoring_spec_vrs vr

572: RETURN BOOLEAN IS
573:
574: CURSOR c_mon_vr IS
575: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
576: FROM gmd_specifications_b s, gmd_monitoring_spec_vrs vr
577: WHERE s.spec_id = vr.spec_id
578: AND ((s.grade_code is NULL AND p_spec.grade_code is NULL) OR
579: (s.grade_code = p_spec.grade_code)
580: )

Line 693: l_spec GMD_SPECIFICATIONS%ROWTYPE;

689: -- Local Variables
690: dummy NUMBER;
691: l_return_status VARCHAR2(1);
692:
693: l_spec GMD_SPECIFICATIONS%ROWTYPE;
694: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
695: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
696: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;
697: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;

Line 694: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;

690: dummy NUMBER;
691: l_return_status VARCHAR2(1);
692:
693: l_spec GMD_SPECIFICATIONS%ROWTYPE;
694: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
695: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
696: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;
697: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
698: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;

Line 721: IF NOT (GMD_Specifications_PVT.Fetch_Row(

717: END IF;
718:
719: -- Verify that the specification exists.
720: l_spec.spec_id := p_inv_vr.spec_id;
721: IF NOT (GMD_Specifications_PVT.Fetch_Row(
722: p_specifications => l_spec,
723: x_specifications => l_spec_out)
724: ) THEN
725: -- Fetch Error

Line 808: gmd_specifications WHERE spec_id = p_inv_vr.spec_id;

804:
805: -- Sample Quantity UOM must be convertible to Item's UOM
806: BEGIN
807: SELECT inventory_item_id INTO l_inventory_item_id FROM
808: gmd_specifications WHERE spec_id = p_inv_vr.spec_id;
809: SELECT owner_organization_id INTO l_organization_id FROM
810: gmd_specifications WHERE spec_id = p_inv_vr.spec_id;
811: SELECT * INTO l_item_mst
812: FROM mtl_system_items_b

Line 810: gmd_specifications WHERE spec_id = p_inv_vr.spec_id;

806: BEGIN
807: SELECT inventory_item_id INTO l_inventory_item_id FROM
808: gmd_specifications WHERE spec_id = p_inv_vr.spec_id;
809: SELECT owner_organization_id INTO l_organization_id FROM
810: gmd_specifications WHERE spec_id = p_inv_vr.spec_id;
811: SELECT * INTO l_item_mst
812: FROM mtl_system_items_b
813: WHERE inventory_item_id = l_inventory_item_id
814: AND organization_id = l_organization_id;

Line 930: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE

926:
927: PROCEDURE check_for_null_and_fks_in_ivr
928: (
929: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
930: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
931: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
932: , x_return_status OUT NOCOPY VARCHAR2
933: )
934: IS

Line 937: l_spec GMD_SPECIFICATIONS%ROWTYPE;

933: )
934: IS
935:
936: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
937: l_spec GMD_SPECIFICATIONS%ROWTYPE;
938:
939: CURSOR c_item_lot_number IS
940: SELECT 1
941: FROM mtl_lot_numbers

Line 1217: p_spec GMD_SPECIFICATIONS%ROWTYPE)

1213: --+========================================================================+
1214: -- End of comments
1215:
1216: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,
1217: p_spec GMD_SPECIFICATIONS%ROWTYPE)
1218: RETURN BOOLEAN IS
1219:
1220: CURSOR c_inv_vr IS
1221: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers

Line 1222: FROM gmd_specifications_b s, gmd_inventory_spec_vrs vr

1218: RETURN BOOLEAN IS
1219:
1220: CURSOR c_inv_vr IS
1221: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
1222: FROM gmd_specifications_b s, gmd_inventory_spec_vrs vr
1223: WHERE s.spec_id = vr.spec_id
1224: AND s.owner_organization_id = p_spec.owner_organization_id
1225: AND s.inventory_item_id = p_spec.inventory_item_id
1226: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 1336: l_spec GMD_SPECIFICATIONS%ROWTYPE;

1332: -- Local Variables
1333: dummy NUMBER;
1334: l_return_status VARCHAR2(1);
1335:
1336: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1337: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1338: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;
1339: l_wip_vr_tmp GMD_WIP_SPEC_VRS%ROWTYPE;
1340: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;

Line 1337: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;

1333: dummy NUMBER;
1334: l_return_status VARCHAR2(1);
1335:
1336: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1337: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1338: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;
1339: l_wip_vr_tmp GMD_WIP_SPEC_VRS%ROWTYPE;
1340: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
1341: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;

Line 1364: IF NOT (GMD_Specifications_PVT.Fetch_Row(

1360: END IF;
1361:
1362: -- Verify that the specification exists.
1363: l_spec.spec_id := p_wip_vr.spec_id;
1364: IF NOT (GMD_Specifications_PVT.Fetch_Row(
1365: p_specifications => l_spec,
1366: x_specifications => l_spec_out)
1367: ) THEN
1368: -- Fetch Error

Line 1450: gmd_specifications WHERE spec_id = p_wip_vr.spec_id;

1446:
1447: -- Sample Quantity UOM must be convertible to Item's UOM
1448: BEGIN
1449: SELECT inventory_item_id INTO l_inventory_item_id FROM
1450: gmd_specifications WHERE spec_id = p_wip_vr.spec_id;
1451: SELECT owner_organization_id INTO l_organization_id FROM
1452: gmd_specifications WHERE spec_id = p_wip_vr.spec_id;
1453: SELECT * INTO l_item_mst
1454: FROM mtl_system_items_b

Line 1452: gmd_specifications WHERE spec_id = p_wip_vr.spec_id;

1448: BEGIN
1449: SELECT inventory_item_id INTO l_inventory_item_id FROM
1450: gmd_specifications WHERE spec_id = p_wip_vr.spec_id;
1451: SELECT owner_organization_id INTO l_organization_id FROM
1452: gmd_specifications WHERE spec_id = p_wip_vr.spec_id;
1453: SELECT * INTO l_item_mst
1454: FROM mtl_system_items_b
1455: WHERE inventory_item_id = l_inventory_item_id
1456: AND organization_id = l_organization_id;

Line 1573: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE

1569:
1570: PROCEDURE check_for_null_and_fks_in_wvr
1571: (
1572: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
1573: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
1574: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
1575: , x_return_status OUT NOCOPY VARCHAR2
1576: )
1577: IS

Line 1580: l_spec GMD_SPECIFICATIONS%ROWTYPE;

1576: )
1577: IS
1578:
1579: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;
1580: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1581:
1582: -- bug 4924483 sql id 14687134 MJC take out org_access_view as not used in query
1583: -- bug 5223014 - sql id 17532478 NO change required as added created an index on Organization_Id
1584: -- to stop FTS on gmd_parameters_hdr

Line 2533: p_spec GMD_SPECIFICATIONS%ROWTYPE)

2529: --+========================================================================+
2530: -- End of comments
2531:
2532: FUNCTION wip_vr_exist(p_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE,
2533: p_spec GMD_SPECIFICATIONS%ROWTYPE)
2534: RETURN BOOLEAN IS
2535:
2536: -- added material detail to cursor
2537: CURSOR c_wip_vr IS

Line 2539: FROM gmd_specifications_b s,

2535:
2536: -- added material detail to cursor
2537: CURSOR c_wip_vr IS
2538: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
2539: FROM gmd_specifications_b s,
2540: gmd_wip_spec_vrs vr
2541: WHERE s.spec_id = vr.spec_id
2542: AND s.owner_organization_id = p_spec.owner_organization_id
2543: AND s.inventory_item_id = p_spec.inventory_item_id

Line 2681: l_spec GMD_SPECIFICATIONS%ROWTYPE;

2677: -- Local Variables
2678: dummy NUMBER;
2679: l_return_status VARCHAR2(1);
2680:
2681: l_spec GMD_SPECIFICATIONS%ROWTYPE;
2682: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
2683: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
2684: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
2685: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

Line 2682: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;

2678: dummy NUMBER;
2679: l_return_status VARCHAR2(1);
2680:
2681: l_spec GMD_SPECIFICATIONS%ROWTYPE;
2682: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
2683: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
2684: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
2685: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
2686: l_inventory_item_id NUMBER;

Line 2707: IF NOT (GMD_Specifications_PVT.Fetch_Row(

2703: END IF;
2704:
2705: -- Verify that the specification exists.
2706: l_spec.spec_id := p_cust_vr.spec_id;
2707: IF NOT (GMD_Specifications_PVT.Fetch_Row(
2708: p_specifications => l_spec,
2709: x_specifications => l_spec_out)
2710: ) THEN
2711: -- Fetch Error

Line 2767: gmd_specifications WHERE spec_id = p_cust_vr.spec_id;

2763:
2764: -- Sample Quantity UOM must be convertible to Item's UOM
2765: BEGIN
2766: SELECT inventory_item_id INTO l_inventory_item_id FROM
2767: gmd_specifications WHERE spec_id = p_cust_vr.spec_id;
2768: SELECT owner_organization_id INTO l_organization_id FROM
2769: gmd_specifications WHERE spec_id = p_cust_vr.spec_id;
2770: SELECT * INTO l_item_mst
2771: FROM mtl_system_items_b

Line 2769: gmd_specifications WHERE spec_id = p_cust_vr.spec_id;

2765: BEGIN
2766: SELECT inventory_item_id INTO l_inventory_item_id FROM
2767: gmd_specifications WHERE spec_id = p_cust_vr.spec_id;
2768: SELECT owner_organization_id INTO l_organization_id FROM
2769: gmd_specifications WHERE spec_id = p_cust_vr.spec_id;
2770: SELECT * INTO l_item_mst
2771: FROM mtl_system_items_b
2772: WHERE inventory_item_id = l_inventory_item_id
2773: AND organization_id = l_organization_id;

Line 2864: , p_spec IN gmd_specifications%ROWTYPE

2860:
2861: PROCEDURE check_for_null_and_fks_in_cvr
2862: (
2863: p_cust_vr IN gmd_customer_spec_vrs%ROWTYPE
2864: , p_spec IN gmd_specifications%ROWTYPE
2865: , x_return_status OUT NOCOPY VARCHAR2
2866: )
2867: IS
2868:

Line 3208: p_spec GMD_SPECIFICATIONS%ROWTYPE)

3204: --+========================================================================+
3205: -- End of comments
3206:
3207: FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,
3208: p_spec GMD_SPECIFICATIONS%ROWTYPE)
3209: RETURN BOOLEAN IS
3210:
3211: CURSOR c_cust_vr IS
3212: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers

Line 3213: FROM gmd_specifications_b s, gmd_customer_spec_vrs vr

3209: RETURN BOOLEAN IS
3210:
3211: CURSOR c_cust_vr IS
3212: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
3213: FROM gmd_specifications_b s, gmd_customer_spec_vrs vr
3214: WHERE s.spec_id = vr.spec_id
3215: AND s.owner_organization_id = p_spec.owner_organization_id
3216: AND s.inventory_item_id = p_spec.inventory_item_id
3217: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 3332: l_spec GMD_SPECIFICATIONS%ROWTYPE;

3328: -- Local Variables
3329: dummy NUMBER;
3330: l_return_status VARCHAR2(1);
3331:
3332: l_spec GMD_SPECIFICATIONS%ROWTYPE;
3333: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
3334: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
3335: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
3336: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

Line 3333: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;

3329: dummy NUMBER;
3330: l_return_status VARCHAR2(1);
3331:
3332: l_spec GMD_SPECIFICATIONS%ROWTYPE;
3333: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
3334: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
3335: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
3336: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
3337: l_inventory_item_id NUMBER;

Line 3358: IF NOT (GMD_Specifications_PVT.Fetch_Row(

3354: END IF;
3355:
3356: -- Verify that the specification exists.
3357: l_spec.spec_id := p_supp_vr.spec_id;
3358: IF NOT (GMD_Specifications_PVT.Fetch_Row(
3359: p_specifications => l_spec,
3360: x_specifications => l_spec_out)
3361: ) THEN
3362: -- Fetch Error

Line 3434: gmd_specifications WHERE spec_id = p_supp_vr.spec_id;

3430:
3431: -- Sample Quantity UOM must be convertible to Item's UOM
3432: BEGIN
3433: SELECT inventory_item_id INTO l_inventory_item_id FROM
3434: gmd_specifications WHERE spec_id = p_supp_vr.spec_id;
3435: SELECT owner_organization_id INTO l_organization_id FROM
3436: gmd_specifications WHERE spec_id = p_supp_vr.spec_id;
3437: SELECT * INTO l_item_mst
3438: FROM mtl_system_items_b

Line 3436: gmd_specifications WHERE spec_id = p_supp_vr.spec_id;

3432: BEGIN
3433: SELECT inventory_item_id INTO l_inventory_item_id FROM
3434: gmd_specifications WHERE spec_id = p_supp_vr.spec_id;
3435: SELECT owner_organization_id INTO l_organization_id FROM
3436: gmd_specifications WHERE spec_id = p_supp_vr.spec_id;
3437: SELECT * INTO l_item_mst
3438: FROM mtl_system_items_b
3439: WHERE inventory_item_id = l_inventory_item_id
3440: AND organization_id = l_organization_id;

Line 3531: , p_spec IN gmd_specifications%ROWTYPE

3527:
3528: PROCEDURE check_for_null_and_fks_in_svr
3529: (
3530: p_supp_vr IN gmd_supplier_spec_vrs%ROWTYPE
3531: , p_spec IN gmd_specifications%ROWTYPE
3532: , x_return_status OUT NOCOPY VARCHAR2
3533: )
3534: IS
3535:

Line 3855: p_spec GMD_SPECIFICATIONS%ROWTYPE)

3851: --+========================================================================+
3852: -- End of comments
3853:
3854: FUNCTION supp_vr_exist(p_supp_vr GMD_SUPPLIER_SPEC_VRS%ROWTYPE,
3855: p_spec GMD_SPECIFICATIONS%ROWTYPE)
3856: RETURN BOOLEAN IS
3857:
3858: CURSOR c_supp_vr IS
3859: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers

Line 3860: FROM gmd_specifications_b s, gmd_supplier_spec_vrs vr

3856: RETURN BOOLEAN IS
3857:
3858: CURSOR c_supp_vr IS
3859: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
3860: FROM gmd_specifications_b s, gmd_supplier_spec_vrs vr
3861: WHERE s.spec_id = vr.spec_id
3862: AND s.owner_organization_id = p_spec.owner_organization_id
3863: AND s.inventory_item_id = p_spec.inventory_item_id
3864: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733