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 372: OPEN INV_ITEM_API.Item_csr

368: -- The first row is master item, if p_Org --
369: -- is master organization. --
370: --------------------------------------------
371:
372: OPEN INV_ITEM_API.Item_csr
373: (
374: p_Item_ID => p_Item_ID
375: , p_Org_ID => p_Org_ID
376: , p_fetch_Master => FND_API.g_TRUE

Line 379: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;

375: , p_Org_ID => p_Org_ID
376: , p_fetch_Master => FND_API.g_TRUE
377: , p_fetch_Orgs => FND_API.g_TRUE
378: );
379: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
380:
381: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
382: CLOSE INV_ITEM_API.Item_csr;
383: fnd_message.SET_NAME( 'INV', 'INV_Update_Org_Items_notfound' );

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

377: , p_fetch_Orgs => FND_API.g_TRUE
378: );
379: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
380:
381: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
382: CLOSE INV_ITEM_API.Item_csr;
383: fnd_message.SET_NAME( 'INV', 'INV_Update_Org_Items_notfound' );
384: FND_MSG_PUB.Add;
385: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

Line 382: CLOSE INV_ITEM_API.Item_csr;

378: );
379: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
380:
381: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
382: CLOSE INV_ITEM_API.Item_csr;
383: fnd_message.SET_NAME( 'INV', 'INV_Update_Org_Items_notfound' );
384: FND_MSG_PUB.Add;
385: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
386: END IF;

Line 525: INV_ITEM_API.Update_Item_Row

521: ----------------------------
522: -- Update master item row --
523: ----------------------------
524:
525: INV_ITEM_API.Update_Item_Row
526: (
527: p_Item_rec => l_Item_rec
528: , p_update_Item_TL => TRUE
529: , p_Lang_Flag => l_Lang_Flag

Line 621: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;

617:
618: --------------------------------
619: LOOP -- loop through org items
620:
621: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
622:
623: EXIT WHEN INV_ITEM_API.Item_csr%NOTFOUND;
624:
625: ----------------------------------

Line 623: EXIT WHEN INV_ITEM_API.Item_csr%NOTFOUND;

619: LOOP -- loop through org items
620:
621: FETCH INV_ITEM_API.Item_csr INTO l_Item_rec;
622:
623: EXIT WHEN INV_ITEM_API.Item_csr%NOTFOUND;
624:
625: ----------------------------------
626: -- Loop through item attributes --
627: ----------------------------------

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

2258: l_update_child_rec := TRUE;
2259: END IF;
2260: -- End: 5365622
2261:
2262: -- Derived Service attribute columns get updated in INV_ITEM_API.Update_Item_Row.
2263: --ELSIF ( l_Attribute_Code = 'SERVICE_ITEM_FLAG' ) THEN
2264: -- l_Item_rec.SERVICE_ITEM_FLAG := m_Item_rec.SERVICE_ITEM_FLAG;
2265: --ELSIF ( l_Attribute_Code = 'VENDOR_WARRANTY_FLAG' ) THEN
2266: -- l_Item_rec.VENDOR_WARRANTY_FLAG := m_Item_rec.VENDOR_WARRANTY_FLAG;

Line 2642: INV_ITEM_API.Update_Item_Row

2638: -- Update current org item row --
2639: ---------------------------------
2640: IF l_update_child_rec = TRUE THEN
2641: Set_Is_Master_Attr_Modified('Y'); /*Bug 6407303, Set the parameter */
2642: INV_ITEM_API.Update_Item_Row
2643: (
2644: p_Item_rec => l_Item_rec
2645: , p_update_Item_TL => l_update_Item_TL
2646: , p_Lang_Flag => l_Lang_Flag

Line 2656: CLOSE INV_ITEM_API.Item_csr;

2652:
2653: END IF; -- p_Org is master
2654: ----------------------------------- p_Org is master ---
2655:
2656: CLOSE INV_ITEM_API.Item_csr;
2657:
2658: IF ( FND_API.to_Boolean (p_commit) ) THEN
2659: COMMIT WORK;
2660: END IF;

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

2667: EXCEPTION
2668:
2669: WHEN FND_API.g_EXC_ERROR THEN
2670:
2671: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2672: CLOSE INV_ITEM_API.Item_csr;
2673: END IF;
2674:
2675: ROLLBACK TO Update_Org_Items_PVT;

Line 2672: CLOSE INV_ITEM_API.Item_csr;

2668:
2669: WHEN FND_API.g_EXC_ERROR THEN
2670:
2671: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2672: CLOSE INV_ITEM_API.Item_csr;
2673: END IF;
2674:
2675: ROLLBACK TO Update_Org_Items_PVT;
2676: x_return_status := FND_API.g_RET_STS_ERROR;

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

2680: );
2681:
2682: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
2683:
2684: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2685: CLOSE INV_ITEM_API.Item_csr;
2686: END IF;
2687:
2688: ROLLBACK TO Update_Org_Items_PVT;

Line 2685: CLOSE INV_ITEM_API.Item_csr;

2681:
2682: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
2683:
2684: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2685: CLOSE INV_ITEM_API.Item_csr;
2686: END IF;
2687:
2688: ROLLBACK TO Update_Org_Items_PVT;
2689: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

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

2693: );
2694:
2695: WHEN others THEN
2696:
2697: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2698: CLOSE INV_ITEM_API.Item_csr;
2699: END IF;
2700:
2701: ROLLBACK TO Update_Org_Items_PVT;

