eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PN_INDEX_RENT_PVT

Source


1 PACKAGE PN_INDEX_RENT_PVT AUTHID CURRENT_USER AS
2 /* $Header: PNIRPVTS.pls 120.1 2010/12/15 10:39:54 seevivek noship $ */
3 
4   --  Record Type for PN_INDEX_LEASES_ALL record.
5 
6       TYPE rent_index_rec IS RECORD
7       (
8          index_lease_id                 NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
9         ,org_id                         NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
10         ,lease_id                       NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
11         ,lease_num                      VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
12         ,lease_name                     VARCHAR2(50)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
13         ,Index_type                     VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
14         ,index_id                       NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
15         ,commencement_date              DATE           := PN_INDEX_RENT_UTILS.G_PN_MISS_DATE
16         ,termination_date               DATE           := PN_INDEX_RENT_UTILS.G_PN_MISS_DATE
17         ,index_lease_number             VARCHAR2(100)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
18         ,last_update_date               DATE           := PN_INDEX_RENT_UTILS.G_PN_MISS_DATE
19         ,last_updated_by                NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
20         ,creation_date                  DATE           := PN_INDEX_RENT_UTILS.G_PN_MISS_DATE
21         ,created_by                     NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
22         ,location_id                    NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
23         ,location_code                  VARCHAR2(90)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
24         ,term_template_name             VARCHAR2(100)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
25         ,term_template_id               NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
26         ,abstracted_by                  NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
27         ,abstracted_by_username         VARCHAR2(100)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
28         ,assessment_date                DATE           := PN_INDEX_RENT_UTILS.G_PN_MISS_DATE
29         ,assessment_interval            NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
30         ,spread_frequency               VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
31         ,spread_frequency_meaning       VARCHAR2(80)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
32         ,relationship_default           VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
33         ,relationship_default_meaning   VARCHAR2(80)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
34         ,basis_percent_default          NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
35         ,initial_basis                  NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
36         ,base_index                     NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
37         ,base_index_line_id             NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
38         ,index_finder_method            VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
39         ,index_finder_method_meaning    VARCHAR2(80)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
40         ,index_finder_months            NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
41         ,negative_rent_type             VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
42         ,negative_rent_type_meaning     VARCHAR2(80)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
43         ,increase_on                    VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
44         ,increase_on_meaning            VARCHAR2(80)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
45         ,basis_type                     VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
46         ,basis_type_meaning             VARCHAR2(80)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
47         ,reference_period               VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
48         ,reference_period_meaning       VARCHAR2(80)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
49         ,base_year                      DATE           := PN_INDEX_RENT_UTILS.G_PN_MISS_DATE
50         ,leased_area                    NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
51         ,rounding_flag                  VARCHAR2(1)    := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
52         ,aggregation_flag               VARCHAR2(1)    := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
53         ,gross_flag                     VARCHAR2(1)    := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
54         ,last_update_login              NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
55         ,attribute_category             VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
56         ,attribute1                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
57         ,attribute2                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
58         ,attribute3                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
59         ,attribute4                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
60         ,attribute5                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
61         ,attribute6                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
62         ,attribute7                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
63         ,attribute8                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
64         ,attribute9                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
65         ,attribute10                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
66         ,attribute11                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
67         ,attribute12                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
68         ,attribute13                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
69         ,attribute14                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
70         ,attribute15                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
71         ,agreement_category             VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
72         ,agreement_attribute1           VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
73         ,agreement_attribute2           VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
74         ,agreement_attribute3           VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
75         ,agreement_attribute4           VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
76         ,agreement_attribute5           VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
77         ,agreement_attribute6           VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
78         ,agreement_attribute7           VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
79         ,agreement_attribute8           VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
80         ,agreement_attribute9           VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
81         ,agreement_attribute10          VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
82         ,agreement_attribute11          VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
83         ,agreement_attribute12          VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
84         ,agreement_attribute13          VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
85         ,agreement_attribute14          VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
86         ,agreement_attribute15          VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
87         ,currency_code                  VARCHAR2(15)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
88         ,carry_forward_flag             VARCHAR2(1)    := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
89         ,retain_initial_basis_flag      VARCHAR2(1)    := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
90         ,vr_nbp_flag                    VARCHAR2(1)    := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
91         ,index_multiplier               NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
92         ,proration_rule                 VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
93         ,proration_rule_meaning         VARCHAR2(80)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
94         ,proration_period_start_date    DATE           := PN_INDEX_RENT_UTILS.G_PN_MISS_DATE
95       );
96 
97     TYPE index_constraint_rec IS RECORD(
98     index_constraint_id            NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
99         ,index_lease_id                 NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
100         ,index_lease_number           VARCHAR2(100)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
101         ,scope                          VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
102         ,scope_meaning                  VARCHAR2(80)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
103         ,minimum_amount                 NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
104         ,maximum_amount                 NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
105         ,minimum_percent                NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
106         ,maximum_percent                NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
107         ,last_update_date               DATE           := PN_INDEX_RENT_UTILS.G_PN_MISS_DATE
108         ,last_updated_by                NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
109         ,creation_date                  DATE           := PN_INDEX_RENT_UTILS.G_PN_MISS_DATE
110         ,created_by                     NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
111         ,last_update_login              NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
112         ,attribute_category             VARCHAR2(30)   := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
113         ,attribute1                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
114         ,attribute2                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
115         ,attribute3                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
116         ,attribute4                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
117         ,attribute5                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
118         ,attribute6                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
119         ,attribute7                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
120         ,attribute8                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
121         ,attribute9                     VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
122         ,attribute10                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
123         ,attribute11                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
124         ,attribute12                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
125         ,attribute13                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
126         ,attribute14                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
127         ,attribute15                    VARCHAR2(150)  := PN_INDEX_RENT_UTILS.G_PN_MISS_CHAR
128         ,org_id                         NUMBER         := PN_INDEX_RENT_UTILS.G_PN_MISS_NUM
129    );
130    TYPE  index_constraint_tbl IS TABLE OF index_constraint_rec
131       INDEX BY BINARY_INTEGER;
132 
133    PROCEDURE debug (
134       p_log_message              IN       VARCHAR2
135     , p_log_level                IN       NUMBER
136    );
137        PROCEDURE CREATE_INDEX_RENT(
138           p_api_version              IN            NUMBER
139         , p_init_msg_list            IN            VARCHAR2
140         , p_commit                   IN            VARCHAR2
141         , p_validate                 IN            VARCHAR2
142         , p_rent_index_rec           IN OUT NOCOPY rent_index_rec
143         , p_index_constraint_tbl     IN OUT NOCOPY index_constraint_tbl
144         , x_return_status            OUT    NOCOPY VARCHAR2
145         , x_msg_count                OUT    NOCOPY NUMBER
146         , x_msg_data                 OUT    NOCOPY VARCHAR2
147        );
148 
149        PROCEDURE UPDATE_INDEX_RENT(
150           p_api_version              IN            NUMBER
151         , p_init_msg_list            IN            VARCHAR2
152         , p_commit                   IN            VARCHAR2
153         , p_validate                 IN            VARCHAR2
154         , p_rent_index_rec           IN OUT NOCOPY rent_index_rec
155         , p_index_constraint_tbl     IN OUT NOCOPY index_constraint_tbl
156         , x_return_status            OUT NOCOPY    VARCHAR2
157         , x_msg_count                OUT NOCOPY    NUMBER
158         , x_msg_data                 OUT NOCOPY   VARCHAR2
159        );
160 END PN_INDEX_RENT_PVT;