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_CUSTOMER_SPEC_VRS

Line 2522: p_cust_vr IN GMD_CUSTOMER_SPEC_VRS%ROWTYPE

2518: -- End of comments
2519:
2520: PROCEDURE validate_cust_vr
2521: (
2522: p_cust_vr IN GMD_CUSTOMER_SPEC_VRS%ROWTYPE
2523: , p_called_from IN VARCHAR2
2524: , p_operation IN VARCHAR2
2525: , x_return_status OUT NOCOPY VARCHAR2
2526: ) IS

Line 2714: p_cust_vr IN gmd_customer_spec_vrs%ROWTYPE

2710: -- End of comments
2711:
2712: PROCEDURE check_for_null_and_fks_in_cvr
2713: (
2714: p_cust_vr IN gmd_customer_spec_vrs%ROWTYPE
2715: , p_spec IN gmd_specifications%ROWTYPE
2716: , x_return_status OUT NOCOPY VARCHAR2
2717: )
2718: IS

Line 3057: FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,

3053: --| Plowe 04-Apr-2006 Bug 5117733 - added item revision to match
3054: --+========================================================================+
3055: -- End of comments
3056:
3057: FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,
3058: p_spec GMD_SPECIFICATIONS%ROWTYPE)
3059: RETURN BOOLEAN IS
3060:
3061: CURSOR c_cust_vr IS

Line 3063: FROM gmd_specifications_b s, gmd_customer_spec_vrs vr

3059: RETURN BOOLEAN IS
3060:
3061: CURSOR c_cust_vr IS
3062: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
3063: FROM gmd_specifications_b s, gmd_customer_spec_vrs vr
3064: WHERE s.spec_id = vr.spec_id
3065: AND s.owner_organization_id = p_spec.owner_organization_id
3066: AND s.inventory_item_id = p_spec.inventory_item_id
3067: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 3957: l_customer_spec_vrs GMD_CUSTOMER_SPEC_VRS%ROWTYPE;

3953: x_return_status OUT NOCOPY VARCHAR2,
3954: x_message_data OUT NOCOPY VARCHAR2) IS
3955:
3956: l_progress VARCHAR2(3);
3957: l_customer_spec_vrs GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
3958: l_customer_spec_vrs_out GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
3959:
3960: BEGIN
3961: l_progress := '010';

Line 3958: l_customer_spec_vrs_out GMD_CUSTOMER_SPEC_VRS%ROWTYPE;

3954: x_message_data OUT NOCOPY VARCHAR2) IS
3955:
3956: l_progress VARCHAR2(3);
3957: l_customer_spec_vrs GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
3958: l_customer_spec_vrs_out GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
3959:
3960: BEGIN
3961: l_progress := '010';
3962: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 3982: IF NOT GMD_Customer_Spec_VRS_PVT.Fetch_Row(l_customer_spec_vrs,l_customer_spec_vrs_out)

3978: END IF;
3979:
3980: -- Fetch the row
3981: -- =============
3982: IF NOT GMD_Customer_Spec_VRS_PVT.Fetch_Row(l_customer_spec_vrs,l_customer_spec_vrs_out)
3983: THEN
3984: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
3985: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',
3986: 'l_column_name', 'SPEC_VR_ID',

Line 3985: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',

3981: -- =============
3982: IF NOT GMD_Customer_Spec_VRS_PVT.Fetch_Row(l_customer_spec_vrs,l_customer_spec_vrs_out)
3983: THEN
3984: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
3985: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',
3986: 'l_column_name', 'SPEC_VR_ID',
3987: 'l_key_value', l_customer_spec_vrs.spec_vr_id);
3988: RAISE FND_API.G_EXC_ERROR;
3989: END IF;

Line 3998: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',

3994: -- =============================================
3995: IF l_customer_spec_vrs.delete_mark <> 0
3996: THEN
3997: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
3998: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',
3999: 'l_column_name', 'SPEC_VR_ID',
4000: 'l_key_value', l_customer_spec_vrs.spec_vr_id);
4001: RAISE FND_API.G_EXC_ERROR;
4002: END IF;