1 PACKAGE PN_INDEX_RENT_PUB AUTHID CURRENT_USER AS
2 /* $Header: PNIRPUBS.pls 120.2.12020000.2 2012/07/18 09:59:05 admarath ship $ */
3 /*#
4 * This package contains the public APIs for index rent information.
5 * @rep:scope public
6 * @rep:product PN
7 * @rep:lifecycle active
8 * @rep:displayname Index Rent Definition
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PN_INDEX_LEASES
11 */
12 /*
13 -- Package constant g_pkg_name used for package name validation.
14 -- Package constant g_table_name used for table name validation.
15 -- Package constant g_tl_table_name used for table name validation.
16 -- Package constant g_resp_appl_id used for respective application id validation.
17 -- Package constant g_resp_id used for responsibility id validation.
18 -- Package constant g_user_id used for user id validation.
19 -- Package constant g_login_id used for login id validation.
20 */
21
22 g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_INDEX_RENT_PUB';
23 g_table_name CONSTANT VARCHAR2 (40) := 'PN_INDEX_LEASES_ALL';
24 g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
25 g_resp_appl_id CONSTANT NUMBER := fnd_global.resp_appl_id;
26 g_resp_id CONSTANT NUMBER := fnd_global.resp_appl_id;
27 g_user_id CONSTANT NUMBER := fnd_global.user_id;
28 g_login_id CONSTANT NUMBER := fnd_global.login_id;
29
30 l_null_param VARCHAR2(500);
31 l_func_exists VARCHAR2(1);
32
33 /*********************************************/
34 -- Procedure to create index rent
35 /*********************************************/
36 /*#
37 * This API creates a new index rent in the Oracle Projects.
38 * @param p_api_version API standard version number
39 * @rep:paraminfo {@rep:required}
40 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
41 * @rep:paraminfo {@rep:required}
42 * @param p_commit API standard (default = F): indicates if transaction will be commited
43 * @rep:paraminfo {@rep:required}
44 * @param p_validate Indicates whether the system performs scheduling validations. Default is Y
45 * @rep:paraminfo {@rep:precision 1}
46 * @param p_rent_index_rec Input Output index rent details
47 * @rep:paraminfo {@rep:required}
48 * @param p_index_constraint_tbl Input Output index rent constraints details
49 * @param x_return_status API standard: return of the API (success/failure/unexpected error)
50 * @rep:paraminfo {@rep:precision 1}
51 * @param x_msg_count API standard: number of error messages
52 * @rep:paraminfo {@rep:required}
53 * @param x_msg_data API standard: error message
54 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
55 * @rep:scope public
56 * @rep:lifecycle active
57 * @rep:displayname Create Index Rent
58 * @rep:category BUSINESS_ENTITY PN_INDEX_LEASES
59 * @rep:compatibility S
60 */
61 -- Procedure to create a new index rent
62 PROCEDURE CREATE_INDEX_RENT
63 (
64 p_api_version IN NUMBER
65 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
66 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
67 , p_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE
68 , p_rent_index_rec IN OUT NOCOPY PN_INDEX_RENT_PVT.rent_index_rec
69 , p_index_constraint_tbl IN OUT NOCOPY PN_INDEX_RENT_PVT.index_constraint_tbl
70 , x_return_status OUT NOCOPY VARCHAR2
71 , x_msg_count OUT NOCOPY NUMBER
72 , x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 /*********************************************/
76 -- Procedure to update index rent
77 /*********************************************/
78 /*#
79 * This API updates a index rent in the Oracle Projects.
80 * @param p_api_version API standard version number
81 * @rep:paraminfo {@rep:required}
82 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
83 * @param p_commit API standard (default = F): indicates if transaction will be committed
84 * @param p_validate Indicates whether the system performs scheduling validations. Default is Y
85 * @rep:paraminfo {@rep:precision 1}
86 * @param p_rent_index_rec Input Output index rent details
87 * @rep:paraminfo {@rep:required}
88 * @param p_index_constraint_tbl Input Output index rent constraints details
89 * @param x_return_status API standard: return of the API (success/failure/unexpected error)
90 * @param x_msg_count API standard: number of error messages
91 * @rep:paraminfo {@rep:required}
92 * @param x_msg_data API standard: error message
93 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
94 * @rep:scope public
95 * @rep:lifecycle active
96 * @rep:displayname Update Index Rent
97 * @rep:category BUSINESS_ENTITY PN_INDEX_LEASES
98 * @rep:compatibility S
99 */
100 -- Procedure to update index rent
101 PROCEDURE UPDATE_INDEX_RENT(
102 p_api_version IN NUMBER
103 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
104 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
105 , p_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE
106 , p_rent_index_rec IN OUT NOCOPY PN_INDEX_RENT_PVT.rent_index_rec
107 , p_index_constraint_tbl IN OUT NOCOPY PN_INDEX_RENT_PVT.index_constraint_tbl
108 , x_return_status OUT NOCOPY VARCHAR2
109 , x_msg_count OUT NOCOPY NUMBER
110 , x_msg_data OUT NOCOPY VARCHAR2
111 );
112
113
114
115 END PN_INDEX_RENT_PUB;