eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.6.12000000.4 2007/07/26 10:53:09 arattan 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.6.12000000.4 2007/07/26 10:53:09 arattan 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 1307: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE

1303: ----------------------------------------------------------------------------
1304: PROCEDURE Flex_Validate
1305: (
1306: p_operation IN NUMBER,
1307: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE
1308: ) IS
1309: l_category_id NUMBER;
1310: l_structure_id NUMBER;
1311: l_success BOOLEAN;

Line 1552: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE,

1548: x_return_status OUT NOCOPY VARCHAR2 ,
1549: x_errorcode OUT NOCOPY NUMBER,
1550: x_msg_count OUT NOCOPY NUMBER ,
1551: x_msg_data OUT NOCOPY VARCHAR2 ,
1552: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE,
1553: x_category_id OUT NOCOPY NUMBER
1554: )
1555: IS
1556: -- Start OF comments

Line 1578: l_category_rec INV_ITEM_CATEGORY_PUB.category_rec_type;

1574: l_api_version CONSTANT NUMBER := 1.0;
1575: l_row_count NUMBER;
1576:
1577: -- General variables
1578: l_category_rec INV_ITEM_CATEGORY_PUB.category_rec_type;
1579: l_category_id NUMBER;
1580: l_success BOOLEAN; --boolean for descr. flex valiation
1581: l_row_id VARCHAR2(20);
1582: l_sys_date DATE := Sysdate;

Line 1788: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE

1784: x_return_status OUT NOCOPY VARCHAR2 ,
1785: x_errorcode OUT NOCOPY NUMBER,
1786: x_msg_count OUT NOCOPY NUMBER ,
1787: x_msg_data OUT NOCOPY VARCHAR2 ,
1788: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE
1789: )
1790: IS
1791:
1792: -- Start OF comments

Line 1812: l_category_rec INV_ITEM_CATEGORY_PUB.category_rec_type;

1808: l_api_version CONSTANT NUMBER := 1.0;
1809: l_row_count NUMBER;
1810:
1811: -- General variables
1812: l_category_rec INV_ITEM_CATEGORY_PUB.category_rec_type;
1813: l_success BOOLEAN; --boolean for descr. flex valiation
1814:
1815:
1816: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2602: RETURN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE IS

2598: -----------------------------------------------------------------------------
2599: -- 7. Get_Category_Rec_Type
2600: ----------------------------------------------------------------------------
2601: FUNCTION Get_Category_Rec_Type
2602: RETURN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE IS
2603: l_category_rec_type INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE ;
2604: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2605: BEGIN
2606: RETURN l_category_rec_type;

Line 2603: l_category_rec_type INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE ;

2599: -- 7. Get_Category_Rec_Type
2600: ----------------------------------------------------------------------------
2601: FUNCTION Get_Category_Rec_Type
2602: RETURN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE IS
2603: l_category_rec_type INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE ;
2604: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2605: BEGIN
2606: RETURN l_category_rec_type;
2607: END;

Line 2615: x_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE

2611: --Bug: 2645153 validating structure and iProcurement flags
2612: ----------------------------------------------------------------------------
2613: PROCEDURE Validate_iProcurements_flags
2614: (
2615: x_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE
2616: ) IS
2617:
2618: l_po_structure_id NUMBER;
2619: --Bug: 2645153 added coide to get purchasing category structure id

Line 3533: END INV_ITEM_CATEGORY_PUB;

3529: END Update_Category_Assignment;
3530: --* End of code for Bug #3991044
3531:
3532:
3533: END INV_ITEM_CATEGORY_PUB;