DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_PUB dependencies on INV_ITEM_CATEGORY_PUB

Line 1: PACKAGE BODY INV_ITEM_CATEGORY_PUB AS

1: PACKAGE BODY INV_ITEM_CATEGORY_PUB AS
2: /* $Header: INVPCATB.pls 120.12.12020000.2 2012/07/09 08:11:32 asugandh ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'INV_ITEM_CATEGORY_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'INV_ITEM_CATEGORY_PUB';

1: PACKAGE BODY INV_ITEM_CATEGORY_PUB AS
2: /* $Header: INVPCATB.pls 120.12.12020000.2 2012/07/09 08:11:32 asugandh ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'INV_ITEM_CATEGORY_PUB';
6: G_INVENTORY_APP_ID CONSTANT NUMBER := 401;
7: G_INVENTORY_APP_SHORT_NAME CONSTANT VARCHAR2(3) := 'INV';
8: G_CAT_FLEX_CODE CONSTANT VARCHAR2(4) := 'MCAT';
9:

Line 549: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE,

545: ----------------------------------------------------------------------------
546: PROCEDURE Preprocess_Category_Rec
547: (
548: p_operation IN NUMBER,
549: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE,
550: x_category_rec OUT NOCOPY INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE
551:
552: ) IS
553:

Line 550: x_category_rec OUT NOCOPY INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE

546: PROCEDURE Preprocess_Category_Rec
547: (
548: p_operation IN NUMBER,
549: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE,
550: x_category_rec OUT NOCOPY INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE
551:
552: ) IS
553:
554: l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;

Line 554: l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;

550: x_category_rec OUT NOCOPY INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE
551:
552: ) IS
553:
554: l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;
555: l_flexstr_exists VARCHAR2(1);
556:
557: CURSOR get_structure_id(p_structure_code VARCHAR) IS
558: SELECT id_flex_num

Line 1326: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE

1322: ----------------------------------------------------------------------------
1323: PROCEDURE Flex_Validate
1324: (
1325: p_operation IN NUMBER,
1326: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE
1327: ) IS
1328: l_category_id NUMBER;
1329: l_structure_id NUMBER;
1330: l_success BOOLEAN;

Line 1571: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE,

1567: x_return_status OUT NOCOPY VARCHAR2 ,
1568: x_errorcode OUT NOCOPY NUMBER,
1569: x_msg_count OUT NOCOPY NUMBER ,
1570: x_msg_data OUT NOCOPY VARCHAR2 ,
1571: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE,
1572: x_category_id OUT NOCOPY NUMBER
1573: )
1574: IS
1575: -- Start OF comments

Line 1597: l_category_rec INV_ITEM_CATEGORY_PUB.category_rec_type;

1593: l_api_version CONSTANT NUMBER := 1.0;
1594: l_row_count NUMBER;
1595:
1596: -- General variables
1597: l_category_rec INV_ITEM_CATEGORY_PUB.category_rec_type;
1598: l_category_id NUMBER;
1599: l_success BOOLEAN; --boolean for descr. flex valiation
1600: l_row_id VARCHAR2(20);
1601: l_sys_date DATE := Sysdate;

Line 1807: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE

1803: x_return_status OUT NOCOPY VARCHAR2 ,
1804: x_errorcode OUT NOCOPY NUMBER,
1805: x_msg_count OUT NOCOPY NUMBER ,
1806: x_msg_data OUT NOCOPY VARCHAR2 ,
1807: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE
1808: )
1809: IS
1810:
1811: -- Start OF comments

Line 1831: l_category_rec INV_ITEM_CATEGORY_PUB.category_rec_type;

1827: l_api_version CONSTANT NUMBER := 1.0;
1828: l_row_count NUMBER;
1829:
1830: -- General variables
1831: l_category_rec INV_ITEM_CATEGORY_PUB.category_rec_type;
1832: l_success BOOLEAN; --boolean for descr. flex valiation
1833:
1834:
1835: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2680: RETURN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE IS

2676: -----------------------------------------------------------------------------
2677: -- 7. Get_Category_Rec_Type
2678: ----------------------------------------------------------------------------
2679: FUNCTION Get_Category_Rec_Type
2680: RETURN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE IS
2681: l_category_rec_type INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE ;
2682: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2683: BEGIN
2684: RETURN l_category_rec_type;

Line 2681: l_category_rec_type INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE ;

2677: -- 7. Get_Category_Rec_Type
2678: ----------------------------------------------------------------------------
2679: FUNCTION Get_Category_Rec_Type
2680: RETURN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE IS
2681: l_category_rec_type INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE ;
2682: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2683: BEGIN
2684: RETURN l_category_rec_type;
2685: END;

Line 2693: x_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE

2689: --Bug: 2645153 validating structure and iProcurement flags
2690: ----------------------------------------------------------------------------
2691: PROCEDURE Validate_iProcurements_flags
2692: (
2693: x_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE
2694: ) IS
2695:
2696: l_po_structure_id NUMBER;
2697: --Bug: 2645153 added coide to get purchasing category structure id

Line 3641: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE,

3637: --* End of code for Bug #3991044
3638:
3639: /* Add this procedure by geguo for bug 8547305 */
3640: PROCEDURE Get_Category_Id_From_Cat_Rec(
3641: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE,
3642: x_category_id OUT NOCOPY NUMBER,
3643: x_return_status OUT NOCOPY VARCHAR2,
3644: x_msg_data OUT NOCOPY VARCHAR2
3645: )IS

Line 3646: l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;

3642: x_category_id OUT NOCOPY NUMBER,
3643: x_return_status OUT NOCOPY VARCHAR2,
3644: x_msg_data OUT NOCOPY VARCHAR2
3645: )IS
3646: l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;
3647: l_category_id NUMBER;
3648: l_structure_id NUMBER;
3649: l_success BOOLEAN;
3650: l_concat_segs VARCHAR2(2000) ;

Line 3792: END INV_ITEM_CATEGORY_PUB;

3788:
3789: END Get_Category_Id_From_Cat_Rec;
3790:
3791:
3792: END INV_ITEM_CATEGORY_PUB;