DBA Data[Home] [Help]

APPS.AMS_ITEM_OWNER_PVT dependencies on INV_ITEM_GRP

Line 9: -- 12/05/2000 musman Added codes for wrapping the Inv_item_grp pkg

5: -- Purpose :
6:
7: -- History :
8: -- 10/06/2000 abhola created.
9: -- 12/05/2000 musman Added codes for wrapping the Inv_item_grp pkg
10: -- so that the create_item will work.
11: -- 01/08/2001 musman Bug 1572663 fix. Raised an exception if the item status
12: -- is cancelled.
13: -- 01/09/2001 musman Added a call to the cue card for organization assignment

Line 64: ,l_inv_item_rec_in IN OUT NOCOPY INV_Item_GRP.Item_Rec_Type

60: -- 05/29/2002 musman@us created
61: --------------------------------------------------------------------------
62: PROCEDURE add_default_attributes
63: ( P_ITEM_REC_In IN Item_rec_type
64: ,l_inv_item_rec_in IN OUT NOCOPY INV_Item_GRP.Item_Rec_Type
65: ,x_return_status OUT NOCOPY VARCHAR2
66: );
67:
68: ------------------------------------------------------------------

Line 79: ,l_inv_item_rec_in IN OUT NOCOPY INV_Item_GRP.Item_Rec_Type);

75: -- 05/29/2002 musman@us created
76: --------------------------------------------------------------------------
77: PROCEDURE init_inv_item_rec(
78: p_item_rec_in IN Item_Rec_Type
79: ,l_inv_item_rec_in IN OUT NOCOPY INV_Item_GRP.Item_Rec_Type);
80:
81: -------------------------------------------------------------------------
82:
83:

Line 98: P_ITEM_REC_In IN ITEM_Rec_Type := G_MISS_ITEM_REC, /*INV_Item_GRP.Item_rec_type := INV_Item_GRP.g_miss_Item_rec,*/

94:
95: P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type := G_MISS_ITEM_OWNER_REC,
96: X_ITEM_OWNER_ID OUT NOCOPY NUMBER,
97:
98: P_ITEM_REC_In IN ITEM_Rec_Type := G_MISS_ITEM_REC, /*INV_Item_GRP.Item_rec_type := INV_Item_GRP.g_miss_Item_rec,*/
99: P_ITEM_REC_Out OUT NOCOPY ITEM_Rec_Type, /*INV_Item_GRP.Item_rec_type,*/
100: x_item_return_status OUT NOCOPY VARCHAR2,
101: x_error_tbl OUT NOCOPY Error_tbl_type /*INV_Item_GRP.Error_tbl_type*/
102:

Line 99: P_ITEM_REC_Out OUT NOCOPY ITEM_Rec_Type, /*INV_Item_GRP.Item_rec_type,*/

95: P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type := G_MISS_ITEM_OWNER_REC,
96: X_ITEM_OWNER_ID OUT NOCOPY NUMBER,
97:
98: P_ITEM_REC_In IN ITEM_Rec_Type := G_MISS_ITEM_REC, /*INV_Item_GRP.Item_rec_type := INV_Item_GRP.g_miss_Item_rec,*/
99: P_ITEM_REC_Out OUT NOCOPY ITEM_Rec_Type, /*INV_Item_GRP.Item_rec_type,*/
100: x_item_return_status OUT NOCOPY VARCHAR2,
101: x_error_tbl OUT NOCOPY Error_tbl_type /*INV_Item_GRP.Error_tbl_type*/
102:
103: )

Line 101: x_error_tbl OUT NOCOPY Error_tbl_type /*INV_Item_GRP.Error_tbl_type*/

97:
98: P_ITEM_REC_In IN ITEM_Rec_Type := G_MISS_ITEM_REC, /*INV_Item_GRP.Item_rec_type := INV_Item_GRP.g_miss_Item_rec,*/
99: P_ITEM_REC_Out OUT NOCOPY ITEM_Rec_Type, /*INV_Item_GRP.Item_rec_type,*/
100: x_item_return_status OUT NOCOPY VARCHAR2,
101: x_error_tbl OUT NOCOPY Error_tbl_type /*INV_Item_GRP.Error_tbl_type*/
102:
103: )
104:
105: IS

Line 122: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;

118: l_object_version_number NUMBER := 1;
119: l_org_id NUMBER := FND_API.G_MISS_NUM;
120: l_ITEM_OWNER_ID NUMBER;
121: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;
122: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
123: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;
124: l_error_tbl INV_Item_GRP.Error_tbl_Type ;
125: l_object_id NUMBER;
126: l_return_status VARCHAR(1);

Line 123: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;

119: l_org_id NUMBER := FND_API.G_MISS_NUM;
120: l_ITEM_OWNER_ID NUMBER;
121: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;
122: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
123: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;
124: l_error_tbl INV_Item_GRP.Error_tbl_Type ;
125: l_object_id NUMBER;
126: l_return_status VARCHAR(1);
127:

Line 124: l_error_tbl INV_Item_GRP.Error_tbl_Type ;

120: l_ITEM_OWNER_ID NUMBER;
121: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;
122: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
123: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;
124: l_error_tbl INV_Item_GRP.Error_tbl_Type ;
125: l_object_id NUMBER;
126: l_return_status VARCHAR(1);
127:
128:

Line 201: ----wrapper for INV_Item_GRP.Item_rec_type

197:
198:
199:
200: /********** Call Item Creation API **************/
201: ----wrapper for INV_Item_GRP.Item_rec_type
202: -- these cols commented by ABHOLA, added new one below.
203: IF (P_ITEM_OWNER_Rec.is_master_item = 'Y')
204: THEN
205: l_inv_item_rec_in.ITEM_NUMBER := p_item_rec_in.ITEM_NUMBER ;

