1 PACKAGE PAY_GB_STUDENT_LOANS_PKG AS
2 /* $Header: pygbslco.pkh 120.1 2005/06/12 05:25:10 npershad noship $ */
3 PROCEDURE Fetch_Balances(
4 p_assignment_id in PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,
5 p_element_type_id in PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_Id%TYPE,
6 p_element_name in PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
7 p_element_entry_id in PAY_RUN_RESULTS.SOURCE_ID%TYPE,
8 p_itd_balance OUT NOCOPY NUMBER,
9 p_ptd_balance OUT NOCOPY NUMBER
10 );
11
12 PROCEDURE Update_Court_Order(
13 p_datetrack_update_mode in varchar2
14 ,p_effective_date in date
15 ,p_business_group_id in number
16 ,p_element_entry_id in number
17 ,p_object_version_number in out nocopy number
18 ,p_subpriority in number
19 ,p_effective_start_date out nocopy date
20 ,p_effective_end_date out nocopy date);
21
22 PROCEDURE Create_Student_Loan(
23 P_EFFECTIVE_DATE in Date,
24 P_BUSINESS_GROUP_ID in Number,
25 P_ASSIGNMENT_ID in Number,
26 P_START_DATE in Varchar2,
27 P_END_DATE in Varchar2,
28 P_SUBPRIORITY in Number,
29 P_EFFECTIVE_START_DATE out nocopy Date,
30 P_EFFECTIVE_END_DATE out nocopy Date,
31 P_ELEMENT_ENTRY_ID out nocopy Number,
32 P_OBJECT_VERSION_NUMBER out nocopy Number);
33
34 PROCEDURE Delete_Student_Loan(
35 p_datetrack_mode in VARCHAR2
36 ,p_element_entry_id in NUMBER
37 ,p_effective_date in DATE
38 ,p_object_version_number in NUMBER);
39
40 PROCEDURE Update_Student_Loan(
41 p_datetrack_update_mode in varchar2
42 ,p_effective_date in date
43 ,p_business_group_id in number
44 ,p_element_entry_id in number
45 ,p_object_version_number in out nocopy number
46 ,p_start_date in VARCHAR2
47 ,p_end_date in VARCHAR2
48 ,p_subpriority in number
49 ,p_effective_start_date out nocopy date
50 ,p_effective_end_date out nocopy date);
51
52 /*Added below functions for bug fix 3336452*/
53
54 FUNCTION get_current_freq(p_assignment_id IN NUMBER
55 ,p_date_earned IN DATE
56 ,p_reference IN VARCHAR2
57 ) RETURN NUMBER;
58
59 FUNCTION get_current_pay_date(p_assignment_id IN NUMBER
60 ,p_date_earned IN DATE
61 ,p_reference IN VARCHAR2
62 ) RETURN DATE;
63
64
65 FUNCTION count_main_cto_entry(p_assignment_id IN NUMBER
66 ,p_date_earned IN DATE
67 ,p_reference IN VARCHAR2
68 ) RETURN NUMBER;
69
70 FUNCTION get_main_cto_pay_date(p_assignment_id IN NUMBER
71 ,p_date_earned IN DATE
72 ,p_reference IN VARCHAR2
73 ) RETURN DATE;
74
75 FUNCTION get_main_cto_freq(p_assignment_id IN NUMBER
76 ,p_date_earned IN DATE
77 ,p_reference IN VARCHAR2
78 ) RETURN NUMBER;
79
80 FUNCTION get_main_initial_debt(p_assignment_id IN NUMBER
81 ,p_date_earned IN DATE
82 ,p_reference IN VARCHAR2
83 ) RETURN NUMBER;
84
85 FUNCTION get_main_fee(p_assignment_id IN NUMBER
86 ,p_date_earned IN DATE
87 ,p_reference IN VARCHAR2
88 ) RETURN NUMBER;
89
90 FUNCTION check_ref(p_assignment_id IN NUMBER
91 ,p_date_earned IN DATE
92 ,p_reference IN VARCHAR2
93 ) RETURN VARCHAR2;
94
95 FUNCTION get_main_entry_value(p_assignment_id IN NUMBER,
96 p_date_earned IN DATE,
97 p_reference IN VARCHAR2
98 ) RETURN VARCHAR2;
99
100 /*Added below function for bug fix 4395503*/
101 FUNCTION entry_exists(p_element_entry_id IN NUMBER
102 ,p_date_earned IN DATE
103 ,p_asg_action_id IN NUMBER
104 ,p_reference IN VARCHAR2) RETURN VARCHAR2 ;
105
106
107 END PAY_GB_STUDENT_LOANS_PKG;