1 PACKAGE pqp_gb_ad_ee AUTHID CURRENT_USER AS
2 /* $Header: pqgbadee.pkh 120.6 2010/10/27 05:20:48 pbalu noship $ */
3 -----------------------------------------------------------------------------
4 -- OPEN_CM_ELE_ENTRIES
5 -----------------------------------------------------------------------------
6 PROCEDURE open_cm_ele_entries( p_assignment_id_o IN NUMBER
7 ,p_effective_date IN DATE
8 ,p_effective_end_date IN DATE
9 ,p_element_entry_id IN NUMBER
10 ,p_datetrack_mode IN VARCHAR2);
11
12
13
14 PROCEDURE create_term_ele_entries ( p_assignment_id IN NUMBER
15 ,p_effective_date IN DATE
16 ,p_effective_start_date IN DATE
17 ,p_effective_end_date IN DATE
18 ,p_element_entry_id IN NUMBER
19 ,p_element_link_id IN NUMBER
20 ,p_element_type_id IN NUMBER
21 );
22
23 --For bug 7013325
24 PROCEDURE UPDATE_PSI_ASS_DFF_COL(
25 p_effective_start_date date,
26 p_element_entry_id number,
27 p_assignment_id number,
28 p_element_type_id Number
29 );
30
31 --For bug 7294977: Start
32 PROCEDURE AI_VAL_REF_COURT_ORDER(
33 p_effective_start_date IN DATE
34 ,p_element_entry_id IN NUMBER
35 ,p_element_type_id IN NUMBER
36 );
37
38
39 PROCEDURE AU_VAL_REF_COURT_ORDER(
40 p_effective_date IN DATE
41 ,p_datetrack_mode IN VARCHAR2
42 ,p_effective_start_date IN DATE
43 ,p_element_entry_id IN NUMBER
44 ,p_element_type_id_o IN NUMBER
45 );
46 --For bug 7294977: End
47
48 ------------------------
49 -- BEGIN For Bug 8485686
50 ------------------------
51
52 g_global_paye_validation VARCHAR2(1) := 'Y';
53
54 g_first_assignment_id NUMBER :=-1;
55
56 g_first_assignment VARCHAR2(1) := 'Y';
57
58 TYPE g_element_entry_rec is record(eeid NUMBER(30),
59 aid NUMBER(30),
60 eff_date date); --10157179
61
62 TYPE g_element_entry_tab IS TABLE OF g_element_entry_rec INDEX BY BINARY_INTEGER;
63
64 g_element_entry_rec_tab g_element_entry_tab;
65
66 l_input_value_id1 number;
67 l_tax_code VARCHAR2(60);
68 l_input_value_id2 number;
69 l_d_tax_basis VARCHAR2(60);
70 l_input_value_id3 number;
71 l_d_refundable VARCHAR2(60);
72 l_input_value_id4 number;
73 l_d_pay_previous VARCHAR2(60);
74 l_input_value_id5 number;
75 l_d_tax_previous VARCHAR2(60);
76 l_input_value_id6 number;
77 l_authority VARCHAR2(60);
78 l_ele_information1 VARCHAR2(150);
79 l_ele_information2 VARCHAR2(150);
80
81 ------------------------
82 -- END For Bug 8485686
83 ------------------------
84
85 END pqp_gb_ad_ee;