Line 324: INV_Item_GRP.Create_Item

320: IF (AMS_DEBUG_HIGH_ON) THEN
321: AMS_UTILITY_PVT.debug_message('Before Calling inv api');
322: END IF;
323:
324: INV_Item_GRP.Create_Item
325: ( p_commit => P_Commit
326: , p_validation_level => p_validation_level
327: , p_Item_rec => l_inv_item_rec_in /*P_ITEM_REC_In*/
328: , x_Item_rec => l_inv_item_rec_out /*P_ITEM_REC_Out*/

Line 490: P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC,/*INV_Item_GRP.Item_rec_type := INV_Item_GRP.g_miss_Item_rec,*/

486:
487: P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type,
488: X_Object_Version_Number OUT NOCOPY NUMBER,
489:
490: P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC,/*INV_Item_GRP.Item_rec_type := INV_Item_GRP.g_miss_Item_rec,*/
491: P_ITEM_REC_Out OUT NOCOPY ITEM_rec_type ,/*INV_Item_GRP.Item_rec_type,*/
492: x_item_return_status OUT NOCOPY VARCHAR2,
493: x_Error_tbl OUT NOCOPY Error_tbl_type/*INV_Item_GRP.Error_tbl_type*/
494:

Line 491: P_ITEM_REC_Out OUT NOCOPY ITEM_rec_type ,/*INV_Item_GRP.Item_rec_type,*/

487: P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type,
488: X_Object_Version_Number OUT NOCOPY NUMBER,
489:
490: P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC,/*INV_Item_GRP.Item_rec_type := INV_Item_GRP.g_miss_Item_rec,*/
491: P_ITEM_REC_Out OUT NOCOPY ITEM_rec_type ,/*INV_Item_GRP.Item_rec_type,*/
492: x_item_return_status OUT NOCOPY VARCHAR2,
493: x_Error_tbl OUT NOCOPY Error_tbl_type/*INV_Item_GRP.Error_tbl_type*/
494:
495: )

Line 493: x_Error_tbl OUT NOCOPY Error_tbl_type/*INV_Item_GRP.Error_tbl_type*/

489:
490: P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC,/*INV_Item_GRP.Item_rec_type := INV_Item_GRP.g_miss_Item_rec,*/
491: P_ITEM_REC_Out OUT NOCOPY ITEM_rec_type ,/*INV_Item_GRP.Item_rec_type,*/
492: x_item_return_status OUT NOCOPY VARCHAR2,
493: x_Error_tbl OUT NOCOPY Error_tbl_type/*INV_Item_GRP.Error_tbl_type*/
494:
495: )
496:
497: IS

Line 534: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;

530: l_ITEM_OWNER_ID NUMBER;
531: l_ref_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type;
532: l_tar_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type := P_ITEM_OWNER_Rec;
533: l_rowid ROWID;
534: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
535: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;
536: l_error_tbl INV_Item_GRP.Error_tbl_Type ;
537:
538: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;

Line 535: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;

531: l_ref_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type;
532: l_tar_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type := P_ITEM_OWNER_Rec;
533: l_rowid ROWID;
534: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
535: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;
536: l_error_tbl INV_Item_GRP.Error_tbl_Type ;
537:
538: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;
539:

Line 536: l_error_tbl INV_Item_GRP.Error_tbl_Type ;

532: l_tar_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type := P_ITEM_OWNER_Rec;
533: l_rowid ROWID;
534: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
535: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;
536: l_error_tbl INV_Item_GRP.Error_tbl_Type ;
537:
538: l_item_return_status VARCHAR2(1) := fnd_api.g_MISS_CHAR;
539:
540: l_can_update_inv_item VARCHAR2(1);

Line 828: INV_Item_GRP.update_Item

824: l_inv_item_rec_in.SERVICE_ITEM_FLAG := 'Y';
825: END IF;
826: */
827:
828: INV_Item_GRP.update_Item
829: ( p_commit => P_Commit
830: , p_validation_level => p_validation_level
831: , p_Item_rec => l_inv_item_rec_in /*P_ITEM_REC_In*/
832: , x_Item_rec => l_inv_item_rec_out /*P_ITEM_REC_Out*/

Line 1395: ,l_inv_item_rec_in IN OUT NOCOPY INV_Item_GRP.Item_Rec_Type

1391: End is_it_status_control_attr;
1392:
1393: PROCEDURE addProdAttr(
1394: p_template_id IN NUMBER
1395: ,l_inv_item_rec_in IN OUT NOCOPY INV_Item_GRP.Item_Rec_Type
1396: ,x_return_status OUT NOCOPY VARCHAR2)
1397:
1398: IS
1399:

Line 1740: , l_inv_item_rec_in IN OUT NOCOPY INV_Item_GRP.Item_Rec_Type

1736: END addProdAttr;
1737:
1738: PROCEDURE add_default_attributes(
1739: P_ITEM_REC_In IN ITEM_Rec_Type
1740: , l_inv_item_rec_in IN OUT NOCOPY INV_Item_GRP.Item_Rec_Type
1741: , x_return_status OUT NOCOPY VARCHAR2)
1742: IS
1743:
1744:

Line 1821: ,l_inv_item_rec_in IN OUT NOCOPY INV_Item_GRP.Item_Rec_Type)

1817:
1818:
1819: PROCEDURE init_inv_item_rec(
1820: p_item_rec_in IN Item_Rec_Type
1821: ,l_inv_item_rec_in IN OUT NOCOPY INV_Item_GRP.Item_Rec_Type)
1822:
1823: IS
1824:
1825: BEGIN