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_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_CNTRCT_FIN_EXTRACT_PVT

Line 1: PACKAGE BODY OKL_CNTRCT_FIN_EXTRACT_PVT AS

1: PACKAGE BODY OKL_CNTRCT_FIN_EXTRACT_PVT AS
2: /* $Header: OKLRCFEB.pls 120.2.12010000.17 2009/01/14 00:54:37 rbanerje noship $ */
3:
4: PROCEDURE write_to_log(
5: p_message IN VARCHAR2

Line 726: OKL_CNTRCT_FIN_EXTRACT_PVT.first_activation_date(khr.id) CONTRACT_DATE_DEAL_ACTIVATED,

722: khr.ISG_ID CONTRACT_SALES_REGION_ID,
723: khr.KHR_ID VENDOR_PROGRAM_ID,
724: khr.PDT_ID CONTRACT_FINANCIAL_PRODUCT_ID,
725: --khr.DATE_CONVERSION_EFFECTIVE CONTRACT_DATE_DEAL_ACTIVATED,
726: OKL_CNTRCT_FIN_EXTRACT_PVT.first_activation_date(khr.id) CONTRACT_DATE_DEAL_ACTIVATED,
727: khr.DATE_DEAL_TRANSFERRED CONTRACT_DATE_DEAL_TRANSFERD,
728: khr.TERM_DURATION CONTRACT_TERM_DURATION,
729: khr.ATTRIBUTE_CATEGORY CONTRACT_HDR_DFF_CATEGORY,
730: khr.ATTRIBUTE1 CONTRACT_HDR_DFF1,

Line 745: OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id) CONTRACT_ACCRUAL_STATUS,

741: khr.ATTRIBUTE12 CONTRACT_HDR_DFF12,
742: khr.ATTRIBUTE13 CONTRACT_HDR_DFF13,
743: khr.ATTRIBUTE14 CONTRACT_HDR_DFF14,
744: khr.ATTRIBUTE15 CONTRACT_HDR_DFF15,
745: OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id) CONTRACT_ACCRUAL_STATUS,
746: khr.GENERATE_ACCRUAL_OVERRIDE_YN CONTRACT_GEN_ACCRUAL_OVRIDE_YN,
747: khr.CREDIT_ACT_YN CONTRACT_CREDIT_ACT_YN,
748: khr.CONVERTED_ACCOUNT_YN CONTRACT_CONVERTED_ACCOUNT_YN,
749: khr.AFTER_TAX_YIELD CONTRACT_AFTER_TAX_YIELD,

Line 985: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,

981: --null CONTRACT_PAST_DUE_AMT_61_90,
982: --null CONTRACT_PAST_DUE_AMT_91_120,
983: -- null CONTRACT_PAST_DUE_AMT_120_Plus,
984:
985: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
986: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
987: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
988: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
989: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,

Line 986: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,

982: --null CONTRACT_PAST_DUE_AMT_91_120,
983: -- null CONTRACT_PAST_DUE_AMT_120_Plus,
984:
985: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
986: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
987: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
988: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
989: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
990:

Line 987: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,

983: -- null CONTRACT_PAST_DUE_AMT_120_Plus,
984:
985: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
986: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
987: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
988: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
989: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
990:
991:

Line 988: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,

984:
985: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
986: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
987: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
988: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
989: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
990:
991:
992: null CONTRACT_TOT_PAST_DUE_AMT,

Line 989: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,

985: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
986: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
987: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
988: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
989: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
990:
991:
992: null CONTRACT_TOT_PAST_DUE_AMT,
993: -- null CONTRACT_TOT_BILLED_RECEIVABLE,

Line 1191: AND OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id) like nvl(P_GEN_ACCRUAL, OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id))

1187: -- P_SALES_CHANNEL -> value set QP_SALES_CHANNEL_CODE -> returns oe_lookups.lookup_code
1188: AND nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX') like nvl(P_SALES_CHANNEL, nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX'))
1189:
1190: -- AND CONTRACT_ACCRUAL_STATUS like nvl(P_GEN_ACCRUAL, CONTRACT_ACCRUAL_STATUS)
1191: AND OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id) like nvl(P_GEN_ACCRUAL, OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id))
1192:
1193: AND ( (P_TERMINATE_DATE_FROM IS NULL) OR (chr.DATE_TERMINATED IS NOT NULL AND chr.DATE_TERMINATED >= P_TERMINATE_DATE_FROM) )
1194: AND ( (P_TERMINATE_DATE_TO IS NULL) OR (chr.DATE_TERMINATED IS NOT NULL AND chr.DATE_TERMINATED <= P_TERMINATE_DATE_TO) )
1195:

