1 package PN_VAR_CHG_CAL_PKG AUTHID CURRENT_USER as
2 -- $Header: PNCHCALS.pls 120.0 2007/10/03 14:24:48 rthumma noship $
3
4 procedure copy_var_rent_agreement (
5 p_old_var_rent_id IN NUMBER,
6 p_start_date IN DATE DEFAULT NULL,
7 p_end_date IN DATE DEFAULT NULL,
8 p_proration_rule IN VARCHAR2 DEFAULT 'STD',
9 p_create_periods IN VARCHAR2 DEFAULT 'N',
10 x_var_rent_id OUT NOCOPY NUMBER,
11 x_var_rent_num OUT NOCOPY VARCHAR2) ;
12
13 procedure copy_parent_constraints (
14 X_VAR_RENT_ID in NUMBER,
15 X_CHG_VAR_RENT_ID in NUMBER
16 );
17 procedure copy_parent_lines (
18 X_VAR_RENT_ID in NUMBER,
19 X_CHG_VAR_RENT_ID in NUMBER
20 );
21
22 procedure copy_parent_volhist (
23 X_VAR_RENT_ID in NUMBER,
24 X_CHG_VAR_RENT_ID in NUMBER
25 ) ;
26
27 PROCEDURE populate_transactions (p_var_rent_id IN NUMBER,
28 p_period_id IN NUMBER DEFAULT NULL,
29 p_line_item_id IN NUMBER DEFAULT NULL);
30
31 PROCEDURE update_ytd_bkpts(p_var_Rent_id IN NUMBER,
32 p_period_id IN NUMBER DEFAULT NULL,
33 p_start_date IN DATE DEFAULT NULL,
34 p_end_date IN DATE DEFAULT NULL);
35
36 PROCEDURE determine_reset_flag ( p_var_rent_id IN NUMBER,
37 p_period_id IN NUMBER,
38 p_item_category_code IN VARCHAR2 DEFAULT NULL,
39 p_sales_type_code IN VARCHAR2 DEFAULT NULL,
40 p_start_date IN DATE ,
41 x_reset_flag OUT NOCOPY VARCHAR2);
42
43 PROCEDURE update_blended_period ( p_var_rent_id IN NUMBER);
44
45 PROCEDURE update_blended_period ( p_var_rent_id IN NUMBER,
46 p_start_date IN DATE,
47 p_proration_rule IN VARCHAR2);
48
49 Function get_last_complete_period_id ( p_var_rent_id IN NUMBER)
50 RETURN NUMBER ;
51
52 Function get_ly_365_start_date ( p_var_rent_id IN NUMBER)
53 RETURN DATE ;
54
55 Function get_fy_365_end_date ( p_var_rent_id IN NUMBER)
56 RETURN DATE ;
57
58 Procedure process_calendar_change (
59 p_var_rent_id IN NUMBER ,
60 p_old_var_rent_id IN NUMBER ,
61 p_effective_date IN DATE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_return_message OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE copy_line_defaults(p_old_var_rent_id NUMBER
67 ,p_new_var_rent_id NUMBER
68 ,p_effective_date DATE );
69
70 procedure copy_constr_defaults (
71 p_old_var_rent_id in NUMBER,
72 p_new_var_rent_id in NUMBER,
73 p_effective_date in DATE
74 ) ;
75
76 PROCEDURE create_credit_invoice ( p_var_rent_id NUMBER,
77 p_effective_date DATE);
78
79 end PN_VAR_CHG_CAL_PKG;