PACKAGE: APPS.INV_ITEM_CATALOG_ELEM_PUB

Source

1 PACKAGE INV_ITEM_CATALOG_ELEM_PUB AUTHID CURRENT_USER AS
2 /* $Header: INVCEOIS.pls 115.0 2003/12/08 09:55:50 rvuppala noship $ */
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 -- Validation level
14 
15 g_VALIDATE_NONE     CONSTANT  NUMBER  :=  0;
16 g_VALIDATE_RULES    CONSTANT  NUMBER  :=  10;
17 g_VALIDATE_IDS      CONSTANT  NUMBER  :=  20;
18 g_VALIDATE_VALUES   CONSTANT  NUMBER  :=  30;
19 g_VALIDATE_ALL      CONSTANT  NUMBER  :=  100;
20 g_VALIDATE_LEVEL_FULL  CONSTANT  NUMBER  :=  100;
21 
22 -------------------------- Global type declarations --------------------------
23 TYPE ITEM_DESC_ELEMENT IS RECORD
24      (
25        ELEMENT_NAME         VARCHAR2(30)
26       ,ELEMENT_VALUE        VARCHAR2(30)
27       ,DESCRIPTION_DEFAULT  VARCHAR2(1)
28      );
29 
30 TYPE ITEM_DESC_ELEMENT_TABLE IS TABLE OF ITEM_DESC_ELEMENT
31                             INDEX BY BINARY_INTEGER;
32 
33 ------------------------ process_Item_Catalog_element_records ---------------------
34 
35 PROCEDURE Process_item_descr_elements
36      (
37         p_api_version        IN   NUMBER
38      ,  p_init_msg_list      IN   VARCHAR2  DEFAULT  fnd_api.g_FALSE
39      ,  p_commit_flag        IN   VARCHAR2  DEFAULT  fnd_api.g_FALSE
40      ,  p_validation_level   IN   NUMBER    DEFAULT  INV_ITEM_CATALOG_ELEM_PUB.g_VALIDATE_ALL
41      ,  p_inventory_item_id  IN   NUMBER    DEFAULT  -999
42      ,  p_item_number        IN   VARCHAR2  DEFAULT  NULL
43      ,  p_item_desc_element_table IN ITEM_DESC_ELEMENT_TABLE
44      ,  x_generated_descr    OUT NOCOPY VARCHAR2
45      ,  x_return_status      OUT NOCOPY VARCHAR2
46      ,  x_msg_count          OUT NOCOPY NUMBER
47      ,  x_msg_data           OUT NOCOPY VARCHAR2
48      );
49 
50 ------------------------ process_Item_Catalog_element_Interface_records --------------
51 
52 PROCEDURE process_Item_Catalog_grp_recs
53 (
54    ERRBUF              OUT  NOCOPY VARCHAR2
55 ,  RETCODE             OUT  NOCOPY NUMBER
56 ,  p_rec_set_id        IN   NUMBER
57 ,  p_upload_rec_flag   IN   NUMBER    DEFAULT  1
58 ,  p_delete_rec_flag   IN   NUMBER    DEFAULT  1
59 ,  p_commit_flag       IN   NUMBER    DEFAULT  1
60 ,  p_prog_appid        IN   NUMBER    DEFAULT  NULL
61 ,  p_prog_id           IN   NUMBER    DEFAULT  NULL
62 ,  p_request_id        IN   NUMBER    DEFAULT  NULL
63 ,  p_user_id           IN   NUMBER    DEFAULT  NULL
64 ,  p_login_id          IN   NUMBER    DEFAULT  NULL
65 );
66 
67 
68 ------------------------------ delete_OI_records ------------------------------
69 
70 PROCEDURE delete_OI_records
71 (
72    p_commit         IN   VARCHAR2  DEFAULT  fnd_api.g_FALSE
73 ,  p_rec_set_id     IN   NUMBER
74 ,  x_return_status  OUT  NOCOPY VARCHAR2
75 );
76 
77 
78 END INV_ITEM_CATALOG_ELEM_PUB;