PACKAGE: APPS.PQH_SS_UTILITY

Source

1 Package pqh_ss_utility AUTHID CURRENT_USER as
2 /* $Header: pqutlswi.pkh 120.0.12010000.1 2008/07/28 13:16:26 appldev ship $*/
3 
4 procedure get_rg_eligibility(p_person_id in number,
5                             p_rptg_grp_id in number,
6                             p_eligibility_flag out nocopy varchar2,
7                             p_eligibility out nocopy varchar2);
8 
9 function get_Reporting_Group_id(
10                p_function_name varchar2,
11                p_business_group_id number) return number;
12 
13 function check_eligibility(
14                p_person_id number,
15                p_rptg_grp_id number) return boolean;
16 --
17 FUNCTION check_eligibility (
18         p_planId         IN NUMBER
19        ,p_personId       IN NUMBER
20        ,p_effectiveDate  IN DATE ) RETURN VARCHAR2;
21 --
22 --
23 PROCEDURE get_Role_Info (
24         p_roleTypeCd       IN VARCHAR2
25        ,p_businessGroupId  IN NUMBER
26        ,p_globalRoleFlag  out nocopy VARCHAR2
27        ,p_roleName        out nocopy VARCHAR2
28        ,p_roleId          out nocopy NUMBER );
29 --
30 --
31 
32 
33 FUNCTION get_pos_structure_version
34    ( p_business_group_id number)
35    RETURN  number;
36 --
37 --
38 function  check_edit_privilege (
39         p_personId        IN NUMBER
40        ,p_businessGroupId IN NUMBER ) return VARCHAR2;
41 --
42 --
43 PROCEDURE  check_edit_privilege (
44         p_personId        IN NUMBER
45        ,p_businessGroupId IN NUMBER
46        ,p_editAllowed    out nocopy VARCHAR2 ) ;
47 --
48 --
49 PROCEDURE check_edit_privilege ( p_person_id          IN NUMBER
50                                 ,p_business_group_id  IN NUMBER
51                                 ,p_transaction_status IN VARCHAR2
52                                 ,p_edit_privilege     OUT NOCOPY VARCHAR2) ;
53 --
54 --
55 
56 FUNCTION check_future_change (
57              p_txnId          IN NUMBER
58             ,p_assignmentId   IN NUMBER
59             ,p_effectiveDate  IN DATE
60             ,p_calledFrom     IN VARCHAR2 DEFAULT 'REQUEST' ) RETURN VARCHAR2;
61 --
62 --
63 FUNCTION check_pending_transaction(
64           p_txnId       IN NUMBER
65          ,p_itemType    IN VARCHAR2
66          ,p_personId    IN NUMBER
67          ,p_assignId    IN NUMBER ) RETURN VARCHAR2 ;
68 --
69 --
70 FUNCTION check_intervening_action (
71            p_txnId         IN VARCHAR2
72           ,p_assignmentId  IN NUMBER
73           ,p_effectiveDate IN DATE
74           ,p_futureChange  IN VARCHAR2 ) RETURN VARCHAR2 ;
75 --
76 --
77 FUNCTION get_business_group_id (
78         p_personId      IN NUMBER
79        ,p_effectiveDate IN DATE    ) RETURN NUMBER;
80 --
81 --
82 FUNCTION check_function_parameter (
83         p_functionId  IN NUMBER,
84         p_paramName   IN VARCHAR2 ) RETURN VARCHAR2 ;
85 --
86 --
87 L_DESCRIPTION VARCHAR2(2000); -- defined for function get_desc
88 Function get_desc (p_function VARCHAR2 ) return varchar2;
89 --
90 PROCEDURE set_datetrack_mode (
91            p_txnId           IN VARCHAR2
92           ,p_dateTrack_mode  IN VARCHAR2  );
93 --
94 --
95 FUNCTION get_assignment_startdate ( p_assignmentId IN VARCHAR2 ) RETURN DATE ;
96 --
97 function get_approval_process_version(p_itemType varchar2, p_itemKey varchar2 )
98  return varchar2;
99 --
100 --
101 FUNCTION  get_transaction_step_id (
102           p_itemType  IN VARCHAR2
103          ,p_itemKey   IN VARCHAR2
104          ,p_apiName   IN VARCHAR2 ) RETURN VARCHAR2;
105 --
106 FUNCTION chk_transaction_step_exist( p_transaction_id IN NUMBER ) RETURN VARCHAR2;
107 --
108 --
109 function plans_exists_for_rg(p_reporting_group_id number,
110                       p_business_group_id number,
111                       p_effective_date date) return varchar2;
112 --
113 end;