[Home] [Help]
PACKAGE: APPS.OKL_ISG_UTILS_PVT
Source
1 PACKAGE OKL_ISG_UTILS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRIGUS.pls 120.6 2007/10/12 20:11:24 djanaswa ship $ */
3
4 ---------------------------------------------------------------------------
5 -- Cursor Definitions
6 ---------------------------------------------------------------------------
7 -- Added by RGOOTY: Start
8 CURSOR G_GET_K_INFO_CSR( l_khr_id NUMBER ) IS
9 SELECT
10 pdt.id pdt_id,
11 chr.start_date start_date,
12 khr.deal_type deal_type,
13 nvl(pdt.reporting_pdt_id, -1) report_pdt_id
14 FROM okc_k_headers_v chr,
15 okl_k_headers khr,
16 okl_products_v pdt
17 WHERE khr.id = chr.id
18 AND chr.id = l_khr_id
19 AND khr.pdt_id = pdt.id(+);
20 -- Added by RGOOTY: End
21
22 ---------------------------------------------------------------------------
23 -- GLOBAL CONSTANTS
24 ---------------------------------------------------------------------------
25
26 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ISG_UTILS_PVT';
27 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
28 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
29 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
30 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
31
32 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
33
34 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
35 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
36
37
38 ---------------------------------------------------------------------------
39 -- GLOBAL EXCEPTIONS
40 ---------------------------------------------------------------------------
41
42 G_EXCEPTION_HALT EXCEPTION;
43
44 ---------------------------------------------------------------------------
45 -- GLOBAL DATASTRUCTURES
46 ---------------------------------------------------------------------------
47
48 PROCEDURE validate_strm_gen_template(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_khr_id IN NUMBER);
55
56 PROCEDURE get_primary_stream_type(
57 p_khr_id IN NUMBER,
58 p_pdt_id IN NUMBER,
59 p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
62 x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);
63
64 PROCEDURE get_primary_stream_type(
65 p_khr_id IN NUMBER,
66 p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
67 p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
70 x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);
71
72 PROCEDURE get_dependent_stream_type(
73 p_khr_id IN NUMBER,
74 p_pdt_id IN NUMBEr,
75 p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
78 x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);
79
80
81 PROCEDURE get_dependent_stream_type(
82 p_khr_id IN NUMBER,
83 p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
84 p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
87 x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);
88
89 PROCEDURE get_dependent_stream_type(
90 p_khr_id IN NUMBER,
91 p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
92 p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
93 p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
96 x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE);
97
98 -- Added by RGOOTY: Start
99 -- Performant APIs added which accept G_GET_K_INFO_CSR Record type
100 -- as an additional parameter instead of running repeatedly.
101 PROCEDURE get_dep_stream_type(
102 p_khr_id IN NUMBER,
103 p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
104 p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
107 x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,
108 p_get_k_info_rec IN G_GET_K_INFO_CSR%ROWTYPE);
109
110 PROCEDURE get_dep_stream_type(
111 p_khr_id IN NUMBER,
112 p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
113 p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
114 p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
117 x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,
118 p_get_k_info_rec IN G_GET_K_INFO_CSR%ROWTYPE);
119 -- Added by RGOOTY: End
120
121
122 -- Added by DJANASWA for ER 6274342 start
123 PROCEDURE get_arrears_pay_dates_option(
124 p_khr_id IN NUMBER,
125 x_arrears_pay_dates_option OUT NOCOPY VARCHAR2,
126 x_return_status OUT NOCOPY VARCHAR2);
127 -- Added by DJANASWA for ER 6274342 end
128
129
130
131 END OKL_ISG_UTILS_PVT;