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.

[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_INVENTORY_SPEC_VRS

Line 682: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE

678: -- End of comments
679:
680: PROCEDURE validate_inv_vr
681: (
682: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
683: , p_called_from IN VARCHAR2
684: , p_operation IN VARCHAR2
685: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
686: , x_return_status OUT NOCOPY VARCHAR2

Line 685: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE

681: (
682: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
683: , p_called_from IN VARCHAR2
684: , p_operation IN VARCHAR2
685: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
686: , x_return_status OUT NOCOPY VARCHAR2
687: ) IS
688:
689: -- Local Variables

Line 695: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;

691: l_return_status VARCHAR2(1);
692:
693: l_spec GMD_SPECIFICATIONS%ROWTYPE;
694: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
695: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
696: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;
697: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
698: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
699: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

Line 696: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;

692:
693: l_spec GMD_SPECIFICATIONS%ROWTYPE;
694: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
695: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
696: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;
697: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
698: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
699: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
700: l_inventory_item_id NUMBER;

Line 929: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE

925: -- End of comments
926:
927: PROCEDURE check_for_null_and_fks_in_ivr
928: (
929: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
930: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
931: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
932: , x_return_status OUT NOCOPY VARCHAR2
933: )

Line 931: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE

927: PROCEDURE check_for_null_and_fks_in_ivr
928: (
929: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
930: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
931: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
932: , x_return_status OUT NOCOPY VARCHAR2
933: )
934: IS
935:

Line 936: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;

932: , x_return_status OUT NOCOPY VARCHAR2
933: )
934: IS
935:
936: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
937: l_spec GMD_SPECIFICATIONS%ROWTYPE;
938:
939: CURSOR c_item_lot_number IS
940: SELECT 1

Line 1216: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,

1212: --| Plowe 04-Apr-2006 Bug 5117733 - added item revision to match
1213: --+========================================================================+
1214: -- End of comments
1215:
1216: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,
1217: p_spec GMD_SPECIFICATIONS%ROWTYPE)
1218: RETURN BOOLEAN IS
1219:
1220: CURSOR c_inv_vr IS

Line 1222: FROM gmd_specifications_b s, gmd_inventory_spec_vrs vr

1218: RETURN BOOLEAN IS
1219:
1220: CURSOR c_inv_vr IS
1221: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
1222: FROM gmd_specifications_b s, gmd_inventory_spec_vrs vr
1223: WHERE s.spec_id = vr.spec_id
1224: AND s.owner_organization_id = p_spec.owner_organization_id
1225: AND s.inventory_item_id = p_spec.inventory_item_id
1226: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 3953: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;

3949: x_message_data OUT NOCOPY VARCHAR2) IS
3950:
3951: l_progress VARCHAR2(3);
3952: l_temp VARCHAR2(1);
3953: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;
3954: l_inventory_spec_vrs_out GMD_INVENTORY_SPEC_VRS%ROWTYPE;
3955:
3956: BEGIN
3957: l_progress := '010';

Line 3954: l_inventory_spec_vrs_out GMD_INVENTORY_SPEC_VRS%ROWTYPE;

3950:
3951: l_progress VARCHAR2(3);
3952: l_temp VARCHAR2(1);
3953: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;
3954: l_inventory_spec_vrs_out GMD_INVENTORY_SPEC_VRS%ROWTYPE;
3955:
3956: BEGIN
3957: l_progress := '010';
3958: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

3974: END IF;
3975:
3976: -- Fetch the row
3977: -- =============
3978: IF NOT GMD_Inventory_Spec_VRS_PVT.Fetch_Row(l_inventory_spec_vrs,l_inventory_spec_vrs_out)
3979: THEN
3980: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
3981: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
3982: 'l_column_name', 'SPEC_VR_ID',

Line 3981: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',

3977: -- =============
3978: IF NOT GMD_Inventory_Spec_VRS_PVT.Fetch_Row(l_inventory_spec_vrs,l_inventory_spec_vrs_out)
3979: THEN
3980: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
3981: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
3982: 'l_column_name', 'SPEC_VR_ID',
3983: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
3984: RAISE FND_API.G_EXC_ERROR;
3985: END IF;

Line 3994: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',

3990: -- =============================================
3991: IF l_inventory_spec_vrs.delete_mark <> 0
3992: THEN
3993: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
3994: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
3995: 'l_column_name', 'SPEC_VR_ID',
3996: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
3997: RAISE FND_API.G_EXC_ERROR;
3998: END IF;