eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LDB_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_PARTY_PAYMENT_HDR_V Record Spec
7: TYPE pphv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,ppl_id NUMBER := OKC_API.G_MISS_NUM

Line 9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKL_PARTY_PAYMENT_HDR_V Record Spec
7: TYPE pphv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
13: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

6: -- OKL_PARTY_PAYMENT_HDR_V Record Spec
7: TYPE pphv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
13: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR

Line 11: ,cle_id NUMBER := OKC_API.G_MISS_NUM

7: TYPE pphv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
13: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
15: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR

Line 12: ,ppl_id NUMBER := OKC_API.G_MISS_NUM

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
13: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
15: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
16: ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE

Line 13: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE

9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
13: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
15: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
16: ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
17: ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE

Line 14: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR

10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
13: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
15: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
16: ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
17: ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
18: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR

Line 15: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR

11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
13: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
15: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
16: ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
17: ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
18: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
19: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM

Line 16: ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE

12: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
13: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
15: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
16: ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
17: ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
18: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
19: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
20: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 17: ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE

13: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
15: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
16: ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
17: ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
18: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
19: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKL_PARTY_PAYMENT_HDR_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 18: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR

14: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
15: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
16: ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
17: ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
18: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
19: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKL_PARTY_PAYMENT_HDR_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 19: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM

15: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
16: ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
17: ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
18: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
19: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKL_PARTY_PAYMENT_HDR_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKL_PARTY_PAYMENT_HDR_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 20: ,created_by NUMBER := OKC_API.G_MISS_NUM

16: ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
17: ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
18: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
19: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKL_PARTY_PAYMENT_HDR_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKL_PARTY_PAYMENT_HDR_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 21: ,creation_date OKL_PARTY_PAYMENT_HDR_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

17: ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
18: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
19: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKL_PARTY_PAYMENT_HDR_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKL_PARTY_PAYMENT_HDR_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
25: G_MISS_pphv_rec pphv_rec_type;

Line 22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

18: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
19: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKL_PARTY_PAYMENT_HDR_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKL_PARTY_PAYMENT_HDR_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
25: G_MISS_pphv_rec pphv_rec_type;
26: TYPE pphv_tbl_type IS TABLE OF pphv_rec_type

Line 23: ,last_update_date OKL_PARTY_PAYMENT_HDR_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

19: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKL_PARTY_PAYMENT_HDR_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKL_PARTY_PAYMENT_HDR_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
25: G_MISS_pphv_rec pphv_rec_type;
26: TYPE pphv_tbl_type IS TABLE OF pphv_rec_type
27: INDEX BY BINARY_INTEGER;

Line 24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKL_PARTY_PAYMENT_HDR_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKL_PARTY_PAYMENT_HDR_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
25: G_MISS_pphv_rec pphv_rec_type;
26: TYPE pphv_tbl_type IS TABLE OF pphv_rec_type
27: INDEX BY BINARY_INTEGER;
28: -- OKL_PARTY_PAYMENT_HDR Record Spec

Line 30: id NUMBER := OKC_API.G_MISS_NUM

