[Home] [Help]
PACKAGE: APPS.OKL_AM_TERMNT_INTERFACE_PVT
Source
1 PACKAGE OKL_AM_TERMNT_INTERFACE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRTIFS.pls 115.6 2003/10/21 14:18:59 rabhupat noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13
14 ---------------------------------------------------------------------------
15 -- GLOBAL VARIABLES
16 ---------------------------------------------------------------------------
17 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_TERMNT_INTERFACE_PVT';
18 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19
20 ---------------------------------------------------------------------------
21 -- GLOBAL EXCEPTIONS
22 ---------------------------------------------------------------------------
23 G_EXCEPTION_INSURANCE_ERROR EXCEPTION;
24
25 ---------------------------------------------------------------------------
26 -- GLOBAL DATASTRUCTURES
27 ---------------------------------------------------------------------------
28 -- OKL_TERMNT_INTERFACE Record Spec
29
30 TYPE tif_rec_type IS RECORD (
31 row_id ROWID
32 ,transaction_number OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER%TYPE
33 ,batch_number OKL_TERMNT_INTERFACE.BATCH_NUMBER%TYPE
34 ,contract_id OKL_TERMNT_INTERFACE.CONTRACT_ID%TYPE
35 ,contract_number OKL_TERMNT_INTERFACE.CONTRACT_NUMBER%TYPE
36 ,asset_id OKL_TERMNT_INTERFACE.ASSET_ID%TYPE
37 ,asset_number OKL_TERMNT_INTERFACE.ASSET_NUMBER%TYPE
38 ,asset_description OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION%TYPE
39 ,serial_number OKL_TERMNT_INTERFACE.SERIAL_NUMBER%TYPE
40 ,orig_system OKL_TERMNT_INTERFACE.ORIG_SYSTEM%TYPE
41 ,orig_system_reference OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE%TYPE
42 ,units_to_terminate OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE%TYPE
43 ,comments OKL_TERMNT_INTERFACE.COMMENTS%TYPE
44 ,date_processed OKL_TERMNT_INTERFACE.DATE_PROCESSED%TYPE
45 ,date_effective_from OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM%TYPE
46 ,termination_notification_email OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL%TYPE
47 ,termination_notification_yn OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN%TYPE
48 ,auto_accept_yn OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN%TYPE
49 ,quote_type_code OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE%TYPE
50 ,quote_reason_code OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE%TYPE
51 ,qte_id OKL_TERMNT_INTERFACE.QTE_ID%TYPE
52 ,status OKL_TERMNT_INTERFACE.STATUS%TYPE
53 ,org_id OKL_TERMNT_INTERFACE.ORG_ID%TYPE
54 ,request_id OKL_TERMNT_INTERFACE.REQUEST_ID%TYPE
55 ,program_application_id OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID%TYPE
56 ,program_id OKL_TERMNT_INTERFACE.PROGRAM_ID%TYPE
57 ,program_update_date OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE%TYPE
58 ,attribute_category OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY%TYPE
59 ,attribute1 OKL_TERMNT_INTERFACE.ATTRIBUTE1%TYPE
60 ,attribute2 OKL_TERMNT_INTERFACE.ATTRIBUTE2%TYPE
61 ,attribute3 OKL_TERMNT_INTERFACE.ATTRIBUTE3%TYPE
62 ,attribute4 OKL_TERMNT_INTERFACE.ATTRIBUTE4%TYPE
63 ,attribute5 OKL_TERMNT_INTERFACE.ATTRIBUTE5%TYPE
64 ,attribute6 OKL_TERMNT_INTERFACE.ATTRIBUTE6%TYPE
65 ,attribute7 OKL_TERMNT_INTERFACE.ATTRIBUTE7%TYPE
66 ,attribute8 OKL_TERMNT_INTERFACE.ATTRIBUTE8%TYPE
67 ,attribute9 OKL_TERMNT_INTERFACE.ATTRIBUTE9%TYPE
68 ,attribute10 OKL_TERMNT_INTERFACE.ATTRIBUTE10%TYPE
69 ,attribute11 OKL_TERMNT_INTERFACE.ATTRIBUTE11%TYPE
70 ,attribute12 OKL_TERMNT_INTERFACE.ATTRIBUTE12%TYPE
71 ,attribute13 OKL_TERMNT_INTERFACE.ATTRIBUTE13%TYPE
72 ,attribute14 OKL_TERMNT_INTERFACE.ATTRIBUTE14%TYPE
73 ,attribute15 OKL_TERMNT_INTERFACE.ATTRIBUTE15%TYPE
74 ,created_by OKL_TERMNT_INTERFACE.CREATED_BY%TYPE
75 ,creation_date OKL_TERMNT_INTERFACE.CREATION_DATE%TYPE
76 ,last_updated_by OKL_TERMNT_INTERFACE.LAST_UPDATED_BY%TYPE
77 ,last_update_date OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE%TYPE
78 ,last_update_login OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN%TYPE
79 ,group_number OKL_TERMNT_INTERFACE.GROUP_NUMBER%TYPE);
80
81 g_miss_tif_rec tif_rec_type;
82 -- OKL_TERMNT_INTERFACE table Spec
83 TYPE tif_tbl_type IS TABLE OF tif_rec_type
84 INDEX BY BINARY_INTEGER;
85
86 -- OKL_TERMNT_INTF_PTY record Spec
87 TYPE tip_rec_type IS RECORD(
88 row_id ROWID
89 ,contract_party_id OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID%TYPE
90 ,contract_party_role OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE%TYPE
91 ,contract_party_name OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME%TYPE
92 ,contract_party_number OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER%TYPE
93 ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE
94 ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE
95 ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE
96 ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE
97 ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE
98 ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE
99 ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE
100 ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE
101 ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE
102 ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE
103 ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE
104 ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE
105 ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE
106 ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE
107 ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE
108 ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE
109 ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE
110 ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE
111 ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE
112 ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE
113 ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE
114 ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE
115 ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE
116 ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE
117 ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE
118 ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE
119 ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE
120 ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE
121 ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE
122 ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE
123 ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE
124 ,last_updated_by OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY%TYPE
125 ,last_update_date OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE%TYPE
126 ,last_update_login OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN%TYPE
127 ,quote_role_code OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE%TYPE);
128
129 g_miss_tip_rec tip_rec_type;
130 -- OKL_TERMNT_INTF_PTY table Spec
131 TYPE tip_tbl_type IS TABLE OF tip_rec_type
132 INDEX BY BINARY_INTEGER;
133
134 ---------------------------------------------------------------------------
135 -- PROCEDURES
136 ---------------------------------------------------------------------------
137
138 PROCEDURE termination_interface(p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 x_return_status OUT NOCOPY VARCHAR2,
143 err_buf OUT NOCOPY VARCHAR2,
144 ret_code OUT NOCOPY NUMBER);
145
146 END OKL_AM_TERMNT_INTERFACE_PVT;