[Home] [Help]
PACKAGE: APPS.PN_SCHEDULES_ITEMS
Source
1 PACKAGE pn_schedules_items AUTHID CURRENT_USER AS
2 -- $Header: PNSCHITS.pls 120.4.12010000.4 2010/01/19 07:23:07 jsundara ship $
3
4 g_lease_id PN_LEASES.lease_id%TYPE;
5 g_lease_num PN_LEASES.lease_num%TYPE;
6 g_lease_name PN_LEASES.name%TYPE;
7 g_pr_rule PN_LEASES.payment_term_proration_rule%TYPE;
8 g_lease_class_code PN_LEASES.lease_class_code%TYPE;
9 g_lease_status PN_LEASES.lease_status%TYPE;
10 g_new_lea_comm_dt PN_LEASE_DETAILS_ALL.lease_commencement_date%TYPE;
11 g_new_lea_term_dt PN_LEASE_DETAILS_ALL.lease_termination_date%TYPE;
12 g_new_ext_end_date PN_LEASE_DETAILS_ALL.lease_extension_end_date%TYPE;
13 g_norm_dt_avl varchar2(1) := NULL; /* 9231686 */
14
15 PROCEDURE schedules_items (
16 errbuf OUT NOCOPY VARCHAR2,
17 retcode OUT NOCOPY VARCHAR2,
18 p_lease_id IN NUMBER,
19 p_lease_context IN VARCHAR2,
20 p_called_from IN VARCHAR2 DEFAULT 'MAIN',
21 p_term_id IN NUMBER DEFAULT NULL,
22 p_term_end_dt IN DATE DEFAULT NULL,
23 p_calc_batch IN VARCHAR2 DEFAULT 'N',
24 p_cutoff_date IN VARCHAR2 DEFAULT NULL,
25 p_extend_ri IN VARCHAR2 DEFAULT 'N',
26 p_ten_trm_context IN VARCHAR2 DEFAULT 'N');
27
28 PROCEDURE create_schedule(p_lease_id NUMBER,
29 p_lc_id NUMBER,
30 p_sch_dt DATE,
31 p_sch_id OUT NOCOPY NUMBER,
32 p_pymnt_st_lkp_cd OUT NOCOPY VARCHAR2,
33 p_payment_term_id NUMBER DEFAULT NULL);
34
35 PROCEDURE create_normalize_items( p_lease_context VARCHAR2,
36 p_lease_id NUMBER,
37 p_term_id NUMBER,
38 p_vendor_id NUMBER,
39 p_cust_id NUMBER,
40 p_vendor_site_id NUMBER,
41 p_cust_site_use_id NUMBER,
42 p_cust_ship_site_id NUMBER,
43 p_sob_id NUMBER,
44 p_curr_code VARCHAR2,
45 p_sch_day NUMBER DEFAULT NULL,
46 p_norm_str_dt DATE,
47 p_norm_end_dt DATE,
48 p_rate NUMBER,
49 p_lease_change_id NUMBER);
50
51 PROCEDURE create_cash_items(p_est_amt NUMBER,
52 p_act_amt NUMBER,
53 p_sch_dt DATE,
54 p_sch_id NUMBER,
55 p_term_id NUMBER,
56 p_vendor_id NUMBER,
57 p_cust_id NUMBER,
58 p_vendor_site_id NUMBER,
59 p_cust_site_use_id NUMBER,
60 p_cust_ship_site_id NUMBER,
61 p_sob_id NUMBER,
62 p_curr_code VARCHAR2,
63 p_rate NUMBER);
64
65 FUNCTION get_pro_amt(p_sch_str_dt DATE,
66 p_sch_end_dt DATE,
67 p_trm_str_dt DATE,
68 p_trm_end_dt DATE,
69 p_mth_amt NUMBER,
70 p_pr_rule VARCHAR2,
71 p_partial_start VARCHAR2,
72 p_partial_end VARCHAR2)
73 RETURN NUMBER;
74
75
76 PROCEDURE get_amount(p_sch_str_dt IN DATE,
77 p_sch_end_dt IN DATE,
78 p_trm_str_dt IN DATE,
79 p_trm_end_dt IN DATE,
80 p_act_amt IN NUMBER,
81 p_est_amt IN NUMBER,
82 p_freq IN NUMBER,
83 p_pro_rule IN VARCHAR2 DEFAULT NULL,
84 p_cash_act_amt OUT NOCOPY NUMBER,
85 p_cash_est_amt OUT NOCOPY NUMBER);
86
87 PROCEDURE recalculate_cash(p_new_lease_term_date DATE);
88
89 FUNCTION get_frequency(p_freq_code VARCHAR2)
90 RETURN NUMBER;
91
92 FUNCTION first_day (p_date DATE)
93 RETURN DATE;
94
95 FUNCTION Get_Lease_Change_Id (p_lease_id IN NUMBER)
96 RETURN NUMBER;
97
98
99 FUNCTION Get_Schedule_Date (p_lease_id IN NUMBER,
100 p_day IN NUMBER,
101 p_start_date IN DATE,
102 p_end_date IN DATE,
103 p_freq IN NUMBER DEFAULT 1)
104 RETURN DATE;
105
106 PROCEDURE Insert_Payment_Term (p_payment_term_rec IN OUT NOCOPY pn_payment_terms_all%ROWTYPE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_return_message OUT NOCOPY VARCHAR2);
109
110 PROCEDURE Create_Payment_Term (p_payment_term_rec IN pn_payment_terms_all%ROWTYPE,
111 p_lease_end_date IN DATE,
112 p_term_start_date IN DATE,
113 p_term_end_date IN DATE,
114 p_new_lea_term_dt IN DATE,
115 p_new_lea_comm_dt IN DATE,
116 p_mths IN NUMBER,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_return_message OUT NOCOPY VARCHAR2);
119
120
121 PROCEDURE Extend_Payment_Term (p_payment_term_rec IN pn_payment_terms_all%rowtype,
122 p_new_lea_comm_dt IN DATE,
123 p_new_lea_term_dt IN DATE,
124 p_mths IN NUMBER,
125 p_new_start_date IN DATE ,
126 p_new_end_date IN DATE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_return_message OUT NOCOPY VARCHAR2);
129
130 PROCEDURE Rollover_lease (p_lease_id IN NUMBER,
131 p_lease_end_date IN DATE,
132 p_new_lea_term_dt IN DATE,
133 p_new_lea_comm_dt IN DATE,
134 p_mths IN NUMBER,
135 p_extend_ri IN VARCHAR2 DEFAULT NULL,
136 p_ten_trm_context IN VARCHAR2 DEFAULT 'N',
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_return_message OUT NOCOPY VARCHAR2);
139
140 PROCEDURE norm_report(p_lease_context VARCHAR2);
141
142 PROCEDURE update_cash_item( p_item_id NUMBER
143 ,p_term_id NUMBER
144 ,p_sched_id NUMBER
145 ,p_act_amt NUMBER);
146
147
148 procedure get_sch_start(p_yr_start_dt IN DATE,
149 p_freq_code IN VARCHAR2,
150 p_term_start_dt IN VARCHAR2,
151 p_sch_str_dt OUT NOCOPY DATE);
152
153 TYPE norm_st_dt_rec_tbl_type IS TABLE OF DATE
154 INDEX BY BINARY_INTEGER;
155
156 norm_st_dt_rec_tbl norm_st_dt_rec_tbl_type ; /* 9231686 */
157
158 END pn_schedules_items;