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_WIP_SPEC_VRS

Line 1300: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE

1296: -- End of comments
1297:
1298: PROCEDURE validate_wip_vr
1299: (
1300: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
1301: , p_called_from IN VARCHAR2
1302: , p_operation IN VARCHAR2
1303: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
1304: , x_return_status OUT NOCOPY VARCHAR2

Line 1303: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE

1299: (
1300: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
1301: , p_called_from IN VARCHAR2
1302: , p_operation IN VARCHAR2
1303: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
1304: , x_return_status OUT NOCOPY VARCHAR2
1305: ) IS
1306:
1307: -- Local Variables

Line 1313: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;

1309: l_return_status VARCHAR2(1);
1310:
1311: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1312: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1313: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;
1314: l_wip_vr_tmp GMD_WIP_SPEC_VRS%ROWTYPE;
1315: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
1316: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
1317: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

Line 1314: l_wip_vr_tmp GMD_WIP_SPEC_VRS%ROWTYPE;

1310:
1311: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1312: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1313: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;
1314: l_wip_vr_tmp GMD_WIP_SPEC_VRS%ROWTYPE;
1315: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
1316: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
1317: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
1318: l_inventory_item_id NUMBER;

Line 1531: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE

1527: -- End of comments
1528:
1529: PROCEDURE check_for_null_and_fks_in_wvr
1530: (
1531: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
1532: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
1533: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
1534: , x_return_status OUT NOCOPY VARCHAR2
1535: )

Line 1533: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE

1529: PROCEDURE check_for_null_and_fks_in_wvr
1530: (
1531: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
1532: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
1533: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
1534: , x_return_status OUT NOCOPY VARCHAR2
1535: )
1536: IS
1537:

Line 1538: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;

1534: , x_return_status OUT NOCOPY VARCHAR2
1535: )
1536: IS
1537:
1538: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;
1539: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1540:
1541: -- bug 4924483 sql id 14687134 MJC take out org_access_view as not used in query
1542: -- bug 5223014 - sql id 17532478 NO change required as added created an index on Organization_Id

Line 1787: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;

1783: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
1784: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
1785: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1786: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1787: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1788: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1789: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;
1790: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;
1791:

Line 2383: FUNCTION wip_vr_exist(p_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE,

2379: --| Plowe 04-Apr-2006 Bug 5117733 - added item revision to match
2380: --+========================================================================+
2381: -- End of comments
2382:
2383: FUNCTION wip_vr_exist(p_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE,
2384: p_spec GMD_SPECIFICATIONS%ROWTYPE)
2385: RETURN BOOLEAN IS
2386:
2387: -- added material detail to cursor

Line 2391: gmd_wip_spec_vrs vr

2387: -- added material detail to cursor
2388: CURSOR c_wip_vr IS
2389: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
2390: FROM gmd_specifications_b s,
2391: gmd_wip_spec_vrs vr
2392: WHERE s.spec_id = vr.spec_id
2393: AND s.owner_organization_id = p_spec.owner_organization_id
2394: AND s.inventory_item_id = p_spec.inventory_item_id
2395: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 3874: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;

3870: x_message_data OUT NOCOPY VARCHAR2) IS
3871:
3872: l_progress VARCHAR2(3);
3873: l_temp VARCHAR2(1);
3874: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;
3875: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;
3876:
3877: BEGIN
3878: l_progress := '010';

Line 3875: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;

3871:
3872: l_progress VARCHAR2(3);
3873: l_temp VARCHAR2(1);
3874: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;
3875: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;
3876:
3877: BEGIN
3878: l_progress := '010';
3879: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 3899: IF NOT GMD_WIP_Spec_VRS_PVT.Fetch_Row(l_wip_spec_vrs,l_wip_spec_vrs_out)

3895: END IF;
3896:
3897: -- Fetch the row
3898: -- =============
3899: IF NOT GMD_WIP_Spec_VRS_PVT.Fetch_Row(l_wip_spec_vrs,l_wip_spec_vrs_out)
3900: THEN
3901: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
3902: 'l_table_name', 'GMD_WIP_SPEC_VRS',
3903: 'l_column_name', 'SPEC_VR_ID',

Line 3902: 'l_table_name', 'GMD_WIP_SPEC_VRS',

3898: -- =============
3899: IF NOT GMD_WIP_Spec_VRS_PVT.Fetch_Row(l_wip_spec_vrs,l_wip_spec_vrs_out)
3900: THEN
3901: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
3902: 'l_table_name', 'GMD_WIP_SPEC_VRS',
3903: 'l_column_name', 'SPEC_VR_ID',
3904: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
3905: RAISE FND_API.G_EXC_ERROR;
3906: END IF;

Line 3915: 'l_table_name', 'GMD_WIP_SPEC_VRS',

3911: -- =============================================
3912: IF l_wip_spec_vrs.delete_mark <> 0
3913: THEN
3914: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
3915: 'l_table_name', 'GMD_WIP_SPEC_VRS',
3916: 'l_column_name', 'SPEC_VR_ID',
3917: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
3918: RAISE FND_API.G_EXC_ERROR;
3919: END IF;