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.

[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_WIP_SPEC_VRS

Line 1325: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE

1321: -- End of comments
1322:
1323: PROCEDURE validate_wip_vr
1324: (
1325: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
1326: , p_called_from IN VARCHAR2
1327: , p_operation IN VARCHAR2
1328: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
1329: , x_return_status OUT NOCOPY VARCHAR2

Line 1328: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE

1324: (
1325: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
1326: , p_called_from IN VARCHAR2
1327: , p_operation IN VARCHAR2
1328: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
1329: , x_return_status OUT NOCOPY VARCHAR2
1330: ) IS
1331:
1332: -- Local Variables

Line 1338: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;

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;
1342: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

Line 1339: l_wip_vr_tmp GMD_WIP_SPEC_VRS%ROWTYPE;

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;
1342: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
1343: l_inventory_item_id NUMBER;

Line 1572: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE

1568: -- End of comments
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: )

Line 1574: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE

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
1578:

Line 1579: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;

1575: , x_return_status OUT NOCOPY VARCHAR2
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

Line 1886: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;

1882: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
1883: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
1884: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1885: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1886: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1887: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1888: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;
1889: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;
1890:

Line 2532: FUNCTION wip_vr_exist(p_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE,

2528: --| Plowe 04-Apr-2006 Bug 5117733 - added item revision to match
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

Line 2540: gmd_wip_spec_vrs vr

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
2544: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 4037: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;

4033: x_message_data OUT NOCOPY VARCHAR2) IS
4034:
4035: l_progress VARCHAR2(3);
4036: l_temp VARCHAR2(1);
4037: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;
4038: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;
4039:
4040: BEGIN
4041: l_progress := '010';

Line 4038: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;

4034:
4035: l_progress VARCHAR2(3);
4036: l_temp VARCHAR2(1);
4037: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;
4038: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;
4039:
4040: BEGIN
4041: l_progress := '010';
4042: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

4058: END IF;
4059:
4060: -- Fetch the row
4061: -- =============
4062: IF NOT GMD_WIP_Spec_VRS_PVT.Fetch_Row(l_wip_spec_vrs,l_wip_spec_vrs_out)
4063: THEN
4064: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
4065: 'l_table_name', 'GMD_WIP_SPEC_VRS',
4066: 'l_column_name', 'SPEC_VR_ID',

Line 4065: 'l_table_name', 'GMD_WIP_SPEC_VRS',

4061: -- =============
4062: IF NOT GMD_WIP_Spec_VRS_PVT.Fetch_Row(l_wip_spec_vrs,l_wip_spec_vrs_out)
4063: THEN
4064: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
4065: 'l_table_name', 'GMD_WIP_SPEC_VRS',
4066: 'l_column_name', 'SPEC_VR_ID',
4067: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
4068: RAISE FND_API.G_EXC_ERROR;
4069: END IF;

Line 4078: 'l_table_name', 'GMD_WIP_SPEC_VRS',

4074: -- =============================================
4075: IF l_wip_spec_vrs.delete_mark <> 0
4076: THEN
4077: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
4078: 'l_table_name', 'GMD_WIP_SPEC_VRS',
4079: 'l_column_name', 'SPEC_VR_ID',
4080: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
4081: RAISE FND_API.G_EXC_ERROR;
4082: END IF;