1 PACKAGE PSP_TEMPLATE_SELECTION
2 /* $Header: PSPTPLSLS.pls 120.1 2005/07/08 02:33 spchakra noship $*/
3
4
5 AS
6
7
8 PROCEDURE insert_into_template_history(p_payroll_action_id IN NUMBER, p_request_id OUT NOCOPY NUMBER );
9 PROCEDURE range_code(pactid IN NUMBER, sqlstr out nocopy varchar2);
10
11
12 Procedure get_final_selection_list(errBuf OUT NOCOPY VARCHAR2,
13 retCode OUT NOCOPY VARCHAR2,
14 p_request_id IN NUMBER,
15 p_person_asg_flag IN BOOLEAN
16 );
17
18
19
20
21
22 PROCEDURE get_lowest_cardinality (p_request_id IN NUMBER, p_effort_start IN
23 DATE, p_effort_end IN DATE, p_business_group_id IN NUMBER, p_set_of_books_id IN NUMBER);
24
25 PROCEDURE prepare_initial_person_list(p_request_id IN NUMBER, p_effort_start
26 IN DATE, p_effort_end IN DATE, p_business_group_id IN NUMBER, p_Set_of_books_id IN NUMBER);
27
28 PROCEDURE prune_initial_person_list(p_request_id IN NUMBER, p_effort_start IN DATE, p_effort_end IN DATE,
29 p_business_group_id IN NUMBER, p_set_of_books_id IN NUMBER);
30
31 PROCEDURE apply_exclusion_criteria(p_request_id IN NUMBER, p_effort_start DATE, p_effort_end DATE,
32 p_business_group_id IN NUMBER, p_set_of_books_id IN NUMBER);
33
34 -- Introduced the folowing procedures for UVA bug fix 4429787
35 PROCEDURE get_asg_lowest_cardinality (p_request_id IN NUMBER,
36 p_effort_start IN DATE,
37 p_effort_end IN DATE,
38 p_business_group_id IN NUMBER,
39 p_set_of_books_id IN NUMBER);
40
41 PROCEDURE prepare_initial_asg_list(p_request_id IN NUMBER,
42 p_effort_start IN DATE,
43 p_effort_end IN DATE,
44 p_business_group_id IN NUMBER,
45 p_set_of_books_id IN NUMBER);
46
47 PROCEDURE prune_initial_asg_list (p_request_id IN NUMBER,
48 p_effort_start IN DATE,
49 p_effort_end IN DATE,
50 p_business_group_id IN NUMBER,
51 p_set_of_books_id IN NUMBER);
52
53 PROCEDURE apply_asg_exclusion_criteria (p_request_id IN NUMBER,
54 p_effort_start IN DATE,
55 p_effort_end IN DATE,
56 p_business_group_id IN NUMBER,
57 p_set_of_books_id IN NUMBER);
58 -- End of changes for bug fix 4429787
59
60 PROCEDURE apply_ff_formula_exclusion(p_request_id IN NUMBER, p_effort_start DATe, p_effort_end DATE);
61
62
63 g_lookup_code varchar2(30);
64 g_exec_string varchar2(4000);
65
66
67 TYPE t_varchar_30_type is TABLE Of VARCHAR2(30) INDEX BY BINARY_INTEGER;
68 TYPE t_varchar_1_type is TABLE of VARCHAR2(1) INDEX BY BINARY_INTEGER;
69 TYPE t_num_15_type IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
70 TYPE t_num_1_type IS TABLE OF NUMBER(1) INDEX BY BINARY_INTEGER;
71
72
73
74 type template_sel_criteria_type is record
75 (
76 array_sel_criteria t_varchar_30_type
77
78 );
79
80 template_rec template_sel_criteria_type;
81
82 type template_Selection_values_type is record
83 (
84
85 array_sel_criteria t_varchar_30_type,
86 array_inc_exc_flag t_varchar_1_type,
87 array_criteria_value1 t_varchar_30_type,
88 array_criteria_value2 t_varchar_30_type,
89 array_criteria_value3 t_varchar_30_type
90 );
91
92 template_sel_criteria template_selection_values_type;
93
94 type effort_sum_criteria_type is record
95 (
96 array_sum_criteria t_varchar_30_type,
97 array_sum_order t_num_1_type,
98 array_criteria_value1 t_varchar_30_type ,
99 array_criteria_value2 t_varchar_30_type
100
101 );
102
103 eff_template_sum_rec effort_sum_criteria_type;
104
105 type person_rec_type is record
106 (
107 array_person_id t_num_15_type ,
108 array_effort_report_id t_num_15_type,
109 sum_tot t_num_15_type
110 );
111
112
113
114 FUNCTION get_parameter_value(name in varchar2, parameter_list varchar2) return varchar2;
115
116 END;