DBA Data[Home] [Help]

APPS.OKL_INS_QUOTE_PVT dependencies on OKC_API

Line 14: KLE_ID NUMBER := OKC_API.G_MISS_NUM,

10: TYPE inav_tbl_type IS TABLE OF inav_rec_type INDEX BY BINARY_INTEGER;
11:
12:
13: TYPE iasset_rec_type IS RECORD (
14: KLE_ID NUMBER := OKC_API.G_MISS_NUM,
15: premium NUMBER := OKC_API.G_MISS_NUM,
16: LESSOR_PREMIUM NUMBER := OKC_API.G_MISS_NUM
17: );
18: TYPE iasset_tbl_type IS TABLE OF iasset_rec_type INDEX BY BINARY_INTEGER;

Line 15: premium NUMBER := OKC_API.G_MISS_NUM,

11:
12:
13: TYPE iasset_rec_type IS RECORD (
14: KLE_ID NUMBER := OKC_API.G_MISS_NUM,
15: premium NUMBER := OKC_API.G_MISS_NUM,
16: LESSOR_PREMIUM NUMBER := OKC_API.G_MISS_NUM
17: );
18: TYPE iasset_tbl_type IS TABLE OF iasset_rec_type INDEX BY BINARY_INTEGER;
19:

Line 16: LESSOR_PREMIUM NUMBER := OKC_API.G_MISS_NUM

12:
13: TYPE iasset_rec_type IS RECORD (
14: KLE_ID NUMBER := OKC_API.G_MISS_NUM,
15: premium NUMBER := OKC_API.G_MISS_NUM,
16: LESSOR_PREMIUM NUMBER := OKC_API.G_MISS_NUM
17: );
18: TYPE iasset_tbl_type IS TABLE OF iasset_rec_type INDEX BY BINARY_INTEGER;
19:
20: TYPE policy_rec_type IS RECORD

Line 22: POLICY_NUMBER OKL_INS_POLICIES_V.POLICY_NUMBER%TYPE := OKC_API.G_MISS_CHAR,

18: TYPE iasset_tbl_type IS TABLE OF iasset_rec_type INDEX BY BINARY_INTEGER;
19:
20: TYPE policy_rec_type IS RECORD
21: (
22: POLICY_NUMBER OKL_INS_POLICIES_V.POLICY_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
23: CONTRACT_NUMBER OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
24: );
25:
26: TYPE policy_tbl_type IS TABLE OF policy_rec_type INDEX BY BINARY_INTEGER;

Line 23: CONTRACT_NUMBER OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

19:
20: TYPE policy_rec_type IS RECORD
21: (
22: POLICY_NUMBER OKL_INS_POLICIES_V.POLICY_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
23: CONTRACT_NUMBER OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
24: );
25:
26: TYPE policy_tbl_type IS TABLE OF policy_rec_type INDEX BY BINARY_INTEGER;
27:

Line 29: AMOUNT NUMBER := OKC_API.G_MISS_NUM,

25:
26: TYPE policy_tbl_type IS TABLE OF policy_rec_type INDEX BY BINARY_INTEGER;
27:
28: TYPE payment_rec_type IS RECORD(
29: AMOUNT NUMBER := OKC_API.G_MISS_NUM,
30: DUE_DATE DATE := OKC_API.G_MISS_DATE
31: );
32: TYPE payment_tbl_type IS TABLE OF payment_rec_type INDEX BY BINARY_INTEGER;
33:

Line 30: DUE_DATE DATE := OKC_API.G_MISS_DATE

26: TYPE policy_tbl_type IS TABLE OF policy_rec_type INDEX BY BINARY_INTEGER;
27:
28: TYPE payment_rec_type IS RECORD(
29: AMOUNT NUMBER := OKC_API.G_MISS_NUM,
30: DUE_DATE DATE := OKC_API.G_MISS_DATE
31: );
32: TYPE payment_tbl_type IS TABLE OF payment_rec_type INDEX BY BINARY_INTEGER;
33:
34:

Line 36: AMOUNT NUMBER := OKC_API.G_MISS_NUM,

32: TYPE payment_tbl_type IS TABLE OF payment_rec_type INDEX BY BINARY_INTEGER;
33:
34:
35: TYPE insexp_rec_type IS RECORD(
36: AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37: PERIOD NUMBER := OKC_API.G_MISS_NUM
38: );
39: TYPE insexp_tbl_type IS TABLE OF insexp_rec_type INDEX BY BINARY_INTEGER;
40:

Line 37: PERIOD NUMBER := OKC_API.G_MISS_NUM

33:
34:
35: TYPE insexp_rec_type IS RECORD(
36: AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37: PERIOD NUMBER := OKC_API.G_MISS_NUM
38: );
39: TYPE insexp_tbl_type IS TABLE OF insexp_rec_type INDEX BY BINARY_INTEGER;
40:
41: ---------------------------------------------------------------------------

Line 44: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;

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_VALUE_TOKEN CONSTANT VARCHAR2(200) := 'COL_VALUE';

Line 46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;

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_VALUE_TOKEN CONSTANT VARCHAR2(200) := 'COL_VALUE';
49: G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
50: G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';

Line 101: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

97:
98:
99: PROCEDURE save_quote(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: px_ipyv_rec IN OUT NOCOPY ipyv_rec_type,

Line 111: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

107: -- Need to have second procedure
108: -- so that we don't need TO recalculate
109: PROCEDURE save_accept_quote(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_ipyv_rec IN ipyv_rec_type,

Line 122: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

118: -- Need to have second procedure
119: -- so that we don't need to recalculate
120: PROCEDURE accept_quote(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_quote_id IN NUMBER );

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

127:
128:
129: PROCEDURE create_ins_streams(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_ipyv_rec IN ipyv_rec_type

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

137:
138:
139: PROCEDURE calc_lease_premium(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: px_ipyv_rec IN OUT NOCOPY ipyv_rec_type,

Line 152: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

148: );
149:
150: PROCEDURE calc_optional_premium(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_ipyv_rec IN ipyv_rec_type,

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

167: x_total_premium OUT NOCOPY NUMBER);
168:
169: PROCEDURE activate_ins_stream(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_ipyv_rec IN ipyv_rec_type

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

181: );
182:
183: PROCEDURE activate_ins_streams(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_contract_id IN NUMBER

Line 195: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

191:
192:
193: PROCEDURE activate_ins_policy(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_ins_policy_id IN NUMBER

Line 204: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

200: );
201:
202: PROCEDURE create_third_prt_ins(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_ipyv_rec IN ipyv_rec_type,