1 PACKAGE PSP_ST_EXT AUTHID CURRENT_USER as
2 /* $Header: PSPTREXS.pls 120.4 2006/12/22 04:24:41 vdharmap noship $ */
3
4 --- PROCEDURE summary_extension;
5 -- replaced the above procedure with four procedures below for 2968684
6 procedure summary_ext_adjustment(p_adj_sum_batch_name IN VARCHAR2,
7 p_business_group_id IN NUMBER,
8 p_set_of_books_id IN NUMBER);
9
10 procedure summary_ext_actual(p_source_type IN VARCHAR2,
11 p_source_code IN VARCHAR2,
12 p_payroll_id IN NUMBER,
13 p_time_period_id IN NUMBER,
14 p_batch_name IN VARCHAR2,
15 p_business_group_id IN NUMBER,
16 p_set_of_books_id IN NUMBER);
17
18 procedure summary_ext_encumber(p_payroll_id IN NUMBER,
19 p_business_group_id IN NUMBER,
20 p_set_of_books_id IN NUMBER);
21
22 procedure summary_ext_encumber_liq(p_payroll_id IN NUMBER,
23 p_action_type IN VARCHAR2,
24 p_business_group_id IN NUMBER,
25 p_set_of_books_id IN NUMBER);
26
27 FUNCTION get_enc_amount( p_assignment_id IN NUMBER ,
28 p_element_type_id IN NUMBER,
29 p_time_period_id IN NUMBER,
30 p_asg_start_date IN DATE,
31 p_asg_end_date IN DATE)
32 return NUMBER;
33
34 PROCEDURE get_labor_enc_dates (p_project_id IN NUMBER,
35 p_task_id IN NUMBER,
36 p_award_id IN NUMBER,
37 p_expenditure_type IN VARCHAR2,
38 p_expenditure_organization_id IN NUMBER,
39 p_payroll_id IN NUMBER,
40 p_start_date OUT NOCOPY DATE,
41 p_end_date OUT NOCOPY DATE);
42
43 --- added for 5643110
44 PROCEDURE tieback_actual(p_payroll_control_id IN NUMBER,
45 p_source_type IN VARCHAR2,
46 p_period_end_date IN DATE,
47 p_gms_batch_name IN VARCHAR2,
48 p_txn_source in varchar2,
49 p_business_group_id IN NUMBER,
50 p_set_of_books_id IN NUMBER);
51
52 ----- new procedure for 5463110
53 PROCEDURE tieback_adjustment(p_payroll_control_id IN NUMBER,
54 p_adjutment_batch_name in varchar2,
55 p_gms_batch_name IN VARCHAR2,
56 p_business_group_id IN NUMBER,
57 p_set_of_books_id IN NUMBER);
58
59 END PSP_ST_EXT;