[Home] [Help]
PACKAGE: APPS.IEX_CO_TRANSFER_EA_PVT
Source
1 PACKAGE IEX_CO_TRANSFER_EA_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEXRTEAS.pls 120.0 2004/01/24 03:15:45 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 TYPE case_rec_type is RECORD (
8 cas_id NUMBER,
9 case_number VARCHAR2(240),
10 case_owner VARCHAR2(360),
11 case_status VARCHAR2(80),
12 party_name VARCHAR2(360),
13 party_type VARCHAR2(80),
14 party_address VARCHAR2(1995),
15 last_transfer_date DATE,
16 case_review_date DATE,
17 ext_agncy_name VARCHAR2(80)
18 );
19
20 TYPE case_tbl_type IS TABLE OF case_rec_type INDEX BY BINARY_INTEGER;
21
22 TYPE form_contract_rec_type is RECORD (
23 khr_id NUMBER,
24 contract_number VARCHAR2(120),
25 contract_type VARCHAR2(80),
26 contract_status VARCHAR2(80),
27 original_amount NUMBER(14, 3),
28 start_date DATE,
29 close_date DATE,
30 term_duration NUMBER(10),
31 monthly_payment_amount NUMBER(14, 3),
32 last_payment_date DATE,
33 delinquency_occurance_date DATE,
34 past_due_amount NUMBER(14, 3),
35 past_due_days NUMBER(10),
36 outstanding_receivable NUMBER(14, 3)
37 );
38
39 TYPE form_contract_tbl_type IS TABLE OF form_contract_rec_type INDEX BY BINARY_INTEGER;
40
41
42 ---------------------------------------------------------------------------
43 -- GLOBAL MESSAGE CONSTANTS
44 ---------------------------------------------------------------------------
45 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
46 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
47 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
48 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
49 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
50 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
51 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
52 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
53 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
54 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
55 ---------------------------------------------------------------------------
56 -- GLOBAL VARIABLES
57 ---------------------------------------------------------------------------
58 G_PKG_NAME CONSTANT VARCHAR2(200) := 'IEX_CO_TRANSFER_EA_PVT';
59 G_APP_NAME CONSTANT VARCHAR2(3) := 'IEX';
60
61 ---------------------------------------------------------------------------
62 -- GLOBAL EXCEPTION
63 ---------------------------------------------------------------------------
64 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
65 G_INVALID_PARAMETERS EXCEPTION;
66
67 PROCEDURE get_case_details (
68 p_cas_id IN NUMBER,
69 x_case_rec OUT NOCOPY case_rec_type,
70 x_return_status OUT NOCOPY VARCHAR2);
71
72 PROCEDURE get_contract_details (
73 p_khr_id IN NUMBER,
74 x_form_contract_rec OUT NOCOPY form_contract_rec_type,
75 x_return_status OUT NOCOPY VARCHAR2);
76
77 END IEX_CO_TRANSFER_EA_PVT;