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 2671: p_cust_vr IN GMD_CUSTOMER_SPEC_VRS%ROWTYPE

2667: -- End of comments
2668:
2669: PROCEDURE validate_cust_vr
2670: (
2671: p_cust_vr IN GMD_CUSTOMER_SPEC_VRS%ROWTYPE
2672: , p_called_from IN VARCHAR2
2673: , p_operation IN VARCHAR2
2674: , x_return_status OUT NOCOPY VARCHAR2
2675: ) IS

Line 2863: p_cust_vr IN gmd_customer_spec_vrs%ROWTYPE

2859: -- End of comments
2860:
2861: PROCEDURE check_for_null_and_fks_in_cvr
2862: (
2863: p_cust_vr IN gmd_customer_spec_vrs%ROWTYPE
2864: , p_spec IN gmd_specifications%ROWTYPE
2865: , x_return_status OUT NOCOPY VARCHAR2
2866: )
2867: IS

Line 3207: FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,

3203: --| Plowe 04-Apr-2006 Bug 5117733 - added item revision to match
3204: --+========================================================================+
3205: -- End of comments
3206:
3207: FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,
3208: p_spec GMD_SPECIFICATIONS%ROWTYPE)
3209: RETURN BOOLEAN IS
3210:
3211: CURSOR c_cust_vr IS

Line 3213: FROM gmd_specifications_b s, gmd_customer_spec_vrs vr

3209: RETURN BOOLEAN IS
3210:
3211: CURSOR c_cust_vr IS
3212: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
3213: FROM gmd_specifications_b s, gmd_customer_spec_vrs vr
3214: WHERE s.spec_id = vr.spec_id
3215: AND s.owner_organization_id = p_spec.owner_organization_id
3216: AND s.inventory_item_id = p_spec.inventory_item_id
3217: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 4120: l_customer_spec_vrs GMD_CUSTOMER_SPEC_VRS%ROWTYPE;

4116: x_return_status OUT NOCOPY VARCHAR2,
4117: x_message_data OUT NOCOPY VARCHAR2) IS
4118:
4119: l_progress VARCHAR2(3);
4120: l_customer_spec_vrs GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
4121: l_customer_spec_vrs_out GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
4122:
4123: BEGIN
4124: l_progress := '010';

Line 4121: l_customer_spec_vrs_out GMD_CUSTOMER_SPEC_VRS%ROWTYPE;

4117: x_message_data OUT NOCOPY VARCHAR2) IS
4118:
4119: l_progress VARCHAR2(3);
4120: l_customer_spec_vrs GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
4121: l_customer_spec_vrs_out GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
4122:
4123: BEGIN
4124: l_progress := '010';
4125: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

4141: END IF;
4142:
4143: -- Fetch the row
4144: -- =============
4145: IF NOT GMD_Customer_Spec_VRS_PVT.Fetch_Row(l_customer_spec_vrs,l_customer_spec_vrs_out)
4146: THEN
4147: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
4148: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',
4149: 'l_column_name', 'SPEC_VR_ID',

Line 4148: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',

4144: -- =============
4145: IF NOT GMD_Customer_Spec_VRS_PVT.Fetch_Row(l_customer_spec_vrs,l_customer_spec_vrs_out)
4146: THEN
4147: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
4148: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',
4149: 'l_column_name', 'SPEC_VR_ID',
4150: 'l_key_value', l_customer_spec_vrs.spec_vr_id);
4151: RAISE FND_API.G_EXC_ERROR;
4152: END IF;

Line 4161: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',

4157: -- =============================================
4158: IF l_customer_spec_vrs.delete_mark <> 0
4159: THEN
4160: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
4161: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',
4162: 'l_column_name', 'SPEC_VR_ID',
4163: 'l_key_value', l_customer_spec_vrs.spec_vr_id);
4164: RAISE FND_API.G_EXC_ERROR;
4165: END IF;