APPS.GMD_SPEC_VRS_GRP dependencies on GMD_SUPPLIER_SPEC_VRS

Line 3322: p_supp_vr IN GMD_SUPPLIER_SPEC_VRS%ROWTYPE

3318: -- End of comments
3319:
3320: PROCEDURE validate_supp_vr
3321: (
3322: p_supp_vr IN GMD_SUPPLIER_SPEC_VRS%ROWTYPE
3323: , p_called_from IN VARCHAR2
3324: , p_operation IN VARCHAR2
3325: , x_return_status OUT NOCOPY VARCHAR2
3326: ) IS

Line 3530: p_supp_vr IN gmd_supplier_spec_vrs%ROWTYPE

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

Line 3854: FUNCTION supp_vr_exist(p_supp_vr GMD_SUPPLIER_SPEC_VRS%ROWTYPE,

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

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

Line 4203: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;

4199: x_return_status OUT NOCOPY VARCHAR2,
4200: x_message_data OUT NOCOPY VARCHAR2) IS
4201:
4202: l_progress VARCHAR2(3);
4203: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
4204: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
4205:
4206: BEGIN
4207: l_progress := '010';

Line 4204: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;

4200: x_message_data OUT NOCOPY VARCHAR2) IS
4201:
4202: l_progress VARCHAR2(3);
4203: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
4204: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
4205:
4206: BEGIN
4207: l_progress := '010';
4208: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

4224: END IF;
4225:
4226: -- Fetch the row
4227: -- =============
4228: IF NOT GMD_Supplier_Spec_VRS_PVT.Fetch_Row(l_supplier_spec_vrs,l_supplier_spec_vrs_out)
4229: THEN
4230: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
4231: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
4232: 'l_column_name', 'SPEC_VR_ID',

Line 4231: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',

4227: -- =============
4228: IF NOT GMD_Supplier_Spec_VRS_PVT.Fetch_Row(l_supplier_spec_vrs,l_supplier_spec_vrs_out)
4229: THEN
4230: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
4231: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
4232: 'l_column_name', 'SPEC_VR_ID',
4233: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
4234: RAISE FND_API.G_EXC_ERROR;
4235: END IF;

Line 4244: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',

4240: -- =============================================
4241: IF l_supplier_spec_vrs.delete_mark <> 0
4242: THEN
4243: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
4244: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
4245: 'l_column_name', 'SPEC_VR_ID',
4246: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
4247: RAISE FND_API.G_EXC_ERROR;
4248: END IF;