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_PUB dependencies on GMD_INVENTORY_SPEC_VRS

Line 53: | into gmd_inventory_spec_vrs |

49: | |
50: | DESCRIPTION |
51: | Accepts a table of inventory_spec_vrs definitions. Validates |
52: | each table entry and where valid, inserts a corresponding row |
53: | into gmd_inventory_spec_vrs |
54: | In the case of any failure a rollback is instigated.
55: | |
56: | HISTORY |
57: | 03-AUG-2002 K.Y.Hunt |

Line 84: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;

80: l_msg_count NUMBER :=0;
81: l_msg_data VARCHAR2(2000);
82: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
83: l_spec GMD_SPECIFICATIONS%ROWTYPE;
84: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;
85: l_inventory_spec_vrs_out GMD_INVENTORY_SPEC_VRS%ROWTYPE;
86: l_inventory_spec_vrs_tbl GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl;
87: l_rowid ROWID;
88: l_user_id NUMBER(15);

Line 85: l_inventory_spec_vrs_out GMD_INVENTORY_SPEC_VRS%ROWTYPE;

81: l_msg_data VARCHAR2(2000);
82: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
83: l_spec GMD_SPECIFICATIONS%ROWTYPE;
84: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;
85: l_inventory_spec_vrs_out GMD_INVENTORY_SPEC_VRS%ROWTYPE;
86: l_inventory_spec_vrs_tbl GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl;
87: l_rowid ROWID;
88: l_user_id NUMBER(15);
89:

Line 167: IF NOT GMD_INVENTORY_SPEC_VRS_PVT.Insert_Row(l_inventory_spec_vrs, l_inventory_spec_vrs_out)

163: END IF;
164:
165: l_inventory_spec_vrs := l_inventory_spec_vrs_out;
166:
167: IF NOT GMD_INVENTORY_SPEC_VRS_PVT.Insert_Row(l_inventory_spec_vrs, l_inventory_spec_vrs_out)
168: THEN
169: -- Diagnostic message is already on the stack
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;

Line 971: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;

967: l_msg_count NUMBER :=0;
968: l_msg_data VARCHAR2(2000);
969: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
970: l_spec GMD_SPECIFICATIONS%ROWTYPE;
971: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;
972: l_deleted_rows NUMBER :=0;
973:
974: BEGIN
975:

Line 1074: IF NOT GMD_INVENTORY_SPEC_VRS_PVT.Lock_Row( l_inventory_spec_vrs.spec_vr_id)

1070:
1071:
1072: -- Lock the validity rule ahead of deleting
1073: -- ========================================
1074: IF NOT GMD_INVENTORY_SPEC_VRS_PVT.Lock_Row( l_inventory_spec_vrs.spec_vr_id)
1075: THEN
1076: -- Report Failure to obtain locks
1077: -- ==============================
1078: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 1079: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',

1075: THEN
1076: -- Report Failure to obtain locks
1077: -- ==============================
1078: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1079: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
1080: 'l_column_name', 'SPEC_VR_ID',
1081: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;

Line 1085: IF NOT GMD_INVENTORY_SPEC_VRS_PVT.Delete_Row

1081: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084:
1085: IF NOT GMD_INVENTORY_SPEC_VRS_PVT.Delete_Row
1086: ( p_spec_vr_id => l_inventory_spec_vrs.spec_vr_id
1087: , p_last_update_date => sysdate
1088: , p_last_updated_by => l_spec.last_updated_by
1089: )

Line 1092: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',

1088: , p_last_updated_by => l_spec.last_updated_by
1089: )
1090: THEN
1091: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1092: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
1093: 'l_column_name', 'SPEC_VR_ID',
1094: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
1095: fnd_msg_pub.ADD;
1096: RAISE FND_API.G_EXC_ERROR;