1 PACKAGE PN_INDEX_RENT_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PNIRUTLS.pls 120.1 2010/12/15 10:41:10 seevivek noship $ */
3
4 G_PN_MISS_NUM CONSTANT NUMBER := 1.7E20;
5 G_PN_MISS_DATE CONSTANT DATE := TO_DATE('01/01/4712','DD/MM/YYYY');
6 G_PN_MISS_CHAR CONSTANT VARCHAR2(3) := '^';
7 PROCEDURE get_index_lease_id (
8 p_parameter_name IN VARCHAR2
9 , p_operation IN VARCHAR2 DEFAULT 'UPDATE_INDEX_RENT'
10 , p_index_lease_number IN OUT NOCOPY VARCHAR2
11 , x_index_lease_id IN OUT NOCOPY NUMBER
12 , x_lease_id OUT NOCOPY NUMBER
13 , x_org_id IN OUT NOCOPY NUMBER
14 , x_index_id OUT NOCOPY NUMBER
15 , x_return_status OUT NOCOPY VARCHAR2
16 );
17 PROCEDURE get_lookup_code (
18 p_parameter_name IN VARCHAR2
19 , p_operation IN VARCHAR2 DEFAULT 'CREATE_RENT_INDEX'
20 , p_lookup_meaning IN VARCHAR2
21 , p_lookup_type IN VARCHAR2
22 , x_lookup_type_code IN OUT NOCOPY VARCHAR2
23 , x_return_status OUT NOCOPY VARCHAR2
24 );
25
26 PROCEDURE get_lease_id
27 ( p_parameter_name IN VARCHAR2
28 , p_operation IN VARCHAR2 DEFAULT 'CREATE_INDEX_RENT'
29 , p_lease_name IN VARCHAR2
30 , p_lease_number IN VARCHAR2
31 , p_org_id IN NUMBER
32 , x_lease_id IN OUT NOCOPY NUMBER
33 , x_lease_class_code OUT NOCOPY VARCHAR2
34 , x_lease_commencement_date OUT NOCOPY DATE
35 , x_lease_termination_date OUT NOCOPY DATE
36 , x_lease_execution_date OUT NOCOPY DATE
37 , x_lease_extension_end_date OUT NOCOPY DATE
38 , x_return_status OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE get_location_id (
42 p_parameter_name IN VARCHAR2
43 , p_operation IN VARCHAR2 DEFAULT 'CREATE_INDEX_RENT'
44 , p_lease_id IN NUMBER
45 , p_location_code IN VARCHAR2
46 , p_org_id IN NUMBER
47 , x_location_id IN OUT NOCOPY NUMBER
48 , x_return_status OUT NOCOPY VARCHAR2
49 );
50
51
52 PROCEDURE get_index_id (
53 p_parameter_name IN VARCHAR2
54 , p_operation IN VARCHAR2 DEFAULT 'CREATE_INDEX_RENT'
55 , p_index_name IN VARCHAR2
56 , x_index_id IN OUT NOCOPY NUMBER
57 , x_return_status OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE get_user_id (
61 p_parameter_name IN VARCHAR2
62 , p_operation IN VARCHAR2 DEFAULT 'CREATE_INDEX_RENT'
63 , p_user_name IN VARCHAR2
64 , x_user_id IN OUT NOCOPY NUMBER
65 , x_return_status OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE get_currency_code(
69 p_parameter_name IN VARCHAR2
70 , p_operation IN VARCHAR2 DEFAULT 'CREATE_RENT_INDEX'
71 , p_functional_currency_code IN VARCHAR2
72 , x_currency_code IN OUT NOCOPY VARCHAR2
73 , x_user_conversion_type OUT NOCOPY VARCHAR2
74 , x_conversion_type OUT NOCOPY VARCHAR2
75 , x_return_status OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE get_increase_on(
79 p_parameter_name IN VARCHAR2
80 , p_operation IN VARCHAR2 DEFAULT 'CREATE_RENT_INDEX'
81 , p_lookup_meaning IN VARCHAR2
82 , p_lease_id IN VARCHAR2
83 , p_currency_code IN VARCHAR2
84 , x_lookup_code IN OUT NOCOPY VARCHAR2
85 , x_return_status OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE GET_TERM_TEMPLATE_ID(
89 p_parameter_name IN VARCHAR2
90 , p_termtemp_name IN VARCHAR2
91 , p_operation IN VARCHAR2 DEFAULT 'CREATE_RENT_INDEX'
92 , p_termtemp_type IN VARCHAR2
93 , p_org_id IN NUMBER
94 , x_return_status OUT NOCOPY VARCHAR2
95 , x_termtemp_id IN OUT NOCOPY NUMBER
96 );
97
98 END PN_INDEX_RENT_UTILS;