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_SUPPLIER_SPEC_VRS

Line 3172: p_supp_vr IN GMD_SUPPLIER_SPEC_VRS%ROWTYPE

3168: -- End of comments
3169:
3170: PROCEDURE validate_supp_vr
3171: (
3172: p_supp_vr IN GMD_SUPPLIER_SPEC_VRS%ROWTYPE
3173: , p_called_from IN VARCHAR2
3174: , p_operation IN VARCHAR2
3175: , x_return_status OUT NOCOPY VARCHAR2
3176: ) IS

Line 3380: p_supp_vr IN gmd_supplier_spec_vrs%ROWTYPE

3376: -- End of comments
3377:
3378: PROCEDURE check_for_null_and_fks_in_svr
3379: (
3380: p_supp_vr IN gmd_supplier_spec_vrs%ROWTYPE
3381: , p_spec IN gmd_specifications%ROWTYPE
3382: , x_return_status OUT NOCOPY VARCHAR2
3383: )
3384: IS

Line 3691: FUNCTION supp_vr_exist(p_supp_vr GMD_SUPPLIER_SPEC_VRS%ROWTYPE,

3687: --| Plowe 04-Apr-2006 Bug 5117733 - added item revision to match
3688: --+========================================================================+
3689: -- End of comments
3690:
3691: FUNCTION supp_vr_exist(p_supp_vr GMD_SUPPLIER_SPEC_VRS%ROWTYPE,
3692: p_spec GMD_SPECIFICATIONS%ROWTYPE)
3693: RETURN BOOLEAN IS
3694:
3695: CURSOR c_supp_vr IS

Line 3697: FROM gmd_specifications_b s, gmd_supplier_spec_vrs vr

3693: RETURN BOOLEAN IS
3694:
3695: CURSOR c_supp_vr IS
3696: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
3697: FROM gmd_specifications_b s, gmd_supplier_spec_vrs vr
3698: WHERE s.spec_id = vr.spec_id
3699: AND s.owner_organization_id = p_spec.owner_organization_id
3700: AND s.inventory_item_id = p_spec.inventory_item_id
3701: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 4040: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;

4036: x_return_status OUT NOCOPY VARCHAR2,
4037: x_message_data OUT NOCOPY VARCHAR2) IS
4038:
4039: l_progress VARCHAR2(3);
4040: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
4041: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
4042:
4043: BEGIN
4044: l_progress := '010';

Line 4041: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;

4037: x_message_data OUT NOCOPY VARCHAR2) IS
4038:
4039: l_progress VARCHAR2(3);
4040: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
4041: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
4042:
4043: BEGIN
4044: l_progress := '010';
4045: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 4065: IF NOT GMD_Supplier_Spec_VRS_PVT.Fetch_Row(l_supplier_spec_vrs,l_supplier_spec_vrs_out)

4061: END IF;
4062:
4063: -- Fetch the row
4064: -- =============
4065: IF NOT GMD_Supplier_Spec_VRS_PVT.Fetch_Row(l_supplier_spec_vrs,l_supplier_spec_vrs_out)
4066: THEN
4067: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
4068: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
4069: 'l_column_name', 'SPEC_VR_ID',

Line 4068: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',

4064: -- =============
4065: IF NOT GMD_Supplier_Spec_VRS_PVT.Fetch_Row(l_supplier_spec_vrs,l_supplier_spec_vrs_out)
4066: THEN
4067: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
4068: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
4069: 'l_column_name', 'SPEC_VR_ID',
4070: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
4071: RAISE FND_API.G_EXC_ERROR;
4072: END IF;

Line 4081: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',

4077: -- =============================================
4078: IF l_supplier_spec_vrs.delete_mark <> 0
4079: THEN
4080: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
4081: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
4082: 'l_column_name', 'SPEC_VR_ID',
4083: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
4084: RAISE FND_API.G_EXC_ERROR;
4085: END IF;