1 PACKAGE PA_SWEEPER AUTHID CURRENT_USER AS
2 -- $Header: PAFCUAES.pls 120.1 2005/08/08 14:51:08 pbandla noship $
3
4 -- Function : GetBCBalStartDate
5 -- Purpose : Based on TPC, returns the start date
6 -- Changed 5/29
7 -- If TPC = GL then selects GL period start date where the given GL date falls.
8 -- If TPC = PA then selects PA period start date where the given PA date falls.
9 -- If TPC = 'N' then get the start_date from pa_bc_balances where EI date falls
10 -- for the given task, budget_version and RLMI.
11 FUNCTION GetBCBalStartDate(
12 p_time_phase_code in varchar2,
13 p_project_id in number,
14 p_ei_date in date,
15 p_bdgt_version in number,
16 p_sob_id in number,
17 p_org_id in number,
18 p_task_id in number,
19 p_top_task_id in number,
20 p_rlmi in number,
21 p_gl_date in date,
22 p_pa_date in date) return date ;
23 --pragma RESTRICT_REFERENCES(GetBCBalStartDate, WNDS, WNPS );
24
25 -- Function : GetBCBalEndDate
26 -- Purpose : Based on TPC, returns the end date
27 -- Changed 5/29
28 -- If TPC = GL then selects GL period end date where the given GL date falls.
29 -- If TPC = PA then selects PA period end date where the given PA date falls.
30 -- If TPC = 'N' then get the end_date from pa_bc_balances where EI date falls
31 -- for the given task, budget_version and RLMI.
32 FUNCTION GetBCBalEndDate(
33 p_time_phase_code in varchar2,
34 p_project_id in number,
35 p_ei_date in date,
36 p_bdgt_version in number,
37 p_sob_id in number,
38 p_org_id in number,
39 p_task_id in number,
40 p_top_task_id in number,
41 p_rlmi in number,
42 p_gl_date in date,
43 p_pa_date in date) return date ;
44 --pragma RESTRICT_REFERENCES(GetBCBalEndDate, WNDS, WNPS );
45
46 PROCEDURE update_act_enc_balance(
47 x_return_status OUT NOCOPY VARCHAR2
48 ,x_error_message_code OUT NOCOPY VARCHAR2
49 ,p_project_id IN NUMBER DEFAULT NULL);
50
51 END PA_SWEEPER;