1 PACKAGE POS_GET AUTHID CURRENT_USER AS
2 /* $Header: POSGETUS.pls 120.2 2010/02/05 04:11:18 vchiranj ship $ */
3
4 FUNCTION get_person_name (x_person_id IN NUMBER) RETURN VARCHAR2;
5
6 FUNCTION get_person_name_cache(x_person_id IN NUMBER) RETURN VARCHAR2;
7
8 FUNCTION item_flex_seg (
9 ri in rowid)
10 return varchar2;
11
12 FUNCTION get_gl_account (x_cc_id IN NUMBER)
13 RETURN VARCHAR2;
14
15 FUNCTION get_gl_value (appl_id in number,
16 id_flex_code in varchar2,
17 id_flex_num in number,
18 cc_id in number,
19 gl_qualifier in varchar2)
20 return varchar2 ;
21
22 FUNCTION get_item_config(x_item_id IN NUMBER,
23 x_org_id IN NUMBER)
24 RETURN VARCHAR2;
25
26 FUNCTION get_item_number (x_item_id IN NUMBER,
27 x_org_id IN NUMBER) RETURN VARCHAR2;
28
29 FUNCTION get_changed_amount(document_level in varchar2,
30 document_id IN NUMBER,
31 draft_id IN NUMBER) RETURN NUMBER;
32
33 FUNCTION get_chg_amt_excl_opt(document_level in varchar2,
34 document_id IN NUMBER,
35 draft_id IN NUMBER) RETURN NUMBER;
36
37 END POS_GET;