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.INV_ITEM_PVT dependencies on INV_ITEM_API

Line 160: OPEN INV_ITEM_API.Item_csr

156: */
157: l_return_status VARCHAR2(1);
158: BEGIN
159:
160: OPEN INV_ITEM_API.Item_csr
161: (
162: p_Item_ID => p_Item_ID
163: , p_Org_ID => p_Org_ID
164: , p_fetch_Master => p_lock_Master

Line 168: CLOSE INV_ITEM_API.Item_csr;

164: , p_fetch_Master => p_lock_Master
165: , p_fetch_Orgs => p_lock_Orgs
166: );
167:
168: CLOSE INV_ITEM_API.Item_csr;
169:
170: OPEN INV_ITEM_API.Item_TL_csr
171: (
172: p_Item_ID => p_Item_ID

Line 170: OPEN INV_ITEM_API.Item_TL_csr

166: );
167:
168: CLOSE INV_ITEM_API.Item_csr;
169:
170: OPEN INV_ITEM_API.Item_TL_csr
171: (
172: p_Item_ID => p_Item_ID
173: , p_Org_ID => p_Org_ID
174: , p_fetch_Master => p_lock_Master

Line 178: CLOSE INV_ITEM_API.Item_TL_csr;

174: , p_fetch_Master => p_lock_Master
175: , p_fetch_Orgs => p_lock_Orgs
176: );
177:
178: CLOSE INV_ITEM_API.Item_TL_csr;
179:
180: EXCEPTION
181:
182: /*

Line 194: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN

190: */
191:
192: WHEN OTHERS THEN
193:
194: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
195: CLOSE INV_ITEM_API.Item_csr;
196: END IF;
197:
198: IF ( INV_ITEM_API.Item_TL_csr%ISOPEN ) THEN

Line 195: CLOSE INV_ITEM_API.Item_csr;

191:
192: WHEN OTHERS THEN
193:
194: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
195: CLOSE INV_ITEM_API.Item_csr;
196: END IF;
197:
198: IF ( INV_ITEM_API.Item_TL_csr%ISOPEN ) THEN
199: CLOSE INV_ITEM_API.Item_TL_csr;

Line 198: IF ( INV_ITEM_API.Item_TL_csr%ISOPEN ) THEN

194: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
195: CLOSE INV_ITEM_API.Item_csr;
196: END IF;
197:
198: IF ( INV_ITEM_API.Item_TL_csr%ISOPEN ) THEN
199: CLOSE INV_ITEM_API.Item_TL_csr;
200: END IF;
201:
202: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

Line 199: CLOSE INV_ITEM_API.Item_TL_csr;

195: CLOSE INV_ITEM_API.Item_csr;
196: END IF;
197:
198: IF ( INV_ITEM_API.Item_TL_csr%ISOPEN ) THEN
199: CLOSE INV_ITEM_API.Item_TL_csr;
200: END IF;
201:
202: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
203: fnd_message.Set_Name( 'INV', 'Cannot_Lock_Item_rec' );

Line 218: , p_Item_rec IN INV_ITEM_API.Item_rec_type

214: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
215: , p_commit IN VARCHAR2 := FND_API.g_FALSE
216: , p_lock_rows IN VARCHAR2 := FND_API.g_TRUE
217: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
218: , p_Item_rec IN INV_ITEM_API.Item_rec_type
219: , p_update_changes_only IN VARCHAR2 := FND_API.g_FALSE
220: , p_validate_Master IN VARCHAR2 := FND_API.g_TRUE
221: , x_return_status OUT NOCOPY VARCHAR2
222: , x_msg_count OUT NOCOPY NUMBER

Line 236: l_Item_rec INV_ITEM_API.Item_rec_type;

232:
233: -- l_Item_ID NUMBER;
234: -- l_Org_ID NUMBER;
235:
236: l_Item_rec INV_ITEM_API.Item_rec_type;
237: m_Item_rec INV_ITEM_API.Item_rec_type;
238:
239: -- l_Item_TL_rec INV_ITEM_API.Item_TL_rec_type;
240:

