15:
16: TYPE accrual_rec_type IS RECORD (
17: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
18: sty_id OKL_TXL_CNTRCT_LNS.sty_id%TYPE,
19: set_of_books_id OKL_TRX_CONTRACTS.SET_OF_BOOKS_ID%TYPE,
20: reverse_date_to DATE,
21: accrual_date DATE,
22: trx_date DATE,
23: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
20: reverse_date_to DATE,
21: accrual_date DATE,
22: trx_date DATE,
23: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
24: rule_result OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
25: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
26: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
27: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
28: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
21: accrual_date DATE,
22: trx_date DATE,
23: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
24: rule_result OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
25: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
26: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
27: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
28: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
29: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
22: trx_date DATE,
23: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
24: rule_result OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
25: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
26: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
27: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
28: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
29: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
30: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
23: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
24: rule_result OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
25: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
26: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
27: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
28: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
29: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
30: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
31: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
24: rule_result OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
25: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
26: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
27: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
28: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
29: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
30: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
31: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
32: product_id OKL_PRODUCTS_V.ID%TYPE,
25: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
26: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
27: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
28: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
29: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
30: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
31: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
32: product_id OKL_PRODUCTS_V.ID%TYPE,
33: trx_type_id OKL_TRX_TYPES_V.ID%TYPE,
26: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
27: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
28: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
29: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
30: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
31: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
32: product_id OKL_PRODUCTS_V.ID%TYPE,
33: trx_type_id OKL_TRX_TYPES_V.ID%TYPE,
34: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE,
27: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
28: currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
29: currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
30: currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
31: currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
32: product_id OKL_PRODUCTS_V.ID%TYPE,
33: trx_type_id OKL_TRX_TYPES_V.ID%TYPE,
34: advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE,
35: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE,
35: factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE,
36: post_to_gl VARCHAR2(1),
37: gl_reversal_flag VARCHAR2(1),
38: memo_yn VARCHAR2(1),
39: accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE,
40: accrual_rule_yn VARCHAR2(1),
41: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
42: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
43: -- Bug 5707866 Added by dpsingh
37: gl_reversal_flag VARCHAR2(1),
38: memo_yn VARCHAR2(1),
39: accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE,
40: accrual_rule_yn VARCHAR2(1),
41: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
42: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
43: -- Bug 5707866 Added by dpsingh
44: accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE,
45: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE,
38: memo_yn VARCHAR2(1),
39: accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE,
40: accrual_rule_yn VARCHAR2(1),
41: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
42: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
43: -- Bug 5707866 Added by dpsingh
44: accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE,
45: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE,
46: primary_rep_trx_id OKL_TRX_CONTRACTS.PRIMARY_REP_TRX_ID%TYPE);
40: accrual_rule_yn VARCHAR2(1),
41: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
42: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
43: -- Bug 5707866 Added by dpsingh
44: accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE,
45: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE,
46: primary_rep_trx_id OKL_TRX_CONTRACTS.PRIMARY_REP_TRX_ID%TYPE);
47: -- Added new field accelerate_from_date by akrangan for bug 5526955
48: TYPE acceleration_rec_type IS RECORD (
41: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
42: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
43: -- Bug 5707866 Added by dpsingh
44: accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE,
45: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE,
46: primary_rep_trx_id OKL_TRX_CONTRACTS.PRIMARY_REP_TRX_ID%TYPE);
47: -- Added new field accelerate_from_date by akrangan for bug 5526955
48: TYPE acceleration_rec_type IS RECORD (
49: khr_id OKL_K_HEADERS_FULL_V.id%TYPE,
42: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
43: -- Bug 5707866 Added by dpsingh
44: accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE,
45: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE,
46: primary_rep_trx_id OKL_TRX_CONTRACTS.PRIMARY_REP_TRX_ID%TYPE);
47: -- Added new field accelerate_from_date by akrangan for bug 5526955
48: TYPE acceleration_rec_type IS RECORD (
49: khr_id OKL_K_HEADERS_FULL_V.id%TYPE,
50: kle_id OKL_K_LINES_FULL_V.id%TYPE,
50: kle_id OKL_K_LINES_FULL_V.id%TYPE,
51: sty_id OKL_STRM_TYPE_V.id%TYPE,
52: acceleration_date DATE,
53: accelerate_till_date DATE,
54: description OKL_TRX_CONTRACTS.description%TYPE,
55: accrual_rule_yn OKL_TXL_CNTRCT_LNS.accrual_rule_yn%TYPE,
56: accelerate_from_date DATE DEFAULT NULL,
57: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE DEFAULT NULL); --MGAAP 7263041
58:
53: accelerate_till_date DATE,
54: description OKL_TRX_CONTRACTS.description%TYPE,
55: accrual_rule_yn OKL_TXL_CNTRCT_LNS.accrual_rule_yn%TYPE,
56: accelerate_from_date DATE DEFAULT NULL,
57: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE DEFAULT NULL); --MGAAP 7263041
58:
59: TYPE adjust_accrual_rec_type IS RECORD(
60: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
61: accrual_date OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE,
57: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE DEFAULT NULL); --MGAAP 7263041
58:
59: TYPE adjust_accrual_rec_type IS RECORD(
60: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
61: accrual_date OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE,
62: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
63: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
64: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
65: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE);
58:
59: TYPE adjust_accrual_rec_type IS RECORD(
60: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
61: accrual_date OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE,
62: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
63: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
64: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
65: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE);
66:
59: TYPE adjust_accrual_rec_type IS RECORD(
60: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
61: accrual_date OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE,
62: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
63: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
64: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
65: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE);
66:
67: TYPE stream_tbl_type IS TABLE OF stream_rec_type
60: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
61: accrual_date OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE,
62: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
63: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
64: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
65: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE);
66:
67: TYPE stream_tbl_type IS TABLE OF stream_rec_type
68: INDEX BY BINARY_INTEGER;
61: accrual_date OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE,
62: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
63: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
64: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
65: trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE);
66:
67: TYPE stream_tbl_type IS TABLE OF stream_rec_type
68: INDEX BY BINARY_INTEGER;
69:
157: p_catchup_rec IN accrual_rec_type,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
162: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
163: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'); --MGAAP 7263041
164:
165: PROCEDURE REVERSE_ACCRUALS (
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
162: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
163: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'); --MGAAP 7263041
164:
165: PROCEDURE REVERSE_ACCRUALS (
166: p_api_version IN NUMBER,
168: p_reverse_rec IN accrual_rec_type,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
173: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
174: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'); --MGAAP 7263041
175:
176: PROCEDURE REVERSE_ACCRUALS (
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
173: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
174: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'); --MGAAP 7263041
175:
176: PROCEDURE REVERSE_ACCRUALS (
177: p_api_version IN NUMBER,
203: p_reverse_rec IN accrual_rec_type,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
208: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
209: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
210: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
211: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
208: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
209: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
210: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
211: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
212: );
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
208: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
209: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
210: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
211: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
212: );
213:
206: x_msg_data OUT NOCOPY VARCHAR2,
207: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
208: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
209: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
210: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
211: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
212: );
213:
214: PROCEDURE ACCELERATE_ACCRUALS (
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_acceleration_rec IN acceleration_rec_type,
221: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY', --MGAAP 7263041
222: x_trx_number OUT NOCOPY OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE); --MGAAP 7263041
223:
224: PROCEDURE ADJUST_ACCRUALS (
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2,