[Home] [Help]
PACKAGE: APPS.EGO_ITEM_COMPARE_PKG
Source
1 PACKAGE EGO_ITEM_COMPARE_PKG AS
2 /* $Header: EGOPICMS.pls 120.1 2007/04/18 18:29:25 ssarnoba ship $ */
3
4
5 -- ===============================================
6 -- CONSTANTS for package
7 -- ===============================================
8 --
9 -- Package Name
10 --
11 G_PACKAGE_NAME VARCHAR2(30) := 'EGO_ITEM_COMPARE_PKG';
12 --
13 -- Date Format that will be used for logging messages
14 --
15 G_DATE_FORMAT VARCHAR2(30) := 'SYYYY-MM-DD HH24:MI:SS';
16
17 --
18 -- Data Level Names
19 --
20 G_ITEM_LEVEL_NAME VARCHAR2(20) := 'ITEM_LEVEL';
21
22 --
23 -- Attribute Group Defaulting Behavior
24 --
25
26 G_DEFAULTING_AG EGO_ATTR_GROUP_DL.DEFAULTING%TYPE := 'D';
27 -- VARCHAR2(30)
28 G_INHERITED_AG EGO_ATTR_GROUP_DL.DEFAULTING%TYPE := 'I';
29 -- VARCHAR2(30)
30
31 --
32 -- Return values for RETCODE parameter (standard for concurrent programs)
33 --
34 RETCODE_SUCCESS NUMBER := 0;
35 RETCODE_WARNING NUMBER := 1;
36 RETCODE_ERROR NUMBER := 2;
37
38 -- =================================================================
39 -- Global variables
40 -- =================================================================
41
42 --Example :
43 --G_TRACE_ON NUMBER := 0; -- Log ON state
44
45 -- =========================
46 -- PROCEDURES AND FUNCTIONS
47 -- =========================
48
49
50 FUNCTION Get_Item_Attr_Val (
51 p_inventory_item_id IN VARCHAR2
52 ,p_organization_id IN VARCHAR2
53 ,p_attr_name IN VARCHAR2
54 ) RETURN VARCHAR2;
55 -- Start OF comments
56 -- API name : Get the Column value for the Item
57 -- TYPE : Public (Called by Item compare VO)
58 -- Pre-reqs : None
59 -- FUNCTION : To retrieve from MTL_SYSTEM_ITEMS, corresponding
60 -- column value, and return
61 -- Parameters:
62 -- IN :
63 --
64 -- p_inventory_item_id IN VARCHAR2
65 -- Primary Key column 1 value
66 --
67 -- p_organization_id IN VARCHAR2
68 -- Primary Key column 2 value
69 --
70 -- p_attr_name IN VARCHAR2
71 -- Item Attribute name
72 --
73 -- p_failed_priv_check_str IN VARCHAR2
74 -- String to return if privilege check fails;
75 -- for example, perhaps formatted text for a
76 -- "lock" image, or some other such string
77 --
78 -- p_data_level_name IN VARCHAR2
79
80 FUNCTION Get_User_Attr_Val (
81 p_appl_id IN NUMBER
82 ,p_attr_grp_type IN VARCHAR2
83 ,p_attr_grp_name IN VARCHAR2
84 ,p_attr_name IN VARCHAR2
85 ,p_inventory_item_id IN VARCHAR2
86 ,p_organization_id IN VARCHAR2
87 ,p_data_level_name IN VARCHAR2
88 ,p_failed_priv_check_str IN VARCHAR2 DEFAULT NULL
89 )
90 RETURN VARCHAR2;
91
92 END EGO_ITEM_COMPARE_PKG;