26: TYPE pphv_tbl_type IS TABLE OF pphv_rec_type
27: INDEX BY BINARY_INTEGER;
28: -- OKL_PARTY_PAYMENT_HDR Record Spec
29: TYPE pph_rec_type IS RECORD (
30: id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,ppl_id NUMBER := OKC_API.G_MISS_NUM

Line 31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

27: INDEX BY BINARY_INTEGER;
28: -- OKL_PARTY_PAYMENT_HDR Record Spec
29: TYPE pph_rec_type IS RECORD (
30: id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
35: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 32: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

28: -- OKL_PARTY_PAYMENT_HDR Record Spec
29: TYPE pph_rec_type IS RECORD (
30: id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
35: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR

Line 33: ,cle_id NUMBER := OKC_API.G_MISS_NUM

29: TYPE pph_rec_type IS RECORD (
30: id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
35: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
37: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR

Line 34: ,ppl_id NUMBER := OKC_API.G_MISS_NUM

30: id NUMBER := OKC_API.G_MISS_NUM
31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
35: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
37: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
38: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE

Line 35: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE

31: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
35: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
37: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
38: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
39: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE

Line 36: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR

32: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
35: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
37: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
38: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
39: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
40: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR

Line 37: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR

33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
35: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
37: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
38: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
39: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
40: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
41: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM

Line 38: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE

34: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
35: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
37: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
38: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
39: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
40: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
41: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 39: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE

35: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
37: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
38: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
39: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
40: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
41: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 40: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR

36: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
37: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
38: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
39: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
40: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
41: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 41: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM

37: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
38: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
39: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
40: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
41: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 42: ,created_by NUMBER := OKC_API.G_MISS_NUM

38: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
39: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
40: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
41: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 43: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

39: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
40: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
41: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: G_MISS_pph_rec pph_rec_type;

Line 44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

40: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
41: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: G_MISS_pph_rec pph_rec_type;
48: TYPE pph_tbl_type IS TABLE OF pph_rec_type

Line 45: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

41: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: G_MISS_pph_rec pph_rec_type;
48: TYPE pph_tbl_type IS TABLE OF pph_rec_type
49: INDEX BY BINARY_INTEGER;

Line 46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: G_MISS_pph_rec pph_rec_type;
48: TYPE pph_tbl_type IS TABLE OF pph_rec_type
49: INDEX BY BINARY_INTEGER;
50: -- OKL_PARTY_PAYMENT_HDR_H Record Spec

Line 52: id NUMBER := OKC_API.G_MISS_NUM

48: TYPE pph_tbl_type IS TABLE OF pph_rec_type
49: INDEX BY BINARY_INTEGER;
50: -- OKL_PARTY_PAYMENT_HDR_H Record Spec
51: TYPE pphh_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM
53: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
54: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
55: ,cle_id NUMBER := OKC_API.G_MISS_NUM
56: ,ppl_id NUMBER := OKC_API.G_MISS_NUM

Line 53: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

49: INDEX BY BINARY_INTEGER;
50: -- OKL_PARTY_PAYMENT_HDR_H Record Spec
51: TYPE pphh_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM
53: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
54: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
55: ,cle_id NUMBER := OKC_API.G_MISS_NUM
56: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
57: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 54: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

50: -- OKL_PARTY_PAYMENT_HDR_H Record Spec
51: TYPE pphh_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM
53: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
54: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
55: ,cle_id NUMBER := OKC_API.G_MISS_NUM
56: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
57: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR

Line 55: ,cle_id NUMBER := OKC_API.G_MISS_NUM

51: TYPE pphh_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM
53: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
54: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
55: ,cle_id NUMBER := OKC_API.G_MISS_NUM
56: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
57: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
59: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR

Line 56: ,ppl_id NUMBER := OKC_API.G_MISS_NUM

52: id NUMBER := OKC_API.G_MISS_NUM
53: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
54: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
55: ,cle_id NUMBER := OKC_API.G_MISS_NUM
56: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
57: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
59: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
60: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE

Line 57: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE

53: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
54: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
55: ,cle_id NUMBER := OKC_API.G_MISS_NUM
56: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
57: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
59: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
60: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
61: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE

Line 58: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR

54: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
55: ,cle_id NUMBER := OKC_API.G_MISS_NUM
56: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
57: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
59: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
60: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
61: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
62: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR

Line 59: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR

55: ,cle_id NUMBER := OKC_API.G_MISS_NUM
56: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
57: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
59: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
60: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
61: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
62: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
63: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM

Line 60: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE

56: ,ppl_id NUMBER := OKC_API.G_MISS_NUM
57: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
59: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
60: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
61: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
62: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
63: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
64: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 61: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE

57: ,passthru_start_date OKL_PARTY_PAYMENT_HDR.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
59: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
60: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
61: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
62: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
63: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 62: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR

58: ,payout_basis OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
59: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
60: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
61: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
62: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
63: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 63: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM

59: ,payout_basis_formula OKL_PARTY_PAYMENT_HDR.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
60: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
61: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
62: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
63: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 64: ,created_by NUMBER := OKC_API.G_MISS_NUM

60: ,effective_from OKL_PARTY_PAYMENT_HDR.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
61: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
62: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
63: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 65: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

61: ,effective_to OKL_PARTY_PAYMENT_HDR.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
62: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
63: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_pphh_rec pphh_rec_type;

Line 66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

62: ,passthru_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
63: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_pphh_rec pphh_rec_type;
70: TYPE pphh_tbl_type IS TABLE OF pphh_rec_type

Line 67: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

63: ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_pphh_rec pphh_rec_type;
70: TYPE pphh_tbl_type IS TABLE OF pphh_rec_type
71: INDEX BY BINARY_INTEGER;

Line 68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_PARTY_PAYMENT_HDR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_PARTY_PAYMENT_HDR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_pphh_rec pphh_rec_type;
70: TYPE pphh_tbl_type IS TABLE OF pphh_rec_type
71: INDEX BY BINARY_INTEGER;
72: ---------------------------------------------------------------------------

Line 75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

71: INDEX BY BINARY_INTEGER;
72: ---------------------------------------------------------------------------
73: -- GLOBAL MESSAGE CONSTANTS
74: ---------------------------------------------------------------------------
75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

72: ---------------------------------------------------------------------------
73: -- GLOBAL MESSAGE CONSTANTS
74: ---------------------------------------------------------------------------
75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

73: -- GLOBAL MESSAGE CONSTANTS
74: ---------------------------------------------------------------------------
75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

74: ---------------------------------------------------------------------------
75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

75: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

76: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

77: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

78: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
86: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

79: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
86: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
87: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

80: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
81: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
82: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
83: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
84: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
86: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
87: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
88:

Line 98: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

94: ---------------------------------------------------------------------------
95: -- GLOBAL VARIABLES
96: ---------------------------------------------------------------------------
97: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LDB_PVT';
98: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
99: ---------------------------------------------------------------------------
100: -- Procedures and Functions
101: ---------------------------------------------------------------------------
102:

Line 108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

104: PROCEDURE change_version;
105: PROCEDURE api_copy;
106: PROCEDURE insert_row(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_pphv_rec IN pphv_rec_type,

Line 116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

112: p_pphv_rec IN pphv_rec_type,
113: x_pphv_rec OUT NOCOPY pphv_rec_type);
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_pphv_tbl IN pphv_tbl_type,

Line 122: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_pphv_tbl IN pphv_tbl_type,
121: x_pphv_tbl OUT NOCOPY pphv_tbl_type,
122: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
123: PROCEDURE insert_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,

Line 125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

121: x_pphv_tbl OUT NOCOPY pphv_tbl_type,
122: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
123: PROCEDURE insert_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_pphv_tbl IN pphv_tbl_type,

Line 133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

129: p_pphv_tbl IN pphv_tbl_type,
130: x_pphv_tbl OUT NOCOPY pphv_tbl_type);
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_pphv_rec IN pphv_rec_type);

Line 140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_pphv_rec IN pphv_rec_type);
138: PROCEDURE lock_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_pphv_tbl IN pphv_tbl_type,

Line 145: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_pphv_tbl IN pphv_tbl_type,
145: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
146: PROCEDURE lock_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,

Line 148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

144: p_pphv_tbl IN pphv_tbl_type,
145: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
146: PROCEDURE lock_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_pphv_tbl IN pphv_tbl_type);

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_pphv_tbl IN pphv_tbl_type);
153: PROCEDURE update_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_pphv_rec IN pphv_rec_type,

