[Home] [Help]
PACKAGE: APPS.PSP_ENC_UPDATE_LINES
Source
1 PACKAGE PSP_ENC_UPDATE_LINES AUTHID CURRENT_USER AS
2 /* $Header: PSPENUPS.pls 115.20 2004/03/04 23:13:06 vdharmap ship $ */
3 Procedure Update_Enc_lines
4 (errbuf out NOCOPY varchar2,
5 retcode out NOCOPY varchar2,
6 p_payroll_id IN Number,
7 p_enc_line_type IN VARCHAR2,
8 p_business_group_id IN NUMBER,
9 p_set_of_books_id IN NUMBER);
10
11
12 Procedure verify_changes (p_payroll_id IN NUMBER,
13 p_business_group_id IN NUMBER,
14 p_set_of_books_id IN NUMBER,
15 p_enc_line_type IN VARCHAR2, --Added for bug 2143723.
16 l_retcode OUT NOCOPY VARCHAR2);
17
18
19 --Procedure clean_up_when_error; --Commented for Enh. Restart Update Encumbrance Process.
20
21 /*UnCommented procedure for Enh. Restart Update Encumbrance Process. */
22 PROCEDURE move_qkupd_rec_to_hist( p_payroll_id IN NUMBER,
23 p_enc_line_type IN VARCHAR2,
24 p_business_group_id IN NUMBER,
25 p_set_of_books_id IN NUMBER,
26 p_return_status OUT NOCOPY VARCHAR2);
27
28 /* Added for Enh. Restart Update Encumbrance Process*/
29 PROCEDURE cleanup_on_success ( p_enc_line_type IN VARCHAR2,
30 p_payroll_id IN NUMBER,
31 p_business_group_id IN NUMBER,
32 p_set_of_books_id IN NUMBER,
33 p_invalid_suspense IN VARCHAR2,
34 p_return_status OUT NOCOPY VARCHAR2);
35
36 g_error_api_path VARCHAR2(500); --Added for bug 21437123.
37
38 /* commented for Enh. 2143723
39 FUNCTION backtrack(p_time_period_id IN NUMBER,p_enc_line_type VARCHAR2) return BOOLEAN;
40 --Added parameter p_enc_line_type to the function. Bug 2143723.
41 End of Enh. fix 2143723 */
42
43 PROCEDURE ROLLBACK_REJECTED_ASG (p_payroll_id in integer,
44 p_action_type in varchar2,
45 p_gms_batch_name in varchar2,
46 p_accepted_group_id in integer,
47 p_rejected_group_id in integer,
48 p_run_id in integer,
49 p_business_group_id in integer,
50 p_set_of_books_id in integer,
51 p_return_status out nocopy varchar2);
52 END;