[Home] [Help]
PACKAGE: APPS.PQH_PTX_UTL
Source
1 Package pqh_ptx_utl AUTHID CURRENT_USER as
2 /* $Header: pqptxutl.pkh 120.0.12010000.1 2008/07/28 13:05:53 appldev ship $ */
3 --
4 --
5 -- ----------------------------------------------------------------------------
6 -- |------------------------< delete_attributes >------------------------|
7 -- ----------------------------------------------------------------------------
8
9 procedure delete_attributes
10 (
11 p_query_str in varchar2,
12 p_attrib_prv_tab out nocopy pqh_prvcalc.t_attname_priv
13 );
14
15 -- ----------------------------------------------------------------------------
16 -- |--------------------------< fetch_position >------------------------------|
17 -- ----------------------------------------------------------------------------
18
19 procedure fetch_position
20 (
21 p_position_transaction_id out nocopy pqh_position_transactions.position_transaction_id%TYPE,
22 p_position_id in pqh_position_transactions.position_id%TYPE,
23 p_action_date in date,
24 p_review_flag in pqh_position_transactions.review_flag%type
25 );
26 --
27 --PROCEDURE create_shadow_record(p_position_transaction_id number,p_position_id number);
28 --
29 -- ----------------------------------------------------------------------------
30 -- |----------------------------< populate_pei >------------------------------|
31 -- ----------------------------------------------------------------------------
32
33 procedure populate_pei
34 (
35 p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
36 p_position_id in pqh_position_transactions.position_id%TYPE,
37 p_populated in out nocopy varchar2
38 );
39
40 -- ----------------------------------------------------------------------------
41 -- |------------------------< alter_session_push >------------------------|
42 -- ----------------------------------------------------------------------------
43 procedure alter_session_push;
44
45
46 -- ----------------------------------------------------------------------------
47 -- |------------------------< apply_transaction >------------------------|
48 -- ----------------------------------------------------------------------------
49
50 function apply_transaction
51 ( p_transaction_id in pqh_position_transactions.position_transaction_id%TYPE ,
52 p_validate_only in varchar2 default 'NO'
53 ) return varchar2;
54
55 --------------------------------------------------------------------------------
56
57 FUNCTION reject_notification ( p_transaction_id in number) RETURN varchar2 ;
58
59 --------------------------------------------------------------------------------
60
61 FUNCTION back_notification ( p_transaction_id in number) RETURN varchar2 ;
62
63 --------------------------------------------------------------------------------
64
65 FUNCTION override_notification ( p_transaction_id in number) RETURN varchar2 ;
66
67 --------------------------------------------------------------------------------
68
69 FUNCTION apply_notification ( p_transaction_id in number) RETURN varchar2 ;
70
71 --------------------------------------------------------------------------------
72
73 FUNCTION warning_notification ( p_transaction_id in number) RETURN varchar2 ;
74
75 --------------------------------------------------------------------------------
76
77 FUNCTION fyi_notification (p_transaction_id in number) RETURN varchar2;
78
79 --------------------------------------------------------------------------------
80
81 FUNCTION respond_notification (p_transaction_id in number) RETURN varchar2;
82
83 --------------------------------------------------------------------------------
84
85 FUNCTION set_status
86 (
87 p_transaction_category_id IN pqh_transaction_categories.transaction_category_id%TYPE,
88 p_transaction_id IN pqh_worksheets.worksheet_id%TYPE,
89 p_status IN pqh_worksheets.transaction_status%TYPE
90 ) RETURN varchar2;
91
92 ---------------------------------------------------------------------------------
93
94 procedure create_ptx_shadow(p_position_transaction_id number);
95
96 --------------------------------------------------------------------------------
97
98 procedure create_pte_shadow(p_position_transaction_id number);
99
100 -------------------------------------------------------------------------------
101
102 procedure refresh_ptx(p_transaction_category_id number, p_position_transaction_id number, p_items_changed out nocopy varchar2);
103
104 -------------------------------------------------------------------------------
105
106 procedure apply_sit(p_position_transaction_id number, p_position_id number, p_txn_type varchar2);
107 --
108 -- ----------------------------------------------------------------------------
109 -- |---------------------< populate_job_requirements >------------------------|
110 -- ----------------------------------------------------------------------------
111 --
112 procedure populate_job_requirements
113 (
114 p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
115 p_position_id in pqh_position_transactions.position_id%TYPE,
116 p_populated in out nocopy varchar2
117 );
118 --
119 --------------------------------------------------------------------------------
120
121 procedure create_tjr_shadow(p_position_transaction_id number);
122
123 --------------------------------------------------------------------------------
124 procedure refresh_pte(p_transaction_category_id number, p_position_transaction_id number,
125 p_position_id number, p_pte_changed out nocopy varchar2);
126
127 -------------------------------------------------------------------------------
128
129 procedure refresh_tjr(p_transaction_category_id number, p_position_transaction_id number, p_position_id number, p_tjr_changed out nocopy varchar2);
130 --
131 -- ---------------------------------------------------------------------------
132 -- --------------------------< chk_resesrved_fte >----------------------------
133 -- ---------------------------------------------------------------------------
134 --
135 Procedure chk_reserved_fte
136 (p_position_id in number
137 ,p_fte in number
138 ,p_position_type in varchar2
139 ,p_effective_date in date
140 ,p_validation_start_date in date
141 ,p_validation_end_date in date
142 );
143 --
144 --
145 -- ---------------------------------------------------------------------------
146 -- --------------------------< apply_ptx_budgets >----------------------------
147 -- ---------------------------------------------------------------------------
148 --
149 procedure apply_ptx_budgets(p_position_transaction_id number);
150 --
151 end pqh_ptx_utl;