1 PACKAGE psp_adj_driver AS
2 /*$Header: PSPLDTRS.pls 120.2 2006/10/19 06:30:03 dpaudel noship $*/
3
4 PROCEDURE load_table(errbuf OUT NOCOPY VARCHAR2,
5 retcode OUT NOCOPY VARCHAR2,
6 p_person_id IN NUMBER,
7 p_assignment_id IN NUMBER,
8 --- p_element_type_id IN NUMBER, commented for DA-ENH
9 p_begin_date IN DATE,
10 p_end_date IN DATE,
11 p_adjust_by IN VARCHAR2,
12 p_currency_code IN VARCHAR2, -- Introduced for bug fix 2916848
13 p_run_id IN NUMBER,
14 p_business_group_id IN NUMBER,
15 p_set_of_books_id IN NUMBER);
16
17 PROCEDURE generate_lines(errbuf OUT NOCOPY VARCHAR2,
18 retcode OUT NOCOPY VARCHAR2,
19 p_person_id IN NUMBER,
20 p_assignment_id IN NUMBER,
21 ---p_element_type_id IN NUMBER, commented for DA-ENH
22 p_batch_name IN VARCHAR2,
23 p_batch_comments IN VARCHAR2,
24 p_run_id IN NUMBER,
25 p_gl_posting_override_date IN DATE DEFAULT NULL,
26 p_distribution_start_date IN date,
27 p_distribution_end_date IN date,
28 p_business_group_id IN number,
29 p_set_of_books_id IN number,
30 p_employee_full_name IN VARCHAR2,
31 p_assignment_number IN VARCHAR2,
32 ---p_earnings_element IN VARCHAR2, commented for DA-ENH
33 p_time_out IN NUMBER,
34 p_adjust_by IN VARCHAR2, -- added for DA-ENH
35 p_currency_code IN VARCHAR2, -- Introduced for bug fix 2916848
36 p_defer_autopop_param IN VARCHAR2, --Introduced for Bug 3548388
37 p_begin_date IN DATE, --Introduced for Bug 3548388
38 p_adjustment_line_id OUT NOCOPY NUMBER, --Introduced for Bug 3548388
39 p_element_status OUT NOCOPY VARCHAR2); --Introduced for Bug 3548388
40
41 PROCEDURE load_approval_table(errbuf OUT NOCOPY VARCHAR2,
42 retcode OUT NOCOPY VARCHAR2,
43 p_batch_name IN VARCHAR2,
44 p_run_id IN NUMBER,
45 p_business_group_id IN NUMBER,
46 p_set_of_books_id IN NUMBER);
47
48 PROCEDURE get_approval_header(errbuf OUT NOCOPY VARCHAR2,
49 retcode OUT NOCOPY VARCHAR2,
50 p_batch_name IN VARCHAR2,
51 p_business_group_id IN NUMBER,
52 p_set_of_books_id IN NUMBER,
53 l_full_name OUT NOCOPY VARCHAR2,
54 l_employee_number OUT NOCOPY VARCHAR2,
55 l_assignment_number OUT NOCOPY VARCHAR2,
56 l_assignment_organization OUT NOCOPY VARCHAR2,
57 l_begin_date OUT NOCOPY DATE,
58 l_end_date OUT NOCOPY DATE,
59 l_currency_code OUT NOCOPY VARCHAR2,
60 l_batch_comments OUT NOCOPY VARCHAR2);
61
62 PROCEDURE update_adjustment_ctrl_comment(errbuf OUT NOCOPY VARCHAR2,
63 retcode OUT NOCOPY VARCHAR2,
64 p_batch_name IN VARCHAR2,
65 p_comments IN VARCHAR2);
66
67 PROCEDURE INSERT_PSP_CLEARING_ACCOUNT(errbuf out NOCOPY VARCHAR2,
68 retcode out NOCOPY VARCHAR2,
69 p_reversing_gl_ccid IN NUMBER,
70 p_comments IN VARCHAR2,
71 p_business_group_id IN Number,
72 p_set_of_books_id IN Number,
73 p_payroll_id IN Number,
74 p_rowid OUT NOCOPY VARCHAR2 );
75
76 PROCEDURE UPDATE_PSP_CLEARING_ACCOUNT(errbuf out NOCOPY VARCHAR2,
77 retcode out NOCOPY VARCHAR2,
78 p_reversing_gl_ccid IN NUMBER,
79 p_comments IN VARCHAR2,
80 p_business_group_id IN Number,
81 p_set_of_books_id IN Number,
82 p_payroll_id IN Number,
83 p_rowid IN VARCHAR2 );
84
85 PROCEDURE DELETE_PSP_CLEARING_ACCOUNT(errbuf out NOCOPY VARCHAR2,
86 retcode out NOCOPY VARCHAR2,
87 p_reversing_gl_ccid IN NUMBER,
88 p_business_group_id IN Number,
89 p_set_of_books_id IN Number,
90 p_rowid IN VARCHAR2);
91
92 PROCEDURE LOCK_ROW_PSP_CLEARING_ACCOUNT (
93 p_business_group_id IN NUMBER,
94 p_set_of_books_id IN NUMBER,
95 p_reversing_gl_ccid IN NUMBER,
96 p_comments IN VARCHAR2,
97 p_payroll_id IN NUMBER);
98
99 /* commented for DA-ENH
100 PROCEDURE mark_adj_begin(errbuf OUT NOCOPY VARCHAR2,
101 retcode OUT NOCOPY VARCHAR2,
102 p_person_id IN NUMBER,
103 p_assignment_id IN NUMBER,
104 p_element_type_id IN NUMBER,
105 p_begin_date IN DATE,
106 p_end_date IN DATE,
107 p_run_id IN NUMBER,
108 p_business_group_id in number,
109 p_set_of_books_id in number);
110
111 PROCEDURE mark_adj_end(p_run_id IN VARCHAR2);
112
113 PROCEDURE mark_batch_in_use(p_batch_name IN VARCHAR2);
114
115 PROCEDURE unmark_batch_in_use(p_batch_name IN VARCHAR2);
116 */
117
118 PROCEDURE undo_adjustment(p_batch_name IN VARCHAR2,
119 p_business_group_id IN NUMBER,
120 p_set_of_books_id IN NUMBER,
121 p_comments IN VARCHAR2,
122 errbuf OUT NOCOPY VARCHAR2,
123 return_code OUT NOCOPY NUMBER);
124 -- added following procedure for DA-ENH
125 PROCEDURE validate_proj_before_transfer
126 (p_run_id IN NUMBER,
127 p_acct_group_id IN NUMBER,
128 p_person_id IN NUMBER,
129 p_project_id IN NUMBER,
130 p_task_id IN NUMBER,
131 p_award_id IN NUMBER DEFAULT NULL,
132 p_expenditure_type IN VARCHAR2,
133 p_expenditure_org_id IN NUMBER,
134 p_error_flag OUT NOCOPY VARCHAR2,
135 p_error_status OUT NOCOPY VARCHAR2,
136 p_effective_date OUT NOCOPY DATE);
137 END;