1 PACKAGE pn_lease_details_pkg AUTHID CURRENT_USER AS
2 -- $Header: PNTLSDTS.pls 115.26 2003/12/19 17:40:47 atuppad ship $
3
4 PROCEDURE Insert_Row
5 (
6 x_rowid IN OUT NOCOPY VARCHAR2
7 ,x_lease_detail_id IN OUT NOCOPY NUMBER
8 ,x_lease_change_id IN NUMBER
9 ,x_lease_id IN NUMBER
10 ,x_responsible_user IN NUMBER
11 ,x_expense_account_id IN NUMBER
12 ,x_lease_commencement_date IN DATE
13 ,x_lease_termination_date IN DATE
14 ,x_lease_execution_date IN DATE
15 ,x_creation_date IN DATE
16 ,x_created_by IN NUMBER
17 ,x_last_update_date IN DATE
18 ,x_last_updated_by IN NUMBER
19 ,x_last_update_login IN NUMBER
20 ,x_accrual_account_id IN NUMBER
21 ,x_receivable_account_id IN NUMBER
22 ,x_term_template_id IN NUMBER DEFAULT NULL
23 ,x_grouping_rule_id IN NUMBER DEFAULT NULL
24 ,x_attribute_category IN VARCHAR2
25 ,x_attribute1 IN VARCHAR2
26 ,x_attribute2 IN VARCHAR2
27 ,x_attribute3 IN VARCHAR2
28 ,x_attribute4 IN VARCHAR2
29 ,x_attribute5 IN VARCHAR2
30 ,x_attribute6 IN VARCHAR2
31 ,x_attribute7 IN VARCHAR2
32 ,x_attribute8 IN VARCHAR2
33 ,x_attribute9 IN VARCHAR2
34 ,x_attribute10 IN VARCHAR2
35 ,x_attribute11 IN VARCHAR2
36 ,x_attribute12 IN VARCHAR2
37 ,x_attribute13 IN VARCHAR2
38 ,x_attribute14 IN VARCHAR2
39 ,x_attribute15 IN VARCHAR2
40 ,x_org_id IN NUMBER
41 );
42
43 PROCEDURE Lock_Row
44 (
45 x_lease_detail_id IN NUMBER
46 ,x_lease_change_id IN NUMBER
47 ,x_lease_id IN NUMBER
48 ,x_responsible_user IN NUMBER
49 ,x_expense_account_id IN NUMBER
50 ,x_lease_commencement_date IN DATE
51 ,x_lease_termination_date IN DATE
52 ,x_lease_execution_date IN DATE
53 ,x_accrual_account_id IN NUMBER
54 ,x_receivable_account_id IN NUMBER
55 ,x_term_template_id IN NUMBER
56 ,x_grouping_rule_id IN NUMBER DEFAULT NULL
57 ,x_attribute_category IN VARCHAR2
58 ,x_attribute1 IN VARCHAR2
59 ,x_attribute2 IN VARCHAR2
60 ,x_attribute3 IN VARCHAR2
61 ,x_attribute4 IN VARCHAR2
62 ,x_attribute5 IN VARCHAR2
63 ,x_attribute6 IN VARCHAR2
64 ,x_attribute7 IN VARCHAR2
65 ,x_attribute8 IN VARCHAR2
66 ,x_attribute9 IN VARCHAR2
67 ,x_attribute10 IN VARCHAR2
68 ,x_attribute11 IN VARCHAR2
69 ,x_attribute12 IN VARCHAR2
70 ,x_attribute13 IN VARCHAR2
71 ,x_attribute14 IN VARCHAR2
72 ,x_attribute15 IN VARCHAR2
73 ,x_name IN VARCHAR2 DEFAULT NULL
74 ,x_lease_num IN VARCHAR2 DEFAULT NULL
75 ,x_lease_status IN VARCHAR2 DEFAULT NULL
76 ,x_lease_extension_end_date IN DATE DEFAULT NULL
77 );
78
79 PROCEDURE Update_Row
80 (
81 x_lease_detail_id IN NUMBER
82 ,x_lease_change_id IN NUMBER
83 ,x_lease_id IN NUMBER
84 ,x_responsible_user IN NUMBER
85 ,x_expense_account_id IN NUMBER
86 ,x_lease_commencement_date IN DATE
87 ,x_lease_termination_date IN DATE
88 ,x_lease_execution_date IN DATE
89 ,x_last_update_date IN DATE
90 ,x_last_updated_by IN NUMBER
91 ,x_last_update_login IN NUMBER
92 ,x_accrual_account_id IN NUMBER
93 ,x_receivable_account_id IN NUMBER
94 ,x_term_template_id IN NUMBER
95 ,x_grouping_rule_id IN NUMBER DEFAULT NULL
96 ,x_attribute_category IN VARCHAR2
97 ,x_attribute1 IN VARCHAR2
98 ,x_attribute2 IN VARCHAR2
99 ,x_attribute3 IN VARCHAR2
100 ,x_attribute4 IN VARCHAR2
101 ,x_attribute5 IN VARCHAR2
102 ,x_attribute6 IN VARCHAR2
103 ,x_attribute7 IN VARCHAR2
104 ,x_attribute8 IN VARCHAR2
105 ,x_attribute9 IN VARCHAR2
106 ,x_attribute10 IN VARCHAR2
107 ,x_attribute11 IN VARCHAR2
108 ,x_attribute12 IN VARCHAR2
109 ,x_attribute13 IN VARCHAR2
110 ,x_attribute14 IN VARCHAR2
111 ,x_attribute15 IN VARCHAR2
112 ,x_lease_extension_end_date IN DATE DEFAULT NULL
113 );
114
115 PROCEDURE Delete_Row
116 (
117 x_lease_detail_id IN NUMBER
118 );
119
120 END pn_lease_details_pkg;
[Home] [Help]