Line 237: m_Item_rec INV_ITEM_API.Item_rec_type;

233: -- l_Item_ID NUMBER;
234: -- l_Org_ID NUMBER;
235:
236: l_Item_rec INV_ITEM_API.Item_rec_type;
237: m_Item_rec INV_ITEM_API.Item_rec_type;
238:
239: -- l_Item_TL_rec INV_ITEM_API.Item_TL_rec_type;
240:
241: l_Attribute_Code Attribute_Code_type;

Line 239: -- l_Item_TL_rec INV_ITEM_API.Item_TL_rec_type;

235:
236: l_Item_rec INV_ITEM_API.Item_rec_type;
237: m_Item_rec INV_ITEM_API.Item_rec_type;
238:
239: -- l_Item_TL_rec INV_ITEM_API.Item_TL_rec_type;
240:
241: l_Attribute_Code Attribute_Code_type;
242: l_update_Item_TL BOOLEAN;
243: -- l_Lang_Flag VARCHAR2(1);

Line 399: OPEN INV_ITEM_API.Item_csr

395: -- The first row is master item, if p_Org --
396: -- is master organization. --
397: --------------------------------------------
398:
399: OPEN INV_ITEM_API.Item_csr
400: (
401: p_Item_ID => p_Item_ID
402: , p_Org_ID => p_Org_ID
403: , p_fetch_Master => FND_API.g_TRUE

Line 406: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;

402: , p_Org_ID => p_Org_ID
403: , p_fetch_Master => FND_API.g_TRUE
404: , p_fetch_Orgs => FND_API.g_TRUE
405: );
406: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
407:
408: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
409: CLOSE INV_ITEM_API.Item_csr;
410: fnd_message.SET_NAME( 'INV', 'INV_Update_Org_Items_notfound' );

Line 408: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN

404: , p_fetch_Orgs => FND_API.g_TRUE
405: );
406: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
407:
408: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
409: CLOSE INV_ITEM_API.Item_csr;
410: fnd_message.SET_NAME( 'INV', 'INV_Update_Org_Items_notfound' );
411: FND_MSG_PUB.Add;
412: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

Line 409: CLOSE INV_ITEM_API.Item_csr;

405: );
406: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
407:
408: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
409: CLOSE INV_ITEM_API.Item_csr;
410: fnd_message.SET_NAME( 'INV', 'INV_Update_Org_Items_notfound' );
411: FND_MSG_PUB.Add;
412: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
413: END IF;

Line 558: INV_ITEM_API.Update_Item_Row

