1 PACKAGE cn_general_utils AUTHID CURRENT_USER AS
2 -- $Header: cnsyguts.pls 120.5 2012/02/28 10:27:34 rnagaraj ship $
3
4 /*
5 Package Name
6 cn_general_utils
7 Purpose
8 This package consists of general utilities used throughout commissions.
9
10 History
11 --------------------------------------------------------------------------+
12 06-SEP-94 P Cook Created by removing the non-generation specific
13 procedures and functions from cn_utils.
14 06-DEC-94 P Cook modified get_salesrep_name to return more info
15 and renamed to get_salesrep_info
16 04-APR-96 A Saxena Added get_set_of_books_id function and pragma
17 03-JUN-96 A Saxena Added get_currency_CODE function and pragma
18 */
19
20 FUNCTION get_set_of_books_id RETURN NUMBER;
21 PRAGMA RESTRICT_REFERENCES (GET_SET_OF_BOOKS_ID, WNDS, WNPS, RNPS);
22
23 FUNCTION get_currency(p_org_id NUMBER) RETURN VARCHAR2;
24
25 FUNCTION get_currency_code RETURN VARCHAR2;
26 PRAGMA RESTRICT_REFERENCES (GET_CURRENCY_CODE, WNDS, WNPS, RNPS);
27
28 PROCEDURE get_period_info ( x_period_date IN DATE
29 ,x_period_id IN OUT NOCOPY NUMBER
30 ,x_period_name IN OUT NOCOPY VARCHAR2
31 ,x_period_status OUT NOCOPY VARCHAR2
32 ,x_start_date OUT NOCOPY DATE
33 ,x_end_date OUT NOCOPY DATE);
34 --
35 -- Procedure Name
36 -- get_meaning
37 -- Purpose
38 -- Get meaning for given lookup type and code
39 -- Arguments
40 -- lookup_code lookup type
41 -- lookup_type lookup code
42 -- meaning translated meaning
43 --
44
45 FUNCTION get_meaning(x_lookup_code VARCHAR2,
46 x_lookup_type VARCHAR2) RETURN VARCHAR2;
47
48 --
49 -- Procedure Name
50 -- get_period_id
51 -- Purpose
52 -- Get period for given date
53 --
54
55 FUNCTION get_period_id(X_period_date DATE) RETURN NUMBER;
56
57 --
58 -- Procedure Name
59 -- get_period_name
60 -- Purpose
61 -- Get period name for given period_id
62 --
63
64 FUNCTION get_period_name(X_period_id NUMBER) RETURN VARCHAR2;
65 --
66 -- Procedure Name
67 -- Get_Salesrep_info
68 -- Purpose
69 -- Get Salesrep details given a salesrep id
70 --
71
72 PROCEDURE get_salesrep_info( X_Salesrep_id NUMBER
73 ,X_Name IN OUT NOCOPY VARCHAR2
74 ,X_employee_number IN OUT NOCOPY NUMBER);
75 --
76 -- Procedure Name
77 --
78 -- Purpose
79 --
80
81 FUNCTION get_username (X_userid number) RETURN varchar2;
82
83
84 -- -------------------------------------------------------------------------+
85 -- FUNCTION: get_acc_fromperiod_id
86 -- Desc : get the accumulation period_id given the date
87 -- If the date is null, will return the least(Min) accumulation period
88 -- with period_status = 'O'
89 -- -------------------------------------------------------------------------+
90 FUNCTION get_acc_fromperiod_id(p_date DATE, p_org_id NUMBER) RETURN NUMBER;
91
92 END cn_general_utils;