4: -- ------------------------------------------------------------
5: -- -------------- Global variables and constants --------------
6: -- ------------------------------------------------------------
7:
8: g_MISS_CHAR VARCHAR2(1) := fnd_api.g_MISS_CHAR;
9: g_MISS_NUM NUMBER := fnd_api.g_MISS_NUM;
10: g_MISS_DATE DATE := fnd_api.g_MISS_DATE;
11:
12: -- ------------------------------------------------------
5: -- -------------- Global variables and constants --------------
6: -- ------------------------------------------------------------
7:
8: g_MISS_CHAR VARCHAR2(1) := fnd_api.g_MISS_CHAR;
9: g_MISS_NUM NUMBER := fnd_api.g_MISS_NUM;
10: g_MISS_DATE DATE := fnd_api.g_MISS_DATE;
11:
12: -- ------------------------------------------------------
13: -- -------------------- Global types --------------------
6: -- ------------------------------------------------------------
7:
8: g_MISS_CHAR VARCHAR2(1) := fnd_api.g_MISS_CHAR;
9: g_MISS_NUM NUMBER := fnd_api.g_MISS_NUM;
10: g_MISS_DATE DATE := fnd_api.g_MISS_DATE;
11:
12: -- ------------------------------------------------------
13: -- -------------------- Global types --------------------
14: -- ------------------------------------------------------
507:
508: -- -------------------- Create_Item -------------------
509: PROCEDURE Create_Item
510: (
511: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
512: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
513: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
514: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
515: , x_return_status OUT NOCOPY VARCHAR2
508: -- -------------------- Create_Item -------------------
509: PROCEDURE Create_Item
510: (
511: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
512: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
513: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
514: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
515: , x_return_status OUT NOCOPY VARCHAR2
516: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
519: );
520:
521: PROCEDURE Create_Item
522: (
523: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
524: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
525: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
526: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
527: , x_return_status OUT NOCOPY VARCHAR2
520:
521: PROCEDURE Create_Item
522: (
523: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
524: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
525: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
526: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
527: , x_return_status OUT NOCOPY VARCHAR2
528: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
539: -- -------------------- Update_Item -------------------
540:
541: PROCEDURE Update_Item
542: (
543: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
544: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
545: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
546: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
547: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
540:
541: PROCEDURE Update_Item
542: (
543: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
544: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
545: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
546: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
547: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
548: , x_return_status OUT NOCOPY VARCHAR2
541: PROCEDURE Update_Item
542: (
543: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
544: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
545: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
546: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
547: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
548: , x_return_status OUT NOCOPY VARCHAR2
549: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
552: );
553:
554: PROCEDURE Update_Item
555: (
556: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
557: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
558: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
559: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
560: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
553:
554: PROCEDURE Update_Item
555: (
556: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
557: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
558: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
559: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
560: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
561: , x_return_status OUT NOCOPY VARCHAR2
554: PROCEDURE Update_Item
555: (
556: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
557: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
558: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
559: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
560: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
561: , x_return_status OUT NOCOPY VARCHAR2
562: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
578: -- -------------------- Get_Item ---------------------
579:
580: PROCEDURE Get_Item
581: (
582: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
583: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
584: , p_Org_ID IN NUMBER
585: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
586: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
579:
580: PROCEDURE Get_Item
581: (
582: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
583: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
584: , p_Org_ID IN NUMBER
585: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
586: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
587: , x_return_status OUT NOCOPY VARCHAR2
581: (
582: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
583: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
584: , p_Org_ID IN NUMBER
585: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
586: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
587: , x_return_status OUT NOCOPY VARCHAR2
588: , x_return_err OUT NOCOPY VARCHAR2
589: );
588: , x_return_err OUT NOCOPY VARCHAR2
589: );
590:
591: PROCEDURE Interface_Handler
592: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
593: ,p_transaction_type IN VARCHAR2
594: ,p_Item_rec IN INV_ITEM_GRP.Item_Rec_Type
595: ,P_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
596: ,p_Template_Id IN NUMBER