1 PACKAGE LNS_UTILITY_PUB AUTHID CURRENT_USER AS
2 /*$Header: LNS_UTIL_PUBP_S.pls 120.9 2011/08/22 10:35:38 gparuchu ship $ */
3
4 FUNCTION created_by RETURN NUMBER;
5
6 FUNCTION creation_date RETURN DATE;
7
8 FUNCTION last_updated_by RETURN NUMBER;
9
10 FUNCTION last_update_date RETURN DATE;
11
12 FUNCTION last_update_login RETURN NUMBER;
13
14 FUNCTION request_id RETURN NUMBER;
15
16 FUNCTION program_id RETURN NUMBER;
17
18 FUNCTION program_application_id RETURN NUMBER;
19
20 FUNCTION application_id RETURN NUMBER;
21
22 FUNCTION program_update_date RETURN DATE;
23
24 FUNCTION user_id RETURN NUMBER;
25
26 /* added by raverma */
27 PROCEDURE Validate_any_id(p_api_version IN NUMBER := 1.0,
28 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 x_return_status OUT NOCOPY VARCHAR2,
32 p_col_id IN NUMBER,
33 p_col_name IN VARCHAR2,
34 p_table_name IN VARCHAR2);
35
36 -- added raverma 01162002
37 PROCEDURE Validate_any_varchar(p_api_version IN NUMBER := 1.0,
38 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 x_return_status OUT NOCOPY VARCHAR2,
42 p_col_value IN VARCHAR2,
43 p_col_name IN VARCHAR2,
44 p_table_name IN VARCHAR2);
45
46 PROCEDURE Validate_Lookup_CODE(p_api_version IN NUMBER := 1.0,
47 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2,
51 p_lookup_type IN VARCHAR2,
52 p_lookup_code IN VARCHAR2,
53 p_lookup_view IN VARCHAR2 := 'LNS_LOOKUPS');
54
55 Procedure getObjectVersion(p_table_name IN varchar2
56 ,p_primary_key_name IN varchar2
57 ,p_primary_key_value IN NUMBER
58 ,p_object_version_number IN NUMBER
59 ,x_object_version_number OUT NOCOPY NUMBER
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 ,x_return_status OUT NOCOPY VARCHAR2);
63
64 FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,
65 p_lookup_code IN VARCHAR2) RETURN VARCHAR2;
66
67 function convertAmount(p_from_amount in number
68 ,p_from_currency in varchar2
69 ,p_to_currency in varchar2
70 ,p_exchange_type in varchar2
71 ,p_exchange_date in date
72 ,p_exchange_rate in number) return number;
73
74 function convertRate(p_from_currency in varchar
75 ,p_to_currency in varchar
76 ,p_exchange_date in date
77 ,p_exchange_type in varchar) return number;
78
79 function Check_PSA_Enabled_Org(p_org_id in number) return varchar2;
80
81 function Check_PSA_Enabled_Current_Org return varchar2;
82
83 function Check_PSA_Enabled_Loan(p_loan_id number) return varchar2;
84
85 function IS_CREDIT_MANAGEMENT_INSTALLED return varchar2;
86
87 function Check_Desc_Flex_Setup(p_desc_flex_name varchar2) return varchar2;
88
89 function getDocumentName(p_line_type in varchar2) return varchar2;
90
91 function Is_Loan_Manager_Role return varchar2 ;
92
93 function IS_FED_FIN_ENABLED(p_org_id IN NUMBER) return varchar2 ;
94
95 function IS_FED_FIN_ENABLED return varchar2 ;
96
97 TYPE t_lookups_table IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
98
99 pg_lookups_rec t_lookups_table;
100
101 --This procedure refreshes the materialized view used for graphs
102 PROCEDURE refresh_mviews(ERRBUF OUT NOCOPY VARCHAR2
103 ,RETCODE OUT NOCOPY VARCHAR2
104 );
105
106 --This function checks if a concurrent program request is pending/running
107 --Returns 'N' if there are no pending/running requests for the conc program
108 FUNCTION is_concurrent_request_pending
109 (p_application_short_name IN VARCHAR2,
110 p_concurrent_program_name IN VARCHAR2)
111 RETURN varchar2;
112
113 function IS_CUSTOMER_CONTACT(p_fnd_user_id IN NUMBER) return varchar2 ;
114
115 function CUSTOMER_CONTACT_LOANS_COUNT(p_fnd_user_id IN NUMBER,
116 p_org_id IN NUMBER,
117 p_borrower_id IN NUMBER) return NUMBER;
118
119 FUNCTION IS_ENCUM_FIN_ENABLED(p_org_id IN NUMBER) return VARCHAR2;
120
121 FUNCTION IS_ENCUM_FIN_ENABLED return VARCHAR2;
122
123 END LNS_UTILITY_PUB;