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_INVENTORY_SPEC_VRS

Line 671: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE

667: -- End of comments
668:
669: PROCEDURE validate_inv_vr
670: (
671: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
672: , p_called_from IN VARCHAR2
673: , p_operation IN VARCHAR2
674: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
675: , x_return_status OUT NOCOPY VARCHAR2

Line 674: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE

670: (
671: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
672: , p_called_from IN VARCHAR2
673: , p_operation IN VARCHAR2
674: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
675: , x_return_status OUT NOCOPY VARCHAR2
676: ) IS
677:
678: -- Local Variables

Line 684: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;

680: l_return_status VARCHAR2(1);
681:
682: l_spec GMD_SPECIFICATIONS%ROWTYPE;
683: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
684: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
685: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;
686: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
687: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
688: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

Line 685: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;

681:
682: l_spec GMD_SPECIFICATIONS%ROWTYPE;
683: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
684: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
685: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;
686: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
687: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
688: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
689: l_inventory_item_id NUMBER;

Line 918: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE

914: -- End of comments
915:
916: PROCEDURE check_for_null_and_fks_in_ivr
917: (
918: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
919: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
920: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
921: , x_return_status OUT NOCOPY VARCHAR2
922: )

Line 920: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE

916: PROCEDURE check_for_null_and_fks_in_ivr
917: (
918: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
919: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
920: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
921: , x_return_status OUT NOCOPY VARCHAR2
922: )
923: IS
924:

Line 925: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;

921: , x_return_status OUT NOCOPY VARCHAR2
922: )
923: IS
924:
925: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
926: l_spec GMD_SPECIFICATIONS%ROWTYPE;
927:
928: CURSOR c_item_lot_number IS
929: SELECT 1

Line 1191: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,

1187: --| Plowe 04-Apr-2006 Bug 5117733 - added item revision to match
1188: --+========================================================================+
1189: -- End of comments
1190:
1191: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,
1192: p_spec GMD_SPECIFICATIONS%ROWTYPE)
1193: RETURN BOOLEAN IS
1194:
1195: CURSOR c_inv_vr IS

Line 1197: FROM gmd_specifications_b s, gmd_inventory_spec_vrs vr

1193: RETURN BOOLEAN IS
1194:
1195: CURSOR c_inv_vr IS
1196: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
1197: FROM gmd_specifications_b s, gmd_inventory_spec_vrs vr
1198: WHERE s.spec_id = vr.spec_id
1199: AND s.owner_organization_id = p_spec.owner_organization_id
1200: AND s.inventory_item_id = p_spec.inventory_item_id
1201: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 3790: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;

3786: x_message_data OUT NOCOPY VARCHAR2) IS
3787:
3788: l_progress VARCHAR2(3);
3789: l_temp VARCHAR2(1);
3790: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;
3791: l_inventory_spec_vrs_out GMD_INVENTORY_SPEC_VRS%ROWTYPE;
3792:
3793: BEGIN
3794: l_progress := '010';

Line 3791: l_inventory_spec_vrs_out GMD_INVENTORY_SPEC_VRS%ROWTYPE;

3787:
3788: l_progress VARCHAR2(3);
3789: l_temp VARCHAR2(1);
3790: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;
3791: l_inventory_spec_vrs_out GMD_INVENTORY_SPEC_VRS%ROWTYPE;
3792:
3793: BEGIN
3794: l_progress := '010';
3795: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 3815: IF NOT GMD_Inventory_Spec_VRS_PVT.Fetch_Row(l_inventory_spec_vrs,l_inventory_spec_vrs_out)

3811: END IF;
3812:
3813: -- Fetch the row
3814: -- =============
3815: IF NOT GMD_Inventory_Spec_VRS_PVT.Fetch_Row(l_inventory_spec_vrs,l_inventory_spec_vrs_out)
3816: THEN
3817: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
3818: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
3819: 'l_column_name', 'SPEC_VR_ID',

Line 3818: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',

3814: -- =============
3815: IF NOT GMD_Inventory_Spec_VRS_PVT.Fetch_Row(l_inventory_spec_vrs,l_inventory_spec_vrs_out)
3816: THEN
3817: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
3818: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
3819: 'l_column_name', 'SPEC_VR_ID',
3820: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
3821: RAISE FND_API.G_EXC_ERROR;
3822: END IF;

Line 3831: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',

3827: -- =============================================
3828: IF l_inventory_spec_vrs.delete_mark <> 0
3829: THEN
3830: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
3831: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
3832: 'l_column_name', 'SPEC_VR_ID',
3833: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
3834: RAISE FND_API.G_EXC_ERROR;
3835: END IF;