DBA Data[Home] [Help]

APPS.OKL_LDB_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 6: -- OKL_PARTY_PAYMENT_HDR_V Record Spec

2: /* $Header: OKLSLDBS.pls 120.0 2005/11/30 17:18:03 stmathew noship $ */
3: ---------------------------------------------------------------------------
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

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 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 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 28: -- OKL_PARTY_PAYMENT_HDR Record Spec

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
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

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 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 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 50: -- OKL_PARTY_PAYMENT_HDR_H Record Spec

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
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

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 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 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;