Line 1759: OKL_CNTRCT_FIN_EXTRACT_PVT.first_activation_date(khr.id) CONTRACT_DATE_DEAL_ACTIVATED,

1755: khr.ISG_ID CONTRACT_SALES_REGION_ID,
1756: khr.KHR_ID VENDOR_PROGRAM_ID,
1757: khr.PDT_ID CONTRACT_FINANCIAL_PRODUCT_ID,
1758: --khr.DATE_CONVERSION_EFFECTIVE CONTRACT_DATE_DEAL_ACTIVATED,
1759: OKL_CNTRCT_FIN_EXTRACT_PVT.first_activation_date(khr.id) CONTRACT_DATE_DEAL_ACTIVATED,
1760: khr.DATE_DEAL_TRANSFERRED CONTRACT_DATE_DEAL_TRANSFERD,
1761: khr.TERM_DURATION CONTRACT_TERM_DURATION,
1762: khr.ATTRIBUTE_CATEGORY CONTRACT_HDR_DFF_CATEGORY,
1763: khr.ATTRIBUTE1 CONTRACT_HDR_DFF1,

Line 1778: OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id) CONTRACT_ACCRUAL_STATUS,

1774: khr.ATTRIBUTE12 CONTRACT_HDR_DFF12,
1775: khr.ATTRIBUTE13 CONTRACT_HDR_DFF13,
1776: khr.ATTRIBUTE14 CONTRACT_HDR_DFF14,
1777: khr.ATTRIBUTE15 CONTRACT_HDR_DFF15,
1778: OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id) CONTRACT_ACCRUAL_STATUS,
1779: khr.GENERATE_ACCRUAL_OVERRIDE_YN CONTRACT_GEN_ACCRUAL_OVRIDE_YN,
1780: khr.CREDIT_ACT_YN CONTRACT_CREDIT_ACT_YN,
1781: khr.CONVERTED_ACCOUNT_YN CONTRACT_CONVERTED_ACCOUNT_YN,
1782: khr.AFTER_TAX_YIELD CONTRACT_AFTER_TAX_YIELD,

Line 2017: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,

2013: null CONTRACT_PAST_DUE_AMT_61_90,
2014: null CONTRACT_PAST_DUE_AMT_91_120,
2015: null CONTRACT_PAST_DUE_AMT_120_Plus,
2016:
2017: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
2018: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
2019: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
2020: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
2021: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,

Line 2018: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,

2014: null CONTRACT_PAST_DUE_AMT_91_120,
2015: null CONTRACT_PAST_DUE_AMT_120_Plus,
2016:
2017: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
2018: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
2019: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
2020: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
2021: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
2022:

Line 2019: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,

2015: null CONTRACT_PAST_DUE_AMT_120_Plus,
2016:
2017: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
2018: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
2019: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
2020: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
2021: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
2022:
2023:

Line 2020: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,

2016:
2017: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
2018: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
2019: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
2020: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
2021: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
2022:
2023:
2024: null CONTRACT_TOT_PAST_DUE_AMT,

Line 2021: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,

2017: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
2018: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
2019: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
2020: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
2021: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
2022:
2023:
2024: null CONTRACT_TOT_PAST_DUE_AMT,
2025: -- null CONTRACT_TOT_BILLED_RECEIVABLE,

Line 2223: AND OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id) like nvl(P_GEN_ACCRUAL, OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id))

2219: -- P_SALES_CHANNEL -> value set QP_SALES_CHANNEL_CODE -> returns oe_lookups.lookup_code
2220: AND nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX') like nvl(P_SALES_CHANNEL, nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX'))
2221:
2222: -- AND CONTRACT_ACCRUAL_STATUS like nvl(P_GEN_ACCRUAL, CONTRACT_ACCRUAL_STATUS)
2223: AND OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id) like nvl(P_GEN_ACCRUAL, OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id))
2224:
2225: AND ( (P_TERMINATE_DATE_FROM IS NULL) OR (chr.DATE_TERMINATED IS NOT NULL AND chr.DATE_TERMINATED >= P_TERMINATE_DATE_FROM) )
2226: AND ( (P_TERMINATE_DATE_TO IS NULL) OR (chr.DATE_TERMINATED IS NOT NULL AND chr.DATE_TERMINATED <= P_TERMINATE_DATE_TO) )
2227:

Line 2805: END okl_cntrct_fin_extract_pvt;

2801: RETURN TRUE;
2802:
2803: END delete_report_data;
2804:
2805: END okl_cntrct_fin_extract_pvt;