1 Package pqh_ss_print AUTHID CURRENT_USER as
2 /* $Header: pqprtswi.pkh 120.1 2005/06/07 18:11:27 sgudiwad noship $ */
3
4 PROCEDURE set_eff_dte_for_refresh_atts;
5
6 PROCEDURE populate_temp_data(
7 p_Transaction_Id IN VARCHAR2 ,
8 p_session_id OUT NOCOPY VARCHAR2,
9 p_effective_date IN DATE,
10 p_doc_short_name IN VARCHAR2 );
11
12 TYPE params_value_record is RECORD (
13 param_name varchar2(4000),
14 param_value varchar2(4000),
15 param_data_type varchar2(2));
16 TYPE params_value_table is TABLE of params_value_record index by binary_integer;
17 params_table params_value_table;
18
19 FUNCTION get_function_parameter_value(
20 p_parameter_name IN VARCHAR2,
21 p_transaction_id IN VARCHAR2,
22 p_type_code IN VARCHAR2 default 'PRE',
23 p_effective_date IN VARCHAR2) RETURN VARCHAR2;
24
25 FUNCTION set_document_data(p_tag_name IN varchar2, p_tag_value IN varchar2) return NUMBER;
26
27 FUNCTION get_session_details (p_txn_id OUT NOCOPY NUMBER, p_session_id OUT NOCOPY NUMBER, p_effective_date OUT NOCOPY DATE) return number;
28
29 -- Conversion functions are added here for attributes
30 FUNCTION get_table_route_id(p_table_alias IN varchar2 ) RETURN VARCHAR2;
31
32 FUNCTION get_tenure_status (p_lookup_code varchar2) RETURN VARCHAR2;
33
34 FUNCTION get_qualification (p_qualification_type_id varchar2) RETURN VARCHAR2;
35
36 FUNCTION get_award_status (p_award_id varchar2) RETURN VARCHAR2;
37
38 FUNCTION get_tuition_method (p_tuition_id varchar2) RETURN VARCHAR2;
39
40 FUNCTION get_currency_meaning(p_currency_code varchar2) RETURN VARCHAR2;
41
42 FUNCTION get_person_title (p_title_code varchar2) RETURN VARCHAR2;
43
44 FUNCTION get_gender (p_gender_code varchar2) RETURN VARCHAR2;
45
46 FUNCTION get_marital_status(p_marital_code varchar2) RETURN VARCHAR2;
47
48 FUNCTION get_termination_reason (p_termination_code varchar2) RETURN VARCHAR2;
49
50 FUNCTION get_work_schedule_frequency (p_freq_code varchar2) RETURN VARCHAR2;
51
52 FUNCTION get_employee_category (p_category_code varchar2) RETURN VARCHAR2;
53
54 FUNCTION get_employment_category (p_category_code varchar2) RETURN VARCHAR2;
55
56 FUNCTION get_yes_no (p_lookup_code varchar2) RETURN VARCHAR2;
57
58 FUNCTION get_establishment (p_establishment_id varchar2) RETURN VARCHAR2;
59
60 FUNCTION get_person_latest_name (p_person_id varchar2) RETURN VARCHAR2;
61
62 FUNCTION get_person_brief_name (p_person_id varchar2) RETURN VARCHAR2;
63
64 FUNCTION decode_payroll_latest_name (p_payroll_id varchar2) RETURN VARCHAR2;
65
66 FUNCTION decode_bargaining_unit_code (p_bargaining_unit_code IN VARCHAR2) RETURN VARCHAR2;
67
68 FUNCTION decode_collective_agreement(p_collective_agreement_id IN NUMBER) RETURN VARCHAR2;
69
70 FUNCTION decode_contract(p_contract_id IN NUMBER) RETURN VARCHAR2;
71
72 FUNCTION get_user_status(p_assignment_status_type_id IN NUMBER) RETURN VARCHAR2;
73
74 FUNCTION get_change_reason(p_reason_code IN VARCHAR2) RETURN VARCHAR2;
75
76 --
77 -- Following procedure will be used to delete the temp data day earlier to sysdate(effective date)
78 -- from table pqh_ss_print_label_temp.
79 -- The data get generated in this table as on when user visit the Document Create Page / Document Review Page
80 -- This table contains the attribute label prompts used in SSHR transactions.
81 --
82
83 PROCEDURE purge_temp_data(p_effective_date date default trunc(sysdate));
84
85 PROCEDURE replace_where_clause_params(p_where_clause_in IN PQH_TABLE_ROUTE.where_clause%TYPE,
86 p_where_clause_out OUT NOCOPY PQH_TABLE_ROUTE.where_clause%TYPE);
87 FUNCTION decode_value(p_lookup_code varchar2) RETURN VARCHAR2;
88 FUNCTION get_salary(p_assignment_id per_assignments_f.assignment_type%TYPE) RETURN VARCHAR2;
89 FUNCTION get_currency(p_pay_basis_id per_pay_bases.pay_basis_id%TYPE) RETURN VARCHAR2;
90 FUNCTION get_change_amount(p_pay_proposal_id per_pay_proposals.pay_proposal_id%Type) Return Varchar2;
91 FUNCTION get_change_percent(p_pay_proposal_id per_pay_proposals.pay_proposal_id%Type) Return Varchar2;
92
93 /* -----------------------------------------------------------
94 Procedure/Functions to support compensation workbench
95 BEGIN
96 ----------------------------------------------------------- */
97
98 procedure populate_cwb_data(
99 p_group_per_in_ler_id in number,
100 p_group_plan_id in number,
101 p_lf_evt_ocrd_dt in date,
102 p_doc_short_name in varchar2,
103 p_session_id out nocopy varchar2,
104 p_effective_date in date default sysdate) ;
105 --
106 /* -----------------------------------------------------------
107 END Supporting proc/func for CWB
108 ----------------------------------------------------------- */
109 END pqh_ss_print;