Line 2698: CLOSE INV_ITEM_API.Item_csr;

2694:
2695: WHEN others THEN
2696:
2697: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2698: CLOSE INV_ITEM_API.Item_csr;
2699: END IF;
2700:
2701: ROLLBACK TO Update_Org_Items_PVT;
2702: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

Line 2730: , x_Item_rec OUT NOCOPY INV_ITEM_API.Item_rec_type

2726: p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
2727: , p_Item_ID IN NUMBER
2728: , p_Org_ID IN NUMBER
2729: , p_Language IN VARCHAR2 := FND_API.g_MISS_CHAR
2730: , x_Item_rec OUT NOCOPY INV_ITEM_API.Item_rec_type
2731: , x_return_status OUT NOCOPY VARCHAR2
2732: , x_msg_count OUT NOCOPY NUMBER
2733: , x_msg_data OUT NOCOPY VARCHAR2
2734: )

Line 2776: OPEN INV_ITEM_API.Item_csr

2772: -----------------------------------
2773: -- Open item query on base table --
2774: -----------------------------------
2775:
2776: OPEN INV_ITEM_API.Item_csr
2777: (
2778: p_Item_ID => p_Item_ID
2779: , p_Org_ID => p_Org_ID
2780: , p_fetch_Master => FND_API.g_TRUE

Line 2786: FETCH INV_ITEM_API.Item_csr INTO x_Item_rec;

2782: );
2783:
2784: -- Fetch org item row
2785: --
2786: FETCH INV_ITEM_API.Item_csr INTO x_Item_rec;
2787:
2788: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
2789: CLOSE INV_ITEM_API.Item_csr;
2790: fnd_message.SET_NAME( 'INV', 'INV_Get_Org_Item_notfound' );

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

2784: -- Fetch org item row
2785: --
2786: FETCH INV_ITEM_API.Item_csr INTO x_Item_rec;
2787:
2788: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
2789: CLOSE INV_ITEM_API.Item_csr;
2790: fnd_message.SET_NAME( 'INV', 'INV_Get_Org_Item_notfound' );
2791: FND_MSG_PUB.Add;
2792: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

Line 2789: CLOSE INV_ITEM_API.Item_csr;

2785: --
2786: FETCH INV_ITEM_API.Item_csr INTO x_Item_rec;
2787:
2788: IF ( INV_ITEM_API.Item_csr%NOTFOUND ) THEN
2789: CLOSE INV_ITEM_API.Item_csr;
2790: fnd_message.SET_NAME( 'INV', 'INV_Get_Org_Item_notfound' );
2791: FND_MSG_PUB.Add;
2792: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2793: END IF;

Line 2795: CLOSE INV_ITEM_API.Item_csr;

2791: FND_MSG_PUB.Add;
2792: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
2793: END IF;
2794:
2795: CLOSE INV_ITEM_API.Item_csr;
2796:
2797: FND_MSG_PUB.Count_And_Get
2798: ( p_count => x_msg_count
2799: , p_data => x_msg_data

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

2802: EXCEPTION
2803:
2804: WHEN FND_API.g_EXC_ERROR THEN
2805:
2806: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2807: CLOSE INV_ITEM_API.Item_csr;
2808: END IF;
2809:
2810: x_return_status := FND_API.g_RET_STS_ERROR;

Line 2807: CLOSE INV_ITEM_API.Item_csr;

2803:
2804: WHEN FND_API.g_EXC_ERROR THEN
2805:
2806: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2807: CLOSE INV_ITEM_API.Item_csr;
2808: END IF;
2809:
2810: x_return_status := FND_API.g_RET_STS_ERROR;
2811: FND_MSG_PUB.Count_And_Get

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

2814: );
2815:
2816: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
2817:
2818: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2819: CLOSE INV_ITEM_API.Item_csr;
2820: END IF;
2821:
2822: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

Line 2819: CLOSE INV_ITEM_API.Item_csr;

