69: TYPE fee_types_tbl_type is table of fee_types_rec_type INDEX BY BINARY_INTEGER;
70:
71: --Murthy Passthru changes Begin.
72: TYPE passthru_dtl_rec_type IS RECORD (
73: b_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
74: ,b_cle_id NUMBER := OKC_API.G_MISS_NUM
75: ,b_ppl_id NUMBER := OKC_API.G_MISS_NUM
76: ,b_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
77: ,b_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
70:
71: --Murthy Passthru changes Begin.
72: TYPE passthru_dtl_rec_type IS RECORD (
73: b_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
74: ,b_cle_id NUMBER := OKC_API.G_MISS_NUM
75: ,b_ppl_id NUMBER := OKC_API.G_MISS_NUM
76: ,b_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
77: ,b_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
78: ,b_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
71: --Murthy Passthru changes Begin.
72: TYPE passthru_dtl_rec_type IS RECORD (
73: b_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
74: ,b_cle_id NUMBER := OKC_API.G_MISS_NUM
75: ,b_ppl_id NUMBER := OKC_API.G_MISS_NUM
76: ,b_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
77: ,b_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
78: ,b_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,b_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
72: TYPE passthru_dtl_rec_type IS RECORD (
73: b_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
74: ,b_cle_id NUMBER := OKC_API.G_MISS_NUM
75: ,b_ppl_id NUMBER := OKC_API.G_MISS_NUM
76: ,b_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
77: ,b_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
78: ,b_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,b_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
80: ,b_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
73: b_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
74: ,b_cle_id NUMBER := OKC_API.G_MISS_NUM
75: ,b_ppl_id NUMBER := OKC_API.G_MISS_NUM
76: ,b_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
77: ,b_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
78: ,b_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,b_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
80: ,b_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
81: ,b_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
74: ,b_cle_id NUMBER := OKC_API.G_MISS_NUM
75: ,b_ppl_id NUMBER := OKC_API.G_MISS_NUM
76: ,b_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
77: ,b_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
78: ,b_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,b_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
80: ,b_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
81: ,b_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
82: ,b_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
75: ,b_ppl_id NUMBER := OKC_API.G_MISS_NUM
76: ,b_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
77: ,b_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
78: ,b_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,b_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
80: ,b_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
81: ,b_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
82: ,b_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
83: ,b_payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
76: ,b_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
77: ,b_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
78: ,b_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,b_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
80: ,b_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
81: ,b_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
82: ,b_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
83: ,b_payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
84: ,b_cpl_id NUMBER := OKL_API.G_MISS_NUM
77: ,b_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
78: ,b_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,b_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
80: ,b_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
81: ,b_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
82: ,b_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
83: ,b_payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
84: ,b_cpl_id NUMBER := OKL_API.G_MISS_NUM
85: ,b_vendor_id NUMBER := OKL_API.G_MISS_NUM
78: ,b_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,b_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
80: ,b_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
81: ,b_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
82: ,b_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
83: ,b_payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
84: ,b_cpl_id NUMBER := OKL_API.G_MISS_NUM
85: ,b_vendor_id NUMBER := OKL_API.G_MISS_NUM
86: ,b_pay_site_id NUMBER := OKL_API.G_MISS_NUM
98: ,b_processing_fee_basis OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_BASIS%TYPE := OKL_API.G_MISS_CHAR
99: ,b_processing_fee_fixed_amount OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
100: ,b_processing_fee_percent OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_PERCENT%TYPE := OKL_API.G_MISS_NUM
101: --,b_processing_fee_formula OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FORMULA%TYPE := OKL_API.G_MISS_CHAR
102: ,e_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
103: ,e_cle_id NUMBER := OKC_API.G_MISS_NUM
104: ,e_ppl_id NUMBER := OKC_API.G_MISS_NUM
105: ,e_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
106: ,e_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
99: ,b_processing_fee_fixed_amount OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
100: ,b_processing_fee_percent OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_PERCENT%TYPE := OKL_API.G_MISS_NUM
101: --,b_processing_fee_formula OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FORMULA%TYPE := OKL_API.G_MISS_CHAR
102: ,e_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
103: ,e_cle_id NUMBER := OKC_API.G_MISS_NUM
104: ,e_ppl_id NUMBER := OKC_API.G_MISS_NUM
105: ,e_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
106: ,e_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
107: ,e_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
100: ,b_processing_fee_percent OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_PERCENT%TYPE := OKL_API.G_MISS_NUM
101: --,b_processing_fee_formula OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FORMULA%TYPE := OKL_API.G_MISS_CHAR
102: ,e_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
103: ,e_cle_id NUMBER := OKC_API.G_MISS_NUM
104: ,e_ppl_id NUMBER := OKC_API.G_MISS_NUM
105: ,e_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
106: ,e_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
107: ,e_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
108: ,e_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
101: --,b_processing_fee_formula OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FORMULA%TYPE := OKL_API.G_MISS_CHAR
102: ,e_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
103: ,e_cle_id NUMBER := OKC_API.G_MISS_NUM
104: ,e_ppl_id NUMBER := OKC_API.G_MISS_NUM
105: ,e_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
106: ,e_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
107: ,e_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
108: ,e_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
109: ,e_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
102: ,e_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
103: ,e_cle_id NUMBER := OKC_API.G_MISS_NUM
104: ,e_ppl_id NUMBER := OKC_API.G_MISS_NUM
105: ,e_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
106: ,e_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
107: ,e_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
108: ,e_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
109: ,e_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
110: ,e_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
103: ,e_cle_id NUMBER := OKC_API.G_MISS_NUM
104: ,e_ppl_id NUMBER := OKC_API.G_MISS_NUM
105: ,e_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
106: ,e_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
107: ,e_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
108: ,e_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
109: ,e_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
110: ,e_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
111: ,e_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
104: ,e_ppl_id NUMBER := OKC_API.G_MISS_NUM
105: ,e_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
106: ,e_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
107: ,e_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
108: ,e_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
109: ,e_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
110: ,e_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
111: ,e_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
112: ,e_payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
105: ,e_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
106: ,e_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
107: ,e_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
108: ,e_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
109: ,e_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
110: ,e_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
111: ,e_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
112: ,e_payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
113: ,e_cpl_id NUMBER := OKL_API.G_MISS_NUM
106: ,e_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
107: ,e_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
108: ,e_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
109: ,e_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
110: ,e_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
111: ,e_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
112: ,e_payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
113: ,e_cpl_id NUMBER := OKL_API.G_MISS_NUM
114: ,e_vendor_id NUMBER := OKL_API.G_MISS_NUM
107: ,e_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
108: ,e_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
109: ,e_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
110: ,e_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
111: ,e_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
112: ,e_payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
113: ,e_cpl_id NUMBER := OKL_API.G_MISS_NUM
114: ,e_vendor_id NUMBER := OKL_API.G_MISS_NUM
115: ,e_pay_site_id NUMBER := OKL_API.G_MISS_NUM
131: );
132: TYPE passthru_dtl_tbl_type IS TABLE OF passthru_dtl_rec_type INDEX BY BINARY_INTEGER;
133:
134: TYPE passthru_rec_type IS RECORD (
135: base_id NUMBER := OKC_API.G_MISS_NUM
136: ,evergreen_id NUMBER := OKC_API.G_MISS_NUM
137: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
138: ,cle_id NUMBER := OKC_API.G_MISS_NUM
139: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
132: TYPE passthru_dtl_tbl_type IS TABLE OF passthru_dtl_rec_type INDEX BY BINARY_INTEGER;
133:
134: TYPE passthru_rec_type IS RECORD (
135: base_id NUMBER := OKC_API.G_MISS_NUM
136: ,evergreen_id NUMBER := OKC_API.G_MISS_NUM
137: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
138: ,cle_id NUMBER := OKC_API.G_MISS_NUM
139: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
140: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
133:
134: TYPE passthru_rec_type IS RECORD (
135: base_id NUMBER := OKC_API.G_MISS_NUM
136: ,evergreen_id NUMBER := OKC_API.G_MISS_NUM
137: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
138: ,cle_id NUMBER := OKC_API.G_MISS_NUM
139: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
140: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
141: ,evergreen_eligible_yn VARCHAR2(1) := OKC_API.G_MISS_CHAR
134: TYPE passthru_rec_type IS RECORD (
135: base_id NUMBER := OKC_API.G_MISS_NUM
136: ,evergreen_id NUMBER := OKC_API.G_MISS_NUM
137: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
138: ,cle_id NUMBER := OKC_API.G_MISS_NUM
139: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
140: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
141: ,evergreen_eligible_yn VARCHAR2(1) := OKC_API.G_MISS_CHAR
142: ,evergreen_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
135: base_id NUMBER := OKC_API.G_MISS_NUM
136: ,evergreen_id NUMBER := OKC_API.G_MISS_NUM
137: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
138: ,cle_id NUMBER := OKC_API.G_MISS_NUM
139: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
140: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
141: ,evergreen_eligible_yn VARCHAR2(1) := OKC_API.G_MISS_CHAR
142: ,evergreen_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
143: ,evergreen_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
136: ,evergreen_id NUMBER := OKC_API.G_MISS_NUM
137: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
138: ,cle_id NUMBER := OKC_API.G_MISS_NUM
139: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
140: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
141: ,evergreen_eligible_yn VARCHAR2(1) := OKC_API.G_MISS_CHAR
142: ,evergreen_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
143: ,evergreen_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
144: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
137: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
138: ,cle_id NUMBER := OKC_API.G_MISS_NUM
139: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
140: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
141: ,evergreen_eligible_yn VARCHAR2(1) := OKC_API.G_MISS_CHAR
142: ,evergreen_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
143: ,evergreen_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
144: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
145: ,base_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
138: ,cle_id NUMBER := OKC_API.G_MISS_NUM
139: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
140: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
141: ,evergreen_eligible_yn VARCHAR2(1) := OKC_API.G_MISS_CHAR
142: ,evergreen_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
143: ,evergreen_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
144: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
145: ,base_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
146: ,evg_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
139: ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
140: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
141: ,evergreen_eligible_yn VARCHAR2(1) := OKC_API.G_MISS_CHAR
142: ,evergreen_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
143: ,evergreen_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
144: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
145: ,base_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
146: ,evg_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
147: --,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
140: ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
141: ,evergreen_eligible_yn VARCHAR2(1) := OKC_API.G_MISS_CHAR
142: ,evergreen_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
143: ,evergreen_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
144: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
145: ,base_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
146: ,evg_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
147: --,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
148: );
141: ,evergreen_eligible_yn VARCHAR2(1) := OKC_API.G_MISS_CHAR
142: ,evergreen_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
143: ,evergreen_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
144: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
145: ,base_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
146: ,evg_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
147: --,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
148: );
149: TYPE passthru_tbl_type IS TABLE OF passthru_rec_type INDEX BY BINARY_INTEGER;
142: ,evergreen_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
143: ,evergreen_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
144: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
145: ,base_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
146: ,evg_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
147: --,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
148: );
149: TYPE passthru_tbl_type IS TABLE OF passthru_rec_type INDEX BY BINARY_INTEGER;
150:
143: ,evergreen_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
144: ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
145: ,base_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
146: ,evg_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
147: --,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
148: );
149: TYPE passthru_tbl_type IS TABLE OF passthru_rec_type INDEX BY BINARY_INTEGER;
150:
151: TYPE party_rec_type is record (
179:
180:
181: PROCEDURE create_payment_dtls(
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_passthru_dtl_rec IN passthru_dtl_rec_type,
188: x_passthru_dtl_rec OUT NOCOPY passthru_dtl_rec_type);
189:
190: PROCEDURE create_payment_hdrs(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_passthru_rec IN passthru_rec_type,
197: x_passthru_rec OUT NOCOPY passthru_rec_type);
198:
199: PROCEDURE delete_payment_hdrs(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_passthru_rec IN passthru_rec_type);
206: --Murthy Passthru changes end.
207:
208: PROCEDURE create_fee_type(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_fee_types_rec IN fee_types_rec_type,
216: );
217:
218: PROCEDURE validate_fee_type(
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_fee_types_rec IN fee_types_rec_type,
226: );
227:
228: PROCEDURE update_fee_type(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
234: p_fee_types_rec IN fee_types_rec_type,
236: );
237:
238: PROCEDURE delete_fee_type(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
244: p_fee_types_rec IN fee_types_rec_type
245: );
246:
247: PROCEDURE create_strmtp_rul(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_chr_id IN NUMBER,
255: );
256:
257: PROCEDURE update_strmtp_rul(
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_msg_data OUT NOCOPY VARCHAR2,
263: p_chr_id IN NUMBER,
267: );
268:
269: PROCEDURE process_strmtp_rul(
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_chr_id IN NUMBER,
285: -- Also called by Re-book Contract API.
286: --------------------------------------------------
287: PROCEDURE validate_rollover_feeLine(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
302: -- Also called by Re-book Contract API.
303: --------------------------------------------------
304: PROCEDURE rollover_fee(
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,
309: x_msg_data OUT NOCOPY VARCHAR2,
310: p_chr_id IN NUMBER,
320: -- Also called by Re-book Contract API.
321: --------------------------------------------------
322: PROCEDURE rollover_fee(
323: p_api_version IN NUMBER,
324: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,
328: p_chr_id IN NUMBER,
343: -- Guru Added this for RVI
344:
345: PROCEDURE process_rvi_stream(
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
348: x_return_status OUT NOCOPY VARCHAR2,
349: x_msg_count OUT NOCOPY NUMBER,
350: x_msg_data OUT NOCOPY VARCHAR2,
351: p_check_box_value IN VARCHAR2,
353: x_fee_types_rec OUT NOCOPY fee_types_rec_type);
354:
355: PROCEDURE delete_passthru_party(
356: p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
358: x_return_status OUT NOCOPY VARCHAR2,
359: x_msg_count OUT NOCOPY NUMBER,
360: x_msg_data OUT NOCOPY VARCHAR2,
361: p_cpl_id IN NUMBER
362: );
363:
364: PROCEDURE create_party(
365: p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
367: x_return_status OUT NOCOPY VARCHAR2,
368: x_msg_count OUT NOCOPY NUMBER,
369: x_msg_data OUT NOCOPY VARCHAR2,
370: p_kpl_rec IN party_rec_type,
372: );
373:
374: PROCEDURE update_party(
375: p_api_version IN NUMBER,
376: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
377: x_return_status OUT NOCOPY VARCHAR2,
378: x_msg_count OUT NOCOPY NUMBER,
379: x_msg_data OUT NOCOPY VARCHAR2,
380: p_kpl_rec IN party_rec_type,