3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE fpr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: dsf_id NUMBER := OKC_API.G_MISS_NUM,
9: pmr_id NUMBER := OKC_API.G_MISS_NUM,
10: fpr_type OKL_FNCTN_PRMTRS_B.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE fpr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: dsf_id NUMBER := OKC_API.G_MISS_NUM,
9: pmr_id NUMBER := OKC_API.G_MISS_NUM,
10: fpr_type OKL_FNCTN_PRMTRS_B.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: sequence_number NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE fpr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: dsf_id NUMBER := OKC_API.G_MISS_NUM,
9: pmr_id NUMBER := OKC_API.G_MISS_NUM,
10: fpr_type OKL_FNCTN_PRMTRS_B.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: sequence_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE fpr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: dsf_id NUMBER := OKC_API.G_MISS_NUM,
9: pmr_id NUMBER := OKC_API.G_MISS_NUM,
10: fpr_type OKL_FNCTN_PRMTRS_B.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: sequence_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_FNCTN_PRMTRS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: dsf_id NUMBER := OKC_API.G_MISS_NUM,
9: pmr_id NUMBER := OKC_API.G_MISS_NUM,
10: fpr_type OKL_FNCTN_PRMTRS_B.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: sequence_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_FNCTN_PRMTRS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
8: dsf_id NUMBER := OKC_API.G_MISS_NUM,
9: pmr_id NUMBER := OKC_API.G_MISS_NUM,
10: fpr_type OKL_FNCTN_PRMTRS_B.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: sequence_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_FNCTN_PRMTRS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_FNCTN_PRMTRS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
9: pmr_id NUMBER := OKC_API.G_MISS_NUM,
10: fpr_type OKL_FNCTN_PRMTRS_B.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: sequence_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_FNCTN_PRMTRS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_FNCTN_PRMTRS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
10: fpr_type OKL_FNCTN_PRMTRS_B.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: sequence_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_FNCTN_PRMTRS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_FNCTN_PRMTRS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: g_miss_fpr_rec fpr_rec_type;
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: sequence_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_FNCTN_PRMTRS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_FNCTN_PRMTRS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: g_miss_fpr_rec fpr_rec_type;
19: TYPE fpr_tbl_type IS TABLE OF fpr_rec_type
12: sequence_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_FNCTN_PRMTRS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_FNCTN_PRMTRS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: g_miss_fpr_rec fpr_rec_type;
19: TYPE fpr_tbl_type IS TABLE OF fpr_rec_type
20: INDEX BY BINARY_INTEGER;
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_FNCTN_PRMTRS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_FNCTN_PRMTRS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: g_miss_fpr_rec fpr_rec_type;
19: TYPE fpr_tbl_type IS TABLE OF fpr_rec_type
20: INDEX BY BINARY_INTEGER;
21: TYPE okl_fnctn_prmtrs_tl_rec_type IS RECORD (
18: g_miss_fpr_rec fpr_rec_type;
19: TYPE fpr_tbl_type IS TABLE OF fpr_rec_type
20: INDEX BY BINARY_INTEGER;
21: TYPE okl_fnctn_prmtrs_tl_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: language OKL_FNCTN_PRMTRS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
24: source_lang OKL_FNCTN_PRMTRS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
25: sfwt_flag OKL_FNCTN_PRMTRS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: value OKL_FNCTN_PRMTRS_TL.VALUE%TYPE := OKC_API.G_MISS_CHAR,
19: TYPE fpr_tbl_type IS TABLE OF fpr_rec_type
20: INDEX BY BINARY_INTEGER;
21: TYPE okl_fnctn_prmtrs_tl_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: language OKL_FNCTN_PRMTRS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
24: source_lang OKL_FNCTN_PRMTRS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
25: sfwt_flag OKL_FNCTN_PRMTRS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: value OKL_FNCTN_PRMTRS_TL.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: instructions OKL_FNCTN_PRMTRS_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
20: INDEX BY BINARY_INTEGER;
21: TYPE okl_fnctn_prmtrs_tl_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: language OKL_FNCTN_PRMTRS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
24: source_lang OKL_FNCTN_PRMTRS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
25: sfwt_flag OKL_FNCTN_PRMTRS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: value OKL_FNCTN_PRMTRS_TL.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: instructions OKL_FNCTN_PRMTRS_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
21: TYPE okl_fnctn_prmtrs_tl_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: language OKL_FNCTN_PRMTRS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
24: source_lang OKL_FNCTN_PRMTRS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
25: sfwt_flag OKL_FNCTN_PRMTRS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: value OKL_FNCTN_PRMTRS_TL.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: instructions OKL_FNCTN_PRMTRS_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_FNCTN_PRMTRS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22: id NUMBER := OKC_API.G_MISS_NUM,
23: language OKL_FNCTN_PRMTRS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
24: source_lang OKL_FNCTN_PRMTRS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
25: sfwt_flag OKL_FNCTN_PRMTRS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: value OKL_FNCTN_PRMTRS_TL.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: instructions OKL_FNCTN_PRMTRS_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_FNCTN_PRMTRS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23: language OKL_FNCTN_PRMTRS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
24: source_lang OKL_FNCTN_PRMTRS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
25: sfwt_flag OKL_FNCTN_PRMTRS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: value OKL_FNCTN_PRMTRS_TL.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: instructions OKL_FNCTN_PRMTRS_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_FNCTN_PRMTRS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_FNCTN_PRMTRS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: source_lang OKL_FNCTN_PRMTRS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
25: sfwt_flag OKL_FNCTN_PRMTRS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: value OKL_FNCTN_PRMTRS_TL.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: instructions OKL_FNCTN_PRMTRS_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_FNCTN_PRMTRS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_FNCTN_PRMTRS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM);
25: sfwt_flag OKL_FNCTN_PRMTRS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: value OKL_FNCTN_PRMTRS_TL.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: instructions OKL_FNCTN_PRMTRS_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_FNCTN_PRMTRS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_FNCTN_PRMTRS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM);
33: g_miss_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
26: value OKL_FNCTN_PRMTRS_TL.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: instructions OKL_FNCTN_PRMTRS_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_FNCTN_PRMTRS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_FNCTN_PRMTRS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM);
33: g_miss_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
34: TYPE okl_fnctn_prmtrs_tl_tbl_type IS TABLE OF okl_fnctn_prmtrs_tl_rec_type
27: instructions OKL_FNCTN_PRMTRS_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_FNCTN_PRMTRS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_FNCTN_PRMTRS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM);
33: g_miss_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
34: TYPE okl_fnctn_prmtrs_tl_tbl_type IS TABLE OF okl_fnctn_prmtrs_tl_rec_type
35: INDEX BY BINARY_INTEGER;
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_FNCTN_PRMTRS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_FNCTN_PRMTRS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM);
33: g_miss_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
34: TYPE okl_fnctn_prmtrs_tl_tbl_type IS TABLE OF okl_fnctn_prmtrs_tl_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE fprv_rec_type IS RECORD (
33: g_miss_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
34: TYPE okl_fnctn_prmtrs_tl_tbl_type IS TABLE OF okl_fnctn_prmtrs_tl_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE fprv_rec_type IS RECORD (
37: id NUMBER := OKC_API.G_MISS_NUM,
38: object_version_number NUMBER := OKC_API.G_MISS_NUM,
39: sfwt_flag OKL_FNCTN_PRMTRS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: dsf_id NUMBER := OKC_API.G_MISS_NUM,
41: pmr_id NUMBER := OKC_API.G_MISS_NUM,
34: TYPE okl_fnctn_prmtrs_tl_tbl_type IS TABLE OF okl_fnctn_prmtrs_tl_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE fprv_rec_type IS RECORD (
37: id NUMBER := OKC_API.G_MISS_NUM,
38: object_version_number NUMBER := OKC_API.G_MISS_NUM,
39: sfwt_flag OKL_FNCTN_PRMTRS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: dsf_id NUMBER := OKC_API.G_MISS_NUM,
41: pmr_id NUMBER := OKC_API.G_MISS_NUM,
42: sequence_number NUMBER := OKC_API.G_MISS_NUM,
35: INDEX BY BINARY_INTEGER;
36: TYPE fprv_rec_type IS RECORD (
37: id NUMBER := OKC_API.G_MISS_NUM,
38: object_version_number NUMBER := OKC_API.G_MISS_NUM,
39: sfwt_flag OKL_FNCTN_PRMTRS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: dsf_id NUMBER := OKC_API.G_MISS_NUM,
41: pmr_id NUMBER := OKC_API.G_MISS_NUM,
42: sequence_number NUMBER := OKC_API.G_MISS_NUM,
43: value OKL_FNCTN_PRMTRS_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
36: TYPE fprv_rec_type IS RECORD (
37: id NUMBER := OKC_API.G_MISS_NUM,
38: object_version_number NUMBER := OKC_API.G_MISS_NUM,
39: sfwt_flag OKL_FNCTN_PRMTRS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: dsf_id NUMBER := OKC_API.G_MISS_NUM,
41: pmr_id NUMBER := OKC_API.G_MISS_NUM,
42: sequence_number NUMBER := OKC_API.G_MISS_NUM,
43: value OKL_FNCTN_PRMTRS_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
44: instructions OKL_FNCTN_PRMTRS_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
37: id NUMBER := OKC_API.G_MISS_NUM,
38: object_version_number NUMBER := OKC_API.G_MISS_NUM,
39: sfwt_flag OKL_FNCTN_PRMTRS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: dsf_id NUMBER := OKC_API.G_MISS_NUM,
41: pmr_id NUMBER := OKC_API.G_MISS_NUM,
42: sequence_number NUMBER := OKC_API.G_MISS_NUM,
43: value OKL_FNCTN_PRMTRS_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
44: instructions OKL_FNCTN_PRMTRS_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
45: fpr_type OKL_FNCTN_PRMTRS_V.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
38: object_version_number NUMBER := OKC_API.G_MISS_NUM,
39: sfwt_flag OKL_FNCTN_PRMTRS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: dsf_id NUMBER := OKC_API.G_MISS_NUM,
41: pmr_id NUMBER := OKC_API.G_MISS_NUM,
42: sequence_number NUMBER := OKC_API.G_MISS_NUM,
43: value OKL_FNCTN_PRMTRS_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
44: instructions OKL_FNCTN_PRMTRS_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
45: fpr_type OKL_FNCTN_PRMTRS_V.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
39: sfwt_flag OKL_FNCTN_PRMTRS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: dsf_id NUMBER := OKC_API.G_MISS_NUM,
41: pmr_id NUMBER := OKC_API.G_MISS_NUM,
42: sequence_number NUMBER := OKC_API.G_MISS_NUM,
43: value OKL_FNCTN_PRMTRS_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
44: instructions OKL_FNCTN_PRMTRS_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
45: fpr_type OKL_FNCTN_PRMTRS_V.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_FNCTN_PRMTRS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
40: dsf_id NUMBER := OKC_API.G_MISS_NUM,
41: pmr_id NUMBER := OKC_API.G_MISS_NUM,
42: sequence_number NUMBER := OKC_API.G_MISS_NUM,
43: value OKL_FNCTN_PRMTRS_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
44: instructions OKL_FNCTN_PRMTRS_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
45: fpr_type OKL_FNCTN_PRMTRS_V.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_FNCTN_PRMTRS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: pmr_id NUMBER := OKC_API.G_MISS_NUM,
42: sequence_number NUMBER := OKC_API.G_MISS_NUM,
43: value OKL_FNCTN_PRMTRS_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
44: instructions OKL_FNCTN_PRMTRS_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
45: fpr_type OKL_FNCTN_PRMTRS_V.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_FNCTN_PRMTRS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_FNCTN_PRMTRS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
42: sequence_number NUMBER := OKC_API.G_MISS_NUM,
43: value OKL_FNCTN_PRMTRS_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
44: instructions OKL_FNCTN_PRMTRS_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
45: fpr_type OKL_FNCTN_PRMTRS_V.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_FNCTN_PRMTRS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_FNCTN_PRMTRS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
43: value OKL_FNCTN_PRMTRS_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
44: instructions OKL_FNCTN_PRMTRS_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
45: fpr_type OKL_FNCTN_PRMTRS_V.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_FNCTN_PRMTRS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_FNCTN_PRMTRS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: g_miss_fprv_rec fprv_rec_type;
44: instructions OKL_FNCTN_PRMTRS_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR,
45: fpr_type OKL_FNCTN_PRMTRS_V.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_FNCTN_PRMTRS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_FNCTN_PRMTRS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: g_miss_fprv_rec fprv_rec_type;
52: TYPE fprv_tbl_type IS TABLE OF fprv_rec_type
45: fpr_type OKL_FNCTN_PRMTRS_V.FPR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_FNCTN_PRMTRS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_FNCTN_PRMTRS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: g_miss_fprv_rec fprv_rec_type;
52: TYPE fprv_tbl_type IS TABLE OF fprv_rec_type
53: INDEX BY BINARY_INTEGER;
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_FNCTN_PRMTRS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_FNCTN_PRMTRS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: g_miss_fprv_rec fprv_rec_type;
52: TYPE fprv_tbl_type IS TABLE OF fprv_rec_type
53: INDEX BY BINARY_INTEGER;
54: ---------------------------------------------------------------------------
53: INDEX BY BINARY_INTEGER;
54: ---------------------------------------------------------------------------
55: -- GLOBAL MESSAGE CONSTANTS
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
54: ---------------------------------------------------------------------------
55: -- GLOBAL MESSAGE CONSTANTS
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
55: -- GLOBAL MESSAGE CONSTANTS
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: -- START CHANGE : mvasudev -- 05/02/2001
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: -- START CHANGE : mvasudev -- 05/02/2001
68: -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: -- START CHANGE : mvasudev -- 05/02/2001
68: -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
69: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: -- START CHANGE : mvasudev -- 05/02/2001
68: -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
69: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
70: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
79: ---------------------------------------------------------------------------
80: -- GLOBAL VARIABLES
81: ---------------------------------------------------------------------------
82: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FPR_PVT';
83: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
84:
85: -- RPOONUGA001: global variables
86: G_STATIC_TYPE CONSTANT VARCHAR2(200) := 'STATIC';
87: G_CONTEXT_TYPE CONSTANT VARCHAR2(200) := 'CONTEXT';
103: PROCEDURE api_copy;
104: PROCEDURE add_language;
105: PROCEDURE insert_row(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_fprv_rec IN fprv_rec_type,
112: x_fprv_rec OUT NOCOPY fprv_rec_type);
113:
114: PROCEDURE insert_row(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_fprv_tbl IN fprv_tbl_type,
121: x_fprv_tbl OUT NOCOPY fprv_tbl_type);
122:
123: PROCEDURE lock_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_fprv_rec IN fprv_rec_type);
129: p_fprv_rec IN fprv_rec_type);
130:
131: PROCEDURE lock_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_fprv_tbl IN fprv_tbl_type);
137: p_fprv_tbl IN fprv_tbl_type);
138:
139: PROCEDURE update_row(
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: p_fprv_rec IN fprv_rec_type,
146: x_fprv_rec OUT NOCOPY fprv_rec_type);
147:
148: PROCEDURE update_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_fprv_tbl IN fprv_tbl_type,
155: x_fprv_tbl OUT NOCOPY fprv_tbl_type);
156:
157: PROCEDURE delete_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_fprv_rec IN fprv_rec_type);
163: p_fprv_rec IN fprv_rec_type);
164:
165: PROCEDURE delete_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_fprv_tbl IN fprv_tbl_type);
171: p_fprv_tbl IN fprv_tbl_type);
172:
173: PROCEDURE validate_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_fprv_rec IN fprv_rec_type);
179: p_fprv_rec IN fprv_rec_type);
180:
181: PROCEDURE validate_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_fprv_tbl IN fprv_tbl_type);