1 package PA_IND_RATE_SCH_REVISIONS_PKG as
2 -- $Header: PAXCIRRS.pls 120.1.12000000.3 2007/04/18 05:46:19 svivaram ship $
3 procedure check_dates(x_return_status IN OUT NOCOPY number,
4 x_stage IN OUT NOCOPY number,
5 x_ind_rate_sch_id IN number,
6 x_start_date_active IN date,
7 x_end_date_active IN date,
8 x_max_revision_id IN OUT NOCOPY number,
9 x_max_end_date_active IN OUT NOCOPY date);
10
11 procedure start_to_gl(x_return_status IN OUT NOCOPY number,
12 x_stage IN OUT NOCOPY number,
13 x_start_date_active IN date);
14
15 procedure end_to_gl(x_return_status IN OUT NOCOPY number,
16 x_stage IN OUT NOCOPY number,
17 x_end_date_active IN date);
18
19 procedure check_references(x_return_status IN OUT NOCOPY number,
20 x_stage IN OUT NOCOPY number,
21 x_ind_rate_sch_revision_id IN number);
22
23 procedure check_end_date_limit(x_return_status IN OUT NOCOPY number,
24 x_end_date_active IN date,
25 x_ind_rate_sch_revision_id IN number);
26
27 procedure check_start_date(x_return_status IN OUT NOCOPY number,
28 x_stage IN OUT NOCOPY number,
29 x_prev_end_date_active IN OUT NOCOPY date,
30 x_prev_revision_id IN OUT NOCOPY number,
31 x_ind_rate_sch_revision_id IN number,
32 x_ind_rate_sch_id IN number,
33 x_start_date_active IN date);
34
35 procedure check_end_date(x_return_status IN OUT NOCOPY number,
36 x_stage IN OUT NOCOPY number,
37 x_next_start_date_active IN OUT NOCOPY date,
38 x_next_revision_id IN OUT NOCOPY number,
39 x_ind_rate_sch_revision_id IN number,
40 x_ind_rate_sch_id IN number,
41 x_end_date_active IN date);
42
43 procedure check_multipliers(x_ind_rate_sch_revision_id IN number,
44 x_return_status IN OUT NOCOPY number,
45 x_stage IN OUT NOCOPY number);
46
47 procedure check_ready_compile(x_ind_rate_sch_revision_id IN number,
48 x_ready_compile_flag IN OUT NOCOPY varchar2,
49 x_ready_for_compile IN OUT NOCOPY varchar2, /*2933915*/
50 x_compiled_flag IN OUT NOCOPY varchar2,
51 x_return_status IN OUT NOCOPY number,
52 x_stage IN OUT NOCOPY number);
53
54
55 end PA_IND_RATE_SCH_REVISIONS_PKG;