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 510: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

506:
507: -- -------------------- Create_Item -------------------
508: PROCEDURE Create_Item
509: (
510: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
511: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
512: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
513: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
514: , x_return_status OUT NOCOPY VARCHAR2

Line 511: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

507: -- -------------------- Create_Item -------------------
508: PROCEDURE Create_Item
509: (
510: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
511: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
512: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
513: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
514: , x_return_status OUT NOCOPY VARCHAR2
515: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

Line 522: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

518: );
519:
520: PROCEDURE Create_Item
521: (
522: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
523: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
524: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
525: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
526: , x_return_status OUT NOCOPY VARCHAR2

Line 523: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

519:
520: PROCEDURE Create_Item
521: (
522: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
523: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
524: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
525: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
526: , x_return_status OUT NOCOPY VARCHAR2
527: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

Line 537: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

533: -- -------------------- Update_Item -------------------
534:
535: PROCEDURE Update_Item
536: (
537: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
538: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
539: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
540: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
541: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

Line 538: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE

534:
535: PROCEDURE Update_Item
536: (
537: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
538: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
539: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
540: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
541: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
542: , x_return_status OUT NOCOPY VARCHAR2

Line 539: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

535: PROCEDURE Update_Item
536: (
537: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
538: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
539: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
540: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
541: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
542: , x_return_status OUT NOCOPY VARCHAR2
543: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

Line 550: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

546: );
547:
548: PROCEDURE Update_Item
549: (
550: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
551: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
552: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
553: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
554: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

Line 551: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE

547:
548: PROCEDURE Update_Item
549: (
550: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
551: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
552: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
553: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
554: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
555: , x_return_status OUT NOCOPY VARCHAR2

Line 552: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

548: PROCEDURE Update_Item
549: (
550: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
551: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
552: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
553: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
554: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
555: , x_return_status OUT NOCOPY VARCHAR2
556: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

Line 576: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR

572: -- -------------------- Get_Item ---------------------
573:
574: PROCEDURE Get_Item
575: (
576: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
577: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
578: , p_Org_ID IN NUMBER
579: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
580: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

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

573:
574: PROCEDURE Get_Item
575: (
576: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
577: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
578: , p_Org_ID IN NUMBER
579: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
580: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
581: , x_return_status OUT NOCOPY VARCHAR2

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

575: (
576: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
577: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
578: , p_Org_ID IN NUMBER
579: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
580: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
581: , x_return_status OUT NOCOPY VARCHAR2
582: , x_return_err OUT NOCOPY VARCHAR2
583: );

Line 586: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

582: , x_return_err OUT NOCOPY VARCHAR2
583: );
584:
585: PROCEDURE Interface_Handler
586: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
587: ,p_transaction_type IN VARCHAR2
588: ,p_Item_rec IN INV_ITEM_GRP.Item_Rec_Type
589: ,P_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
590: ,p_Template_Id IN NUMBER