[Home] [Help]
PACKAGE: APPS.PN_SCHEDULES_ITEMS
Source
1 PACKAGE pn_schedules_items AS
2 -- $Header: PNSCHITS.pls 120.4 2007/04/12 04:38:16 hrodda 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
14 PROCEDURE schedules_items (
15 errbuf OUT NOCOPY VARCHAR2,
16 retcode OUT NOCOPY VARCHAR2,
17 p_lease_id IN NUMBER,
18 p_lease_context IN VARCHAR2,
19 p_called_from IN VARCHAR2 DEFAULT 'MAIN',
20 p_term_id IN NUMBER DEFAULT NULL,
21 p_term_end_dt IN DATE DEFAULT NULL,
22 p_calc_batch IN VARCHAR2 DEFAULT 'N',
23 p_cutoff_date IN VARCHAR2 DEFAULT NULL,
24 p_extend_ri IN VARCHAR2 DEFAULT 'N',
25 p_ten_trm_context IN VARCHAR2 DEFAULT 'N');
26
27 PROCEDURE create_schedule(p_lease_id NUMBER,
28 p_lc_id NUMBER,
29 p_sch_dt DATE,
30 p_sch_id OUT NOCOPY NUMBER,
31 p_pymnt_st_lkp_cd OUT NOCOPY VARCHAR2,
32 p_payment_term_id NUMBER DEFAULT NULL);
33
34 PROCEDURE create_normalize_items( p_lease_context VARCHAR2,
35 p_lease_id NUMBER,
36 p_term_id NUMBER,
37 p_vendor_id NUMBER,
38 p_cust_id NUMBER,
39 p_vendor_site_id NUMBER,
40 p_cust_site_use_id NUMBER,
41 p_cust_ship_site_id NUMBER,
42 p_sob_id NUMBER,
43 p_curr_code VARCHAR2,
44 p_sch_day NUMBER DEFAULT NULL,
45 p_norm_str_dt DATE,
46 p_norm_end_dt DATE,
47 p_rate NUMBER,
48 p_lease_change_id NUMBER);
49
50 PROCEDURE create_cash_items(p_est_amt NUMBER,
51 p_act_amt NUMBER,
52 p_sch_dt DATE,
53 p_sch_id NUMBER,
54 p_term_id NUMBER,
55 p_vendor_id NUMBER,
56 p_cust_id NUMBER,
57 p_vendor_site_id NUMBER,
58 p_cust_site_use_id NUMBER,
59 p_cust_ship_site_id NUMBER,
60 p_sob_id NUMBER,
61 p_curr_code VARCHAR2,
62 p_rate NUMBER);
63
64 FUNCTION get_pro_amt(p_sch_str_dt DATE,
65 p_sch_end_dt DATE,
66 p_trm_str_dt DATE,
67 p_trm_end_dt DATE,
68 p_mth_amt NUMBER,
69 p_pr_rule VARCHAR2,
70 p_partial_start VARCHAR2,
71 p_partial_end VARCHAR2)
72 RETURN NUMBER;
73
74
75 PROCEDURE get_amount(p_sch_str_dt IN DATE,
76 p_sch_end_dt IN DATE,
77 p_trm_str_dt IN DATE,
78 p_trm_end_dt IN DATE,
79 p_act_amt IN NUMBER,
80 p_est_amt IN NUMBER,
81 p_freq IN NUMBER,
82 p_pro_rule IN VARCHAR2 DEFAULT NULL,
83 p_cash_act_amt OUT NOCOPY NUMBER,
84 p_cash_est_amt OUT NOCOPY NUMBER);
85
86 PROCEDURE recalculate_cash(p_new_lease_term_date DATE);
87
88 FUNCTION get_frequency(p_freq_code VARCHAR2)
89 RETURN NUMBER;
90
91 FUNCTION first_day (p_date DATE)
92 RETURN DATE;
93
94 FUNCTION Get_Lease_Change_Id (p_lease_id IN NUMBER)
95 RETURN NUMBER;
96
97
98 FUNCTION Get_Schedule_Date (p_lease_id IN NUMBER,
99 p_day IN NUMBER,
100 p_start_date IN DATE,
101 p_end_date IN DATE,
102 p_freq IN NUMBER DEFAULT 1)
103 RETURN DATE;
104
105 PROCEDURE Insert_Payment_Term (p_payment_term_rec IN OUT NOCOPY pn_payment_terms_all%ROWTYPE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_return_message OUT NOCOPY VARCHAR2);
108
109 PROCEDURE Create_Payment_Term (p_payment_term_rec IN pn_payment_terms_all%ROWTYPE,
110 p_lease_end_date IN DATE,
111 p_term_start_date IN DATE,
112 p_term_end_date IN DATE,
113 p_new_lea_term_dt IN DATE,
114 p_new_lea_comm_dt IN DATE,
115 p_mths IN NUMBER,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_return_message OUT NOCOPY VARCHAR2);
118
119
120 PROCEDURE Extend_Payment_Term (p_payment_term_rec IN pn_payment_terms_all%rowtype,
121 p_new_lea_comm_dt IN DATE,
122 p_new_lea_term_dt IN DATE,
123 p_mths IN NUMBER,
124 p_new_start_date IN DATE ,
125 p_new_end_date IN DATE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_return_message OUT NOCOPY VARCHAR2);
128
129 PROCEDURE Rollover_lease (p_lease_id IN NUMBER,
130 p_lease_end_date IN DATE,
131 p_new_lea_term_dt IN DATE,
132 p_new_lea_comm_dt IN DATE,
133 p_mths IN NUMBER,
134 p_extend_ri IN VARCHAR2 DEFAULT NULL,
135 p_ten_trm_context IN VARCHAR2 DEFAULT 'N',
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_return_message OUT NOCOPY VARCHAR2);
138
139 PROCEDURE norm_report(p_lease_context VARCHAR2);
140
141 PROCEDURE update_cash_item( p_item_id NUMBER
142 ,p_term_id NUMBER
143 ,p_sched_id NUMBER
144 ,p_act_amt NUMBER);
145
146
147
148 END pn_schedules_items;