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