[Home] [Help]
PACKAGE: APPS.PN_OPEX_TERMS_PKG
Source
1 PACKAGE PN_OPEX_TERMS_PKG AUTHID CURRENT_USER AS
2 -- $Header: PNOTERMS.pls 120.1 2007/10/11 06:27:10 rthumma noship $
3
4
5 -------------------------------------------------------------------
6 -- PROCEDURE CREATE_OPEX_PAYMENT_TERMS
7 -------------------------------------------------------------------
8 PROCEDURE create_opex_payment_terms(
9 p_est_payment_id IN NUMBER,
10 p_term_template_id IN NUMBER DEFAULT NULL,
11 p_lease_id IN NUMBER,
12 x_payment_term_id OUT NOCOPY NUMBER,
13 x_catch_up_term_id OUT NOCOPY NUMBER,
14 x_return_status IN OUT NOCOPY VARCHAR2
15
16 );
17
18 -------------------------------------------------------------------
19 -- PROCEDURE CREATE_RECON_OPEX_PAYMENT_TERMS
20 -------------------------------------------------------------------
21
22 PROCEDURE create_recon_pay_term(
23 p_recon_id IN NUMBER DEFAULT NULL,
24 p_agreement_id IN NUMBER,
25 p_st_end_date IN DATE DEFAULT SYSDATE,
26 p_amount IN NUMBER,
27 x_payment_term_id OUT NOCOPY NUMBER,
28 x_return_status IN OUT NOCOPY VARCHAR2
29 );
30
31
32
33 -------------------------------------------------------------------
34 -- PROCEDURE LAST_SCHEDULE_DAY
35 -------------------------------------------------------------------
36 PROCEDURE last_schedule_day(
37 p_lease_id IN NUMBER,
38 p_payment_term_id IN NUMBER,
39 x_end_date OUT NOCOPY VARCHAR2
40 );
41
42
43 FUNCTION get_curr_est_pay_term(agr_id IN NUMBER)
44 RETURN NUMBER;
45
46 FUNCTION get_latest_recon(agr_id IN NUMBER)
47 RETURN NUMBER;
48
49 FUNCTION get_stmt_due_date(agr_id IN NUMBER)
50 RETURN DATE;
51
52 FUNCTION get_prop_id(p_location_id IN NUMBER)
53 RETURN NUMBER;
54
55
56 -------------------------------------------------------------------
57 -- PROCEDURE CONTRACT_PREV_EST_TERM
58 -------------------------------------------------------------------
59
60 PROCEDURE contract_prev_est_term(
61 p_lease_id IN NUMBER,
62 p_est_payment_id IN NUMBER,
63 x_return_status IN OUT NOCOPY VARCHAR2);
64
65
66
67 FUNCTION recon_pct_change(p_agr_id IN NUMBER ,
68 p_recon_id IN NUMBER ,
69 p_period_start_dt DATE ,
70 p_ten_tot_charge NUMBER)
71 RETURN NUMBER;
72
73 PROCEDURE delete_agreement (p_agreement_id IN NUMBER
74 ,x_return_status IN OUT NOCOPY VARCHAR2);
75
76
77 -------------------------------------------------------------------
78 -- PROCEDURE APPROVE_OPEX_PAY_TERM
79 -------------------------------------------------------------------
80 PROCEDURE approve_opex_pay_term (ip_lease_id IN NUMBER
81 ,ip_opex_pay_term_id IN NUMBER
82 ,op_msg OUT NOCOPY VARCHAR2
83 );
84
85
86 -------------------------------------------------------------------
87 -- PROCEDURE APPROVE_OPEX_PAY_TERM_BATCH
88 -- 15-MAY-2007 sdmahesh o Bug # 6039220
89 -- Changed the order of concurrent program
90 -- parameters
91 -------------------------------------------------------------------
92 PROCEDURE approve_opex_pay_term_batch (
93 errbuf OUT NOCOPY VARCHAR2
94 ,retcode OUT NOCOPY VARCHAR2
95 ,ip_agreement_number_lower IN VARCHAR2
96 ,ip_agreement_number_upper IN VARCHAR2
97 ,ip_main_lease_number_lower IN VARCHAR2
98 ,ip_main_lease_number_upper IN VARCHAR2
99 ,ip_location_code_lower IN VARCHAR2
100 ,ip_location_code_upper IN VARCHAR2
101 ,ip_user_responsible IN VARCHAR2
102 ,ip_payment_start_date_lower IN VARCHAR2
103 ,ip_payment_start_date_upper IN VARCHAR2
104 ,ip_payment_function IN VARCHAR2
105 ,ip_property_code_ret_by_id IN VARCHAR2
106 ,ip_payment_status IN VARCHAR2
107 );
108
109
110 FUNCTION get_unpaid_amt(p_recon_id IN NUMBER)
111 RETURN NUMBER;
112
113
114 END pn_opex_terms_pkg;