DBA Data[Home] [Help]

PACKAGE: APPS.ICX_GET

Source


1 package icx_get AUTHID CURRENT_USER as
2 /* $Header: ICXGETS.pls 115.2 2001/12/05 15:54:11 pkm ship     $ */
3 
4 FUNCTION get_action_history_date (x_object_id IN NUMBER,
5                                   x_object_type_code IN VARCHAR2,
6                                   x_subtype_code IN VARCHAR2,
7                                   x_action_code IN VARCHAR2)
8                                   RETURN DATE;
9 
10 pragma restrict_references (get_action_history_date,WNDS,RNPS,WNPS);
11 
12 FUNCTION get_avail_item_count (x_vendor_id IN NUMBER,
13                                x_category_id IN NUMBER)
14                                RETURN NUMBER;
15 
16 pragma restrict_references (get_avail_item_count,WNDS,RNPS,WNPS);
17 
18 FUNCTION get_ord_item_count (x_vendor_id IN NUMBER,
19                              x_type IN VARCHAR2,
20                              x_category_id IN NUMBER)
21                              RETURN NUMBER;
22 
23 pragma restrict_references (get_ord_item_count,WNDS,RNPS,WNPS);
24 
25 FUNCTION get_gl_account (x_cc_id IN NUMBER)
26                          RETURN VARCHAR2;
27 
28 pragma restrict_references (get_gl_account,WNDS,RNPS,WNPS);
29 
30 FUNCTION get_gl_value (appl_id in number,
31                        id_flex_code in varchar2,
32                        id_flex_num in number,
33                        cc_id in number,
34                        gl_qualifier in varchar2)
35                        return varchar2;
36 
37 pragma restrict_references (get_gl_value,WNDS,WNPS);
38 
39 FUNCTION  get_person_name (x_person_id IN  NUMBER) RETURN VARCHAR2;
40 
41 pragma restrict_references (get_person_name,WNDS,WNPS);
42 end;