[Home] [Help]
PACKAGE: APPS.IEX_REPOSSESS_PVT
Source
1 PACKAGE IEX_REPOSSESS_PVT AUTHID CURRENT_USER AS
2 /* $Header: iexrreps.pls 120.0 2004/01/24 03:20:38 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 -- Sub type records
8 subtype repv_rec_type is iex_rep_pvt.repv_rec_type;
9 subtype repv_tbl_type is iex_rep_pvt.repv_tbl_type;
10
11
12 ---------------------------------------------------------------------------
13 -- GLOBAL MESSAGE CONSTANTS
14 ---------------------------------------------------------------------------
15 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
16 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
17 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
18 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
19 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
20 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'IEX_UNEXPECTED_ERROR';
21 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'IEX_SQLERRM';
22 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'IEX_SQLCODE';
23 G_RET_REQ_ERROR CONSTANT VARCHAR2(200) := 'IEX_AM_RETURN_REQ_CREAT_ERROR';
24
25 ---------------------------------------------------------------------------
26 -- GLOBAL VARIABLES
27 ---------------------------------------------------------------------------
28 G_PKG_NAME CONSTANT VARCHAR2(200) := 'IEX_REPOSSESS_PVT';
29 G_APP_NAME CONSTANT VARCHAR2(3) := 'IEX';
30
31 ---------------------------------------------------------------------------
32 -- GLOBAL EXCEPTION
33 ---------------------------------------------------------------------------
34 G_INVALID_PARAMETERS EXCEPTION;
35
36 ---------------------------------------------------------------------------
37 -- CONSTANTS
38 ---------------------------------------------------------------------------
39 G_ART_CODE CONSTANT VARCHAR2(30) := 'REPOS_REQUEST';
40 G_ARS_CODE CONSTANT VARCHAR2(30) := 'SCHEDULED';
41
42 ---------------------------------------------------------------------------
43 -- Procedures and Functions
44 ---------------------------------------------------------------------------
45
46 PROCEDURE create_repossess_request(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
49 p_repv_rec IN repv_rec_type,
50 p_date_repossession_required IN DATE,
51 p_date_hold_until IN DATE,
52 p_relocate_asset_yn IN VARCHAR2,
53 x_repv_rec OUT NOCOPY repv_rec_type,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2);
57
58 PROCEDURE create_repossess_request(
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
61 p_repv_tbl IN repv_tbl_type,
62 p_date_repossession_required IN DATE,
63 p_date_hold_until IN DATE,
64 p_relocate_asset_yn IN VARCHAR2,
65 x_repv_tbl OUT NOCOPY repv_tbl_type,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2);
69
70 END IEX_REPOSSESS_PVT;