1 PACKAGE csr_scheduler_pub AUTHID CURRENT_USER AS
2 /* $Header: CSRPSCHS.pls 120.0.12010000.1 2009/04/02 12:54:08 venjayar noship $ */
3
4 /**
5 * Retrieves the value of the given Scheduler Parameter for the current
6 * logged in session taking Application ID, Responsibility ID, User ID
7 * from FND_GLOBAL.
8 *
9 * @param p_parameter_name Name of the Parameter
10 */
11 FUNCTION get_sch_parameter_value(p_parameter_name VARCHAR2)
12 RETURN VARCHAR2;
13
14 /**
15 * Retrieves the value of the given Scheduler Parameter based on the
16 * eligibility levels given.
17 *
18 * @param p_parameter_name Name of the Parameter
19 * @param p_appl_id ID of the Application for Eligibility (Pass -9999 if no Application)
20 * @param p_resp_id ID of the Responsibility for Eligibility (Pass -9999 if no Responsibility)
21 * @param p_user_id ID of the User for Eligibility (Pass -9999 if no User)
22 * @param p_terr_id ID of the Territory for Eligibility (Optional)
23 * @param p_resource_type Type of the Resource for Eligibility (Optional)
24 * @param p_resource_id ID of the Resource for Eligibility (Optional)
25 **/
26 FUNCTION get_sch_parameter_value(
27 p_parameter_name IN VARCHAR2
28 , p_appl_id IN NUMBER
29 , p_resp_id IN NUMBER
30 , p_user_id IN NUMBER
31 , p_terr_id IN NUMBER DEFAULT NULL
32 , p_resource_type IN VARCHAR2 DEFAULT NULL
33 , p_resource_id IN NUMBER DEFAULT NULL
34 )
35 RETURN VARCHAR2;
36
37 END csr_scheduler_pub;