2815:
2816: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
2817:
2818: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2819: CLOSE INV_ITEM_API.Item_csr;
2820: END IF;
2821:
2822: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2823: FND_MSG_PUB.Count_And_Get

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

2826: );
2827:
2828: WHEN others THEN
2829:
2830: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2831: CLOSE INV_ITEM_API.Item_csr;
2832: END IF;
2833:
2834: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

Line 2831: CLOSE INV_ITEM_API.Item_csr;

2827:
2828: WHEN others THEN
2829:
2830: IF ( INV_ITEM_API.Item_csr%ISOPEN ) THEN
2831: CLOSE INV_ITEM_API.Item_csr;
2832: END IF;
2833:
2834: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2835:

Line 2863: , p_Item_rec IN INV_ITEM_API.Item_rec_type

2859: /*
2860: PROCEDURE Validate_Item
2861: (
2862: p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
2863: , p_Item_rec IN INV_ITEM_API.Item_rec_type
2864: , x_return_status OUT NOCOPY VARCHAR2
2865: , x_msg_count OUT NOCOPY NUMBER
2866: , x_msg_data OUT NOCOPY VARCHAR2
2867: )

Line 2871: l_Item_rec INV_ITEM_API.Item_rec_type ;

2867: )
2868: IS
2869: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Item';
2870:
2871: l_Item_rec INV_ITEM_API.Item_rec_type ;
2872: l_Item_ID NUMBER ;
2873: l_Org_ID NUMBER ;
2874:
2875: l_return_status VARCHAR2(1) ;

Line 2974: P_Segment_Rec IN INV_ITEM_API.Item_rec_type

2970: END Validate_Item;
2971: */
2972:
2973: PROCEDURE get_segments_string(
2974: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
2975: ,P_Segment_String OUT NOCOPY VARCHAR2)
2976: IS
2977: l_segment_string VARCHAR2(2000) := NULL ;
2978: BEGIN

Line 3088: P_Segment_Rec IN INV_ITEM_API.Item_rec_type

3084:
3085:
3086:
3087: PROCEDURE Check_Item_Number (
3088: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3089: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
3090: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
3091: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
3092: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)

Line 3151: PROCEDURE Insert_Row(P_Item_Rec IN INV_ITEM_API.Item_rec_type

3147: END IF;
3148: RAISE;
3149: END Check_Item_Number;
3150:
3151: PROCEDURE Insert_Row(P_Item_Rec IN INV_ITEM_API.Item_rec_type
3152: ,x_row_Id OUT NOCOPY ROWID)
3153: IS
3154:
3155: CURSOR c_ego_exists IS

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

4158: --R12: Business Event Enhancement
4159: END Insert_Row;
4160:
4161:
4162: PROCEDURE Update_Row(P_Item_Rec IN INV_ITEM_API.Item_rec_type)
4163: IS
4164:
4165: l_return_status VARCHAR2(1);
4166: l_msg_count NUMBER;

Line 4228: P_Item_Rec IN INV_ITEM_API.Item_rec_type

4224:
4225: END check_mismatch_of_secuom_class;
4226:
4227: PROCEDURE Create_Item(
4228: P_Item_Rec IN INV_ITEM_API.Item_rec_type
4229: ,P_Item_Category_Struct_Id IN NUMBER
4230: ,P_Inv_Install IN NUMBER
4231: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4232: ,P_Category_Set_Id IN NUMBER

Line 4545: P_Item_Rec IN INV_ITEM_API.Item_rec_type

4541: NULL;
4542: END Delete_Cost_Details;
4543:
4544: PROCEDURE Update_Item(
4545: P_Item_Rec IN INV_ITEM_API.Item_rec_type
4546: ,P_Item_Category_Struct_Id IN NUMBER
4547: ,P_Inv_Install IN NUMBER
4548: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4549: ,P_Category_Set_Id IN NUMBER

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

4774: app_exception.raise_exception;
4775: END Update_Item;
4776:
4777: -- ------------------ LOCK_ITEM -------------------
4778: PROCEDURE Lock_Item( P_Item_Rec IN INV_ITEM_API.Item_rec_type) IS
4779:
4780: CURSOR c_item_details IS
4781: SELECT
4782: PRIMARY_UOM_CODE,

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

6104: END SYNC_IM_INDEX;
6105:
6106: -- Added as part of Bug Fix 3623450 to Check whether the master item record
6107: -- is locked. Called from item form COPY_ITEM block DONE and COPY button's W-B-P
6108: PROCEDURE Check_Master_Record_Locked( P_Item_Rec IN INV_ITEM_API.Item_rec_type) IS
6109:
6110: CURSOR c_item_name IS
6111: SELECT
6112: SEGMENT1