PACKAGE: APPS.IEX_CASE_INFO_PUB

Source

1 PACKAGE IEX_CASE_INFO_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexcsins.pls 120.2 2004/11/01 16:34:04 jsanju ship $ */
3 
4 
5 
6   ---------------------------------------------------------------------
7   -- GLOBAL MESSAGE CONSTANTS
8   ---------------------------------------------------------------------
9   G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'IEX_REQUIRED_VALUE';
10   G_ERROR        CONSTANT VARCHAR2(200) := 'IEX_ERROR';
11   G_UNEXPECTED_ERROR    CONSTANT VARCHAR2(200) := 'IEX_UNEXPECTED_ERROR';
12   G_SQLERRM_TOKEN       CONSTANT VARCHAR2(200) := 'IEX_SQLERRM';
13   G_SQLCODE_TOKEN       CONSTANT VARCHAR2(200) := 'IEX_SQLCODE';
14   ---------------------------------------------------------------------
15   -- GLOBAL VARIABLES
16   ---------------------------------------------------------------------
17   G_PKG_NAME  CONSTANT VARCHAR2(200) := 'IEX_CASE_INFO_PUB';
18   G_APP_NAME  CONSTANT VARCHAR2(3)   := 'IEX';
19 
20    --------------------------------------------------------------------
21   -- GLOBAL EXCEPTION
22   ---------------------------------------------------------------------
23   G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24   ---------------------------------------------------------------------
25   -- Procedures and Functions
26   ---------------------------------------------------------------------
27 
28 
29 
30   /* begin raverma 06202003 add procedure to get overdue amount */
31   FUNCTION get_Amount_Overdue (p_case_id IN NUMBER) return NUMBER;
32 
33   -- Returns Total Receivable Amount for a Case
34   PROCEDURE get_total_rcvble_for_case (
35      p_case_id       IN NUMBER,
36      x_total_amt     OUT NOCOPY NUMBER,
37      x_return_status OUT NOCOPY VARCHAR2);
38   PROCEDURE get_total_net_book_value (
39      p_case_id       IN NUMBER,
40      x_total_amt     OUT NOCOPY NUMBER,
41      x_return_status OUT NOCOPY VARCHAR2);
42   PROCEDURE get_contract_oec(
43      p_case_id       IN NUMBER,
44      x_total_amt     OUT NOCOPY NUMBER,
45      x_return_status OUT NOCOPY VARCHAR2);
46 
47   PROCEDURE get_contract_tradein(
48      p_case_id       IN NUMBER,
49      x_total_amt     OUT NOCOPY NUMBER,
50      x_return_status OUT NOCOPY VARCHAR2);
51 
52   PROCEDURE get_contract_capital_reduction(
53      p_case_id       IN NUMBER,
54      x_total_amt     OUT NOCOPY NUMBER,
55      x_return_status OUT NOCOPY VARCHAR2);
56 
57   PROCEDURE get_contract_fees_capitalized(
58      p_case_id       IN NUMBER,
59      x_total_amt     OUT NOCOPY NUMBER,
60      x_return_status OUT NOCOPY VARCHAR2);
61   PROCEDURE get_total_capital_amount(
62      p_case_id       IN NUMBER,
63      x_total_amt     OUT NOCOPY NUMBER,
64      x_return_status OUT NOCOPY VARCHAR2);
65 
66   FUNCTION get_total_rcvble_for_case_fn (p_case_id IN NUMBER) return NUMBER;
67 
68 
69 END IEX_CASE_INFO_PUB;