DBA Data[Home] [Help]

APPS.INV_ITEM_GRP dependencies on FND_API

Line 8: g_MISS_CHAR VARCHAR2(1) := fnd_api.g_MISS_CHAR;

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: -- ------------------------------------------------------

Line 9: g_MISS_NUM NUMBER := fnd_api.g_MISS_NUM;

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 --------------------

Line 10: g_MISS_DATE DATE := fnd_api.g_MISS_DATE;

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: -- ------------------------------------------------------

Line 511: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

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

Line 512: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

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

Line 523: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

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

Line 524: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

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

Line 543: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

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

Line 544: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE

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

Line 545: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

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

Line 556: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

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

Line 557: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE

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

Line 558: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

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

Line 582: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR

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

Line 583: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM

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

Line 585: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR

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: );

Line 592: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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