1 PACKAGE INV_ITEM_CATEGORY_OI AUTHID CURRENT_USER AS
2 /* $Header: INVCICIS.pls 120.5 2010/05/26 11:01:30 kjonnala ship $ */
3
4 ------------------------------ Global variables -------------------------------
5
6 g_xset_id NUMBER := fnd_api.g_MISS_NUM;
7 g_user_id NUMBER := -1;
8 g_login_id NUMBER := -1;
9 g_prog_appid NUMBER := -1;
10 g_prog_id NUMBER := -1;
11 g_request_id NUMBER := -1;
12
13
14 ------------------------ process_Item_Category_records ------------------------
15
16 PROCEDURE process_Item_Category_records
17 (
18 ERRBUF OUT NOCOPY VARCHAR2
19 , RETCODE OUT NOCOPY NUMBER
20 , p_rec_set_id IN NUMBER
21 , p_upload_rec_flag IN NUMBER := 1
22 , p_delete_rec_flag IN NUMBER := 1
23 , p_commit_flag IN NUMBER := 1
24 , p_prog_appid IN NUMBER := NULL
25 , p_prog_id IN NUMBER := NULL
26 , p_request_id IN NUMBER := NULL
27 , p_user_id IN NUMBER := NULL
28 , p_login_id IN NUMBER := NULL
29 , p_gather_stats IN NUMBER := 1 /* Added for Bug 8532728 */
30 , p_validate_rec_flag IN NUMBER DEFAULT 1 /*Fix for bug 9714783 - moved p_validate_rec_flag parameter to the end*/
31 );
32
33
34 ------------------------------ delete_OI_records ------------------------------
35
36 PROCEDURE delete_OI_records
37 (
38 p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
39 , p_rec_set_id IN NUMBER
40 , x_return_status OUT NOCOPY VARCHAR2
41 );
42
43
44 END INV_ITEM_CATEGORY_OI;