DBA Data[Home] [Help]

APPS.OKL_SRT_PVT dependencies on OKL_FE_STD_RT_TMP_V

Line 8: template_name okl_fe_std_rt_tmp_v.template_name%TYPE,

4: --GLOBAL DATASTRUCTURES
5: --------------------------------------------------------------------------------
6: TYPE okl_srtv_rec IS RECORD (
7: std_rate_tmpl_id NUMBER,
8: template_name okl_fe_std_rt_tmp_v.template_name%TYPE,
9: template_desc okl_fe_std_rt_tmp_v.template_desc%TYPE,
10: object_version_number NUMBER,
11: org_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,

Line 9: template_desc okl_fe_std_rt_tmp_v.template_desc%TYPE,

5: --------------------------------------------------------------------------------
6: TYPE okl_srtv_rec IS RECORD (
7: std_rate_tmpl_id NUMBER,
8: template_name okl_fe_std_rt_tmp_v.template_name%TYPE,
9: template_desc okl_fe_std_rt_tmp_v.template_desc%TYPE,
10: object_version_number NUMBER,
11: org_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,

Line 12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,

8: template_name okl_fe_std_rt_tmp_v.template_name%TYPE,
9: template_desc okl_fe_std_rt_tmp_v.template_desc%TYPE,
10: object_version_number NUMBER,
11: org_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,

Line 13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,

9: template_desc okl_fe_std_rt_tmp_v.template_desc%TYPE,
10: object_version_number NUMBER,
11: org_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,

Line 14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,

10: object_version_number NUMBER,
11: org_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,

Line 16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,

12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,

Line 17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,

13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,

Line 19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,

15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,

Line 20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,

16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,

Line 21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,

17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,

Line 22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,

18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,

Line 24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,

20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,

Line 25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,

21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,

Line 26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,

22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,

Line 27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,

23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,

Line 28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,

24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,

Line 29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,

25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,

Line 30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,

26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,

Line 31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,

27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,

Line 32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,

28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,

Line 33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,

29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,

Line 34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,

30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,

Line 35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,

31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,

Line 36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,

32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,

Line 37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,

33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,

Line 38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,

34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,
42: last_updated_by NUMBER,

Line 39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,

35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,
42: last_updated_by NUMBER,
43: last_update_date okl_fe_std_rt_tmp_v.last_update_date%TYPE,

Line 41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,

37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,
42: last_updated_by NUMBER,
43: last_update_date okl_fe_std_rt_tmp_v.last_update_date%TYPE,
44: last_update_login NUMBER
45: );

Line 43: last_update_date okl_fe_std_rt_tmp_v.last_update_date%TYPE,

39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,
42: last_updated_by NUMBER,
43: last_update_date okl_fe_std_rt_tmp_v.last_update_date%TYPE,
44: last_update_login NUMBER
45: );
46:
47: TYPE okl_srtv_tbl IS TABLE OF okl_srtv_rec INDEX BY BINARY_INTEGER;

Line 60: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,

56: orig_std_rate_tmpl_id NUMBER,
57: rate_type_code okl_fe_std_rt_tmp_all_b.rate_type_code%TYPE,
58: frequency_code okl_fe_std_rt_tmp_all_b.frequency_code%TYPE,
59: index_id NUMBER,
60: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
61: sts_code okl_fe_std_rt_tmp_all_b.sts_code%TYPE,
62: effective_from_date okl_fe_std_rt_tmp_all_b.effective_from_date%TYPE,
63: effective_to_date okl_fe_std_rt_tmp_all_b.effective_to_date%TYPE,
64: srt_rate NUMBER,