[Home] [Help]
PACKAGE: APPS.PQP_PRORATION_WRAPPER
Source
1 PACKAGE pqp_proration_wrapper AUTHID CURRENT_USER AS
2 /* $Header: pqprowiz.pkh 115.14 2002/03/11 11:47:57 pkm ship $ */
3 PROCEDURE standard_proc
4 (
5 business_group IN VARCHAR2 DEFAULT NULL ,
6 pay_mode_grade IN VARCHAR2 DEFAULT NULL ,
7 pay_mode_scale IN VARCHAR2 DEFAULT NULL ,
8 pay_mode_salary IN VARCHAR2 DEFAULT NULL ,
9 teacher_england IN VARCHAR2 DEFAULT NULL ,
10 teacher_scotland IN VARCHAR2 DEFAULT NULL ,
11 startdate IN VARCHAR2 DEFAULT NULL ,
12 basename IN VARCHAR2 DEFAULT NULL ,
13 sal_rep_name IN VARCHAR2 DEFAULT NULL ,
14 grade_rep_name IN VARCHAR2 DEFAULT NULL ,
15 ps_rep_name IN VARCHAR2 DEFAULT NULL ,
16 p_ele_gr_name IN VARCHAR2 DEFAULT NULL ,
17 p_ele_psr_name IN VARCHAR2 DEFAULT NULL
18
19 ) ;
20 PROCEDURE proration_group_proc
21 (
22 p_pgname IN VARCHAR2 DEFAULT NULL,
23 p_pg_startdate IN VARCHAR2 DEFAULT NULL,
24 p_pggrd IN VARCHAR2 DEFAULT NULL,
25 p_pggrdrt IN VARCHAR2 DEFAULT NULL,
26 p_pgchgpysc IN VARCHAR2 DEFAULT NULL,
27 p_pgchrtpysc IN VARCHAR2 DEFAULT NULL,
28 p_pgchgsal IN VARCHAR2 DEFAULT NULL,
29 p_pgtermemp IN VARCHAR2 DEFAULT NULL,
30 p_pgnewhre IN VARCHAR2 DEFAULT NULL,
31 p_pgstchenea IN VARCHAR2 DEFAULT NULL,
32 p_pgstchended IN VARCHAR2 DEFAULT NULL,
33 p_pgchgloc IN VARCHAR2 DEFAULT NULL,
34 p_business_group_pg IN VARCHAR2 DEFAULT NULL
35 );
36 PROCEDURE element_proc
37 (
38 p_ele_startdate IN VARCHAR2 DEFAULT NULL,
39 p_business_group IN VARCHAR2 DEFAULT NULL,
40 p_ele_name IN VARCHAR2 DEFAULT NULL,
41 p_ele_desc IN VARCHAR2 DEFAULT NULL,
42 p_ele_terminate IN VARCHAR2 DEFAULT NULL,
43 p_ele_uenterable IN VARCHAR2 DEFAULT NULL,
44 p_ele_addentry IN VARCHAR2 DEFAULT NULL,
45 p_ele_payment IN VARCHAR2 DEFAULT NULL,
46 p_ele_recur IN VARCHAR2 DEFAULT NULL,
47 p_ele_priclass IN VARCHAR2 DEFAULT NULL,
48 p_ele_multientry IN VARCHAR2 DEFAULT NULL,
49 p_ele_repname IN VARCHAR2 DEFAULT NULL,
50 p_ele_pg IN VARCHAR2 DEFAULT NULL,
51 p_ele_teach_eng IN VARCHAR2 DEFAULT NULL,
52 p_ele_teach_scot IN VARCHAR2 DEFAULT NULL,
53 p_ele_extra_td IN VARCHAR2 DEFAULT NULL,
54 p_ele_extra_psv IN VARCHAR2 DEFAULT NULL,
55 p_ele_extra_qualifier IN VARCHAR2 DEFAULT NULL,
56 p_ele_extra_fte IN VARCHAR2 DEFAULT NULL,
57 p_ele_extra_sh IN VARCHAR2 DEFAULT NULL
58
59 );
60 PROCEDURE input_value_proc
61 (
62 p_ipvalue_name IN VARCHAR2 DEFAULT NULL,
63 p_ipvalue_uom IN VARCHAR2 DEFAULT NULL,
64 p_ipvalue_required IN VARCHAR2 DEFAULT NULL,
65 p_ipvalue_uenterble IN VARCHAR2 DEFAULT NULL,
66 p_ipvalue_dfltval IN VARCHAR2 DEFAULT NULL,
67 p_ipvalue_lkpval IN VARCHAR2 DEFAULT NULL,
68 p_ipvalue_hotdflt IN VARCHAR2 DEFAULT NULL,
69 p_ipvalue_formula IN VARCHAR2 DEFAULT NULL,
70 p_ipvalue_minimum IN VARCHAR2 DEFAULT NULL,
71 p_ipvalue_maximum IN VARCHAR2 DEFAULT NULL,
72 p_ipvalue_error IN VARCHAR2 DEFAULT NULL,
73 p_ipvalue_dispseq IN VARCHAR2 DEFAULT NULL,
74 p_ipvalue_dbitem IN VARCHAR2 DEFAULT NULL,
75 p_business_group_ipv IN VARCHAR2 DEFAULT NULL,
76 p_ipvalue_startdate IN VARCHAR2 DEFAULT NULL,
77 p_ele_name_ipv IN VARCHAR2 DEFAULT NULL
78 );
79 PROCEDURE formula_proc
80 (
81 p_business_group_fr IN VARCHAR2 DEFAULT NULL,
82 p_ele_name_fr IN VARCHAR2 DEFAULT NULL,
83 p_ele_payment_fr IN VARCHAR2 DEFAULT NULL,
84 p_ele_startdate_fr IN VARCHAR2 DEFAULT NULL,
85 p_ele_teach_eng_fr IN VARCHAR2 DEFAULT NULL,
86 p_ele_teach_scot_fr IN VARCHAR2 DEFAULT NULL,
87 p_ele_priclass_fr IN VARCHAR2 DEFAULT NULL
88 );
89 FUNCTION get_contract_type
90 (
91 p_assignment_id IN NUMBER,
92 p_effective_date IN DATE
93 ) RETURN VARCHAR;
94 END pqp_proration_wrapper;