554: ----------------------------
555: -- Update master item row --
556: ----------------------------
557:
558: INV_ITEM_API.Update_Item_Row
559: (
560: p_Item_rec => l_Item_rec
561: , p_update_Item_TL => TRUE
562: , p_Lang_Flag => l_Lang_Flag

Line 697: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;

693: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
694: --------------------------------
695: LOOP -- loop through org items
696:
697: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
698:
699: EXIT WHEN INV_ITEM_API.Item_csr%NOTFOUND;
700:
701: ----------------------------------

Line 699: EXIT WHEN INV_ITEM_API.Item_csr%NOTFOUND;

695: LOOP -- loop through org items
696:
697: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
698:
699: EXIT WHEN INV_ITEM_API.Item_csr%NOTFOUND;
700:
701: ----------------------------------
702: -- Loop through item attributes --
703: ----------------------------------

Line 2377: -- Derived Service attribute columns get updated in INV_ITEM_API.Update_Item_Row.

2373: l_update_child_rec := TRUE;
2374: END IF;
2375: -- End: 5365622
2376:
2377: -- Derived Service attribute columns get updated in INV_ITEM_API.Update_Item_Row.
2378: --ELSIF ( l_Attribute_Code = 'SERVICE_ITEM_FLAG' ) THEN
2379: -- l_Item_rec.SERVICE_ITEM_FLAG := m_Item_rec.SERVICE_ITEM_FLAG;
2380: --ELSIF ( l_Attribute_Code = 'VENDOR_WARRANTY_FLAG' ) THEN
2381: -- l_Item_rec.VENDOR_WARRANTY_FLAG := m_Item_rec.VENDOR_WARRANTY_FLAG;

Line 2903: INV_ITEM_API.Update_Item_Row

2899: -- Update current org item row --
2900: ---------------------------------
2901: IF l_update_child_rec = TRUE THEN
2902: Set_Is_Master_Attr_Modified('Y'); /*Bug 6407303, Set the parameter */
2903: INV_ITEM_API.Update_Item_Row
2904: (
2905: p_Item_rec => l_Item_rec
2906: , p_update_Item_TL => l_update_Item_TL
2907: , p_Lang_Flag => l_Lang_Flag

Line 2917: CLOSE INV_ITEM_API.Item_csr;

2913:
2914: END IF; -- p_Org is master
2915: ----------------------------------- p_Org is master ---
2916:
2917: CLOSE INV_ITEM_API.Item_csr;
2918:
2919: IF ( FND_API.to_Boolean (p_commit) ) THEN
2920: COMMIT WORK;
2921: END IF;

Line 2932: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN

2928: EXCEPTION
2929:
2930: WHEN FND_API.g_EXC_ERROR THEN
2931:
2932: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2933: CLOSE INV_ITEM_API.Item_csr;
2934: END IF;
2935:
2936: ROLLBACK TO Update_Org_Items_PVT;

Line 2933: CLOSE INV_ITEM_API.Item_csr;

2929:
2930: WHEN FND_API.g_EXC_ERROR THEN
2931:
2932: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2933: CLOSE INV_ITEM_API.Item_csr;
2934: END IF;
2935:
2936: ROLLBACK TO Update_Org_Items_PVT;
2937: x_return_status := FND_API.g_RET_STS_ERROR;

Line 2945: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN

2941: );
2942:
2943: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
2944:
2945: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2946: CLOSE INV_ITEM_API.Item_csr;
2947: END IF;
2948:
2949: ROLLBACK TO Update_Org_Items_PVT;

Line 2946: CLOSE INV_ITEM_API.Item_csr;

2942:
2943: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
2944:
2945: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2946: CLOSE INV_ITEM_API.Item_csr;
2947: END IF;
2948:
2949: ROLLBACK TO Update_Org_Items_PVT;
2950: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

Line 2958: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN

2954: );
2955:
2956: WHEN others THEN
2957:
2958: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2959: CLOSE INV_ITEM_API.Item_csr;
2960: END IF;
2961:
2962: ROLLBACK TO Update_Org_Items_PVT;

Line 2959: CLOSE INV_ITEM_API.Item_csr;

2955:
2956: WHEN others THEN
2957:
2958: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2959: CLOSE INV_ITEM_API.Item_csr;
2960: END IF;
2961:
2962: ROLLBACK TO Update_Org_Items_PVT;
2963: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

Line 2991: , x_Item_rec OUT NOCOPY INV_ITEM_API.Item_rec_type

2987: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
2988: , p_Item_ID IN NUMBER
2989: , p_Org_ID IN NUMBER
2990: , p_Language IN VARCHAR2 := FND_API.g_MISS_CHAR
2991: , x_Item_rec OUT NOCOPY INV_ITEM_API.Item_rec_type
2992: , x_return_status OUT NOCOPY VARCHAR2
2993: , x_msg_count OUT NOCOPY NUMBER
2994: , x_msg_data OUT NOCOPY VARCHAR2
2995: )

Line 3037: OPEN INV_ITEM_API.Item_csr

3033: -----------------------------------
3034: -- Open item query on base table --
3035: -----------------------------------
3036:
3037: OPEN INV_ITEM_API.Item_csr
3038: (
3039: p_Item_ID => p_Item_ID
3040: , p_Org_ID => p_Org_ID
3041: , p_fetch_Master => FND_API.g_TRUE

Line 3047: FETCH INV_ITEM_API.Item_csr INTO x_Item_rec;

3043: );
3044:
3045: -- Fetch org item row
3046: --
3047: FETCH INV_ITEM_API.Item_csr INTO x_Item_rec;
3048:
3049: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
3050: CLOSE INV_ITEM_API.Item_csr;
3051: fnd_message.SET_NAME( 'INV', 'INV_Get_Org_Item_notfound' );

Line 3049: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN

3045: -- Fetch org item row
3046: --
3047: FETCH INV_ITEM_API.Item_csr INTO x_Item_rec;
3048:
3049: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
3050: CLOSE INV_ITEM_API.Item_csr;
3051: fnd_message.SET_NAME( 'INV', 'INV_Get_Org_Item_notfound' );
3052: FND_MSG_PUB.Add;
3053: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

Line 3050: CLOSE INV_ITEM_API.Item_csr;

3046: --
3047: FETCH INV_ITEM_API.Item_csr INTO x_Item_rec;
3048:
3049: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
3050: CLOSE INV_ITEM_API.Item_csr;
3051: fnd_message.SET_NAME( 'INV', 'INV_Get_Org_Item_notfound' );
3052: FND_MSG_PUB.Add;
3053: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3054: END IF;

Line 3056: CLOSE INV_ITEM_API.Item_csr;

3052: FND_MSG_PUB.Add;
3053: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3054: END IF;
3055:
3056: CLOSE INV_ITEM_API.Item_csr;
3057:
3058: FND_MSG_PUB.Count_And_Get
3059: ( p_count => x_msg_count
3060: , p_data => x_msg_data

Line 3067: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN

3063: EXCEPTION
3064:
3065: WHEN FND_API.g_EXC_ERROR THEN
3066:
3067: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
3068: CLOSE INV_ITEM_API.Item_csr;
3069: END IF;
3070:
3071: x_return_status := FND_API.g_RET_STS_ERROR;

Line 3068: CLOSE INV_ITEM_API.Item_csr;

3064:
3065: WHEN FND_API.g_EXC_ERROR THEN
3066:
3067: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
3068: CLOSE INV_ITEM_API.Item_csr;
3069: END IF;
3070:
3071: x_return_status := FND_API.g_RET_STS_ERROR;
3072: FND_MSG_PUB.Count_And_Get

Line 3079: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN

3075: );
3076:
3077: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3078:
3079: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
3080: CLOSE INV_ITEM_API.Item_csr;
3081: END IF;
3082:
3083: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

Line 3080: CLOSE INV_ITEM_API.Item_csr;

3076:
3077: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3078:
3079: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
3080: CLOSE INV_ITEM_API.Item_csr;
3081: END IF;
3082:
3083: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
3084: FND_MSG_PUB.Count_And_Get

Line 3091: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN

3087: );
3088:
3089: WHEN others THEN
3090:
3091: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
3092: CLOSE INV_ITEM_API.Item_csr;
3093: END IF;
3094:
3095: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

Line 3092: CLOSE INV_ITEM_API.Item_csr;

3088:
3089: WHEN others THEN
3090:
3091: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
3092: CLOSE INV_ITEM_API.Item_csr;
3093: END IF;
3094:
3095: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
3096:

Line 3124: , p_Item_rec IN INV_ITEM_API.Item_rec_type

3120: /*
3121: PROCEDURE Validate_Item
3122: (
3123: p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
3124: , p_Item_rec IN INV_ITEM_API.Item_rec_type
3125: , x_return_status OUT NOCOPY VARCHAR2
3126: , x_msg_count OUT NOCOPY NUMBER
3127: , x_msg_data OUT NOCOPY VARCHAR2
3128: )

Line 3132: l_Item_rec INV_ITEM_API.Item_rec_type ;

3128: )
3129: IS
3130: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Item';
3131:
3132: l_Item_rec INV_ITEM_API.Item_rec_type ;
3133: l_Item_ID NUMBER ;
3134: l_Org_ID NUMBER ;
3135:
3136: l_return_status VARCHAR2(1) ;

Line 3235: P_Segment_Rec IN INV_ITEM_API.Item_rec_type

3231: END Validate_Item;
3232: */
3233:
3234: PROCEDURE get_segments_string(
3235: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3236: ,P_Segment_String OUT NOCOPY VARCHAR2)
3237: IS
3238: l_segment_string VARCHAR2(2000) := NULL ;
3239: BEGIN

Line 3349: P_Segment_Rec IN INV_ITEM_API.Item_rec_type

3345:
3346:
3347:
3348: PROCEDURE Check_Item_Number (
3349: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3350: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
3351: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
3352: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
3353: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)

Line 3412: PROCEDURE Insert_Row(P_Item_Rec IN INV_ITEM_API.Item_rec_type

3408: END IF;
3409: RAISE;
3410: END Check_Item_Number;
3411:
3412: PROCEDURE Insert_Row(P_Item_Rec IN INV_ITEM_API.Item_rec_type
3413: ,x_row_Id OUT NOCOPY ROWID)
3414: IS
3415:
3416: CURSOR c_ego_exists IS

Line 4427: PROCEDURE Update_Row(P_Item_Rec IN INV_ITEM_API.Item_rec_type)

4423: --R12: Business Event Enhancement
4424: END Insert_Row;
4425:
4426:
4427: PROCEDURE Update_Row(P_Item_Rec IN INV_ITEM_API.Item_rec_type)
4428: IS
4429:
4430: l_return_status VARCHAR2(1);
4431: l_msg_count NUMBER;

Line 4493: P_Item_Rec IN INV_ITEM_API.Item_rec_type

4489:
4490: END check_mismatch_of_secuom_class;
4491:
4492: PROCEDURE Create_Item(
4493: P_Item_Rec IN INV_ITEM_API.Item_rec_type
4494: ,P_Item_Category_Struct_Id IN NUMBER
4495: ,P_Inv_Install IN NUMBER
4496: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4497: ,P_Category_Set_Id IN NUMBER

Line 4810: P_Item_Rec IN INV_ITEM_API.Item_rec_type

4806: NULL;
4807: END Delete_Cost_Details;
4808:
4809: PROCEDURE Update_Item(
4810: P_Item_Rec IN INV_ITEM_API.Item_rec_type
4811: ,P_Item_Category_Struct_Id IN NUMBER
4812: ,P_Inv_Install IN NUMBER
4813: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4814: ,P_Category_Set_Id IN NUMBER

Line 5130: PROCEDURE Lock_Item( P_Item_Rec IN INV_ITEM_API.Item_rec_type) IS

5126: app_exception.raise_exception;
5127: END Update_Item;
5128:
5129: -- ------------------ LOCK_ITEM -------------------
5130: PROCEDURE Lock_Item( P_Item_Rec IN INV_ITEM_API.Item_rec_type) IS
5131:
5132: CURSOR c_item_details IS
5133: SELECT
5134: PRIMARY_UOM_CODE,

Line 6611: PROCEDURE Check_Master_Record_Locked( P_Item_Rec IN INV_ITEM_API.Item_rec_type) IS

6607: END SYNC_IM_INDEX;
6608:
6609: -- Added as part of Bug Fix 3623450 to Check whether the master item record
6610: -- is locked. Called from item form COPY_ITEM block DONE and COPY button's W-B-P
6611: PROCEDURE Check_Master_Record_Locked( P_Item_Rec IN INV_ITEM_API.Item_rec_type) IS
6612:
6613: CURSOR c_item_name IS
6614: SELECT
6615: SEGMENT1