Line 163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

159: p_pphv_rec IN pphv_rec_type,
160: x_pphv_rec OUT NOCOPY pphv_rec_type);
161: PROCEDURE update_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_pphv_tbl IN pphv_tbl_type,

Line 169: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_pphv_tbl IN pphv_tbl_type,
168: x_pphv_tbl OUT NOCOPY pphv_tbl_type,
169: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
170: PROCEDURE update_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,

Line 172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

168: x_pphv_tbl OUT NOCOPY pphv_tbl_type,
169: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
170: PROCEDURE update_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_pphv_tbl IN pphv_tbl_type,

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

176: p_pphv_tbl IN pphv_tbl_type,
177: x_pphv_tbl OUT NOCOPY pphv_tbl_type);
178: PROCEDURE delete_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_pphv_rec IN pphv_rec_type);

Line 187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_pphv_rec IN pphv_rec_type);
185: PROCEDURE delete_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_pphv_tbl IN pphv_tbl_type,

Line 192: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_pphv_tbl IN pphv_tbl_type,
192: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
193: PROCEDURE delete_row(
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,

Line 195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

191: p_pphv_tbl IN pphv_tbl_type,
192: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
193: PROCEDURE delete_row(
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_pphv_tbl IN pphv_tbl_type);

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_pphv_tbl IN pphv_tbl_type);
200: PROCEDURE validate_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_pphv_rec IN pphv_rec_type);

Line 209: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_pphv_rec IN pphv_rec_type);
207: PROCEDURE validate_row(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_pphv_tbl IN pphv_tbl_type,

Line 214: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_pphv_tbl IN pphv_tbl_type,
214: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
215: PROCEDURE validate_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

213: p_pphv_tbl IN pphv_tbl_type,
214: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
215: PROCEDURE validate_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_pphv_tbl IN pphv_tbl_type);