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.19 2010/02/16 04:49:37 rpillay noship $ */
3:
4: PROCEDURE write_to_log(
5: p_message IN VARCHAR2

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

736: khr.ISG_ID CONTRACT_SALES_REGION_ID,
737: khr.KHR_ID VENDOR_PROGRAM_ID,
738: khr.PDT_ID CONTRACT_FINANCIAL_PRODUCT_ID,
739: --khr.DATE_CONVERSION_EFFECTIVE CONTRACT_DATE_DEAL_ACTIVATED,
740: OKL_CNTRCT_FIN_EXTRACT_PVT.first_activation_date(khr.id) CONTRACT_DATE_DEAL_ACTIVATED,
741: khr.DATE_DEAL_TRANSFERRED CONTRACT_DATE_DEAL_TRANSFERD,
742: khr.TERM_DURATION CONTRACT_TERM_DURATION,
743: khr.ATTRIBUTE_CATEGORY CONTRACT_HDR_DFF_CATEGORY,
744: khr.ATTRIBUTE1 CONTRACT_HDR_DFF1,

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

755: khr.ATTRIBUTE12 CONTRACT_HDR_DFF12,
756: khr.ATTRIBUTE13 CONTRACT_HDR_DFF13,
757: khr.ATTRIBUTE14 CONTRACT_HDR_DFF14,
758: khr.ATTRIBUTE15 CONTRACT_HDR_DFF15,
759: OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id) CONTRACT_ACCRUAL_STATUS,
760: khr.GENERATE_ACCRUAL_OVERRIDE_YN CONTRACT_GEN_ACCRUAL_OVRIDE_YN,
761: khr.CREDIT_ACT_YN CONTRACT_CREDIT_ACT_YN,
762: khr.CONVERTED_ACCOUNT_YN CONTRACT_CONVERTED_ACCOUNT_YN,
763: khr.AFTER_TAX_YIELD CONTRACT_AFTER_TAX_YIELD,

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

995: --null CONTRACT_PAST_DUE_AMT_61_90,
996: --null CONTRACT_PAST_DUE_AMT_91_120,
997: -- null CONTRACT_PAST_DUE_AMT_120_Plus,
998:
999: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
1000: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
1001: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
1002: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
1003: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,

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

996: --null CONTRACT_PAST_DUE_AMT_91_120,
997: -- null CONTRACT_PAST_DUE_AMT_120_Plus,
998:
999: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
1000: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
1001: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
1002: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
1003: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
1004:

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

997: -- null CONTRACT_PAST_DUE_AMT_120_Plus,
998:
999: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
1000: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
1001: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
1002: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
1003: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
1004:
1005:

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

998:
999: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
1000: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
1001: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
1002: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
1003: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
1004:
1005:
1006: null CONTRACT_TOT_PAST_DUE_AMT,

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

999: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
1000: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
1001: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
1002: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
1003: NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
1004:
1005:
1006: null CONTRACT_TOT_PAST_DUE_AMT,
1007: -- null CONTRACT_TOT_BILLED_RECEIVABLE,

Line 1205: 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))

1201: -- P_SALES_CHANNEL -> value set QP_SALES_CHANNEL_CODE -> returns oe_lookups.lookup_code
1202: AND nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX') like nvl(P_SALES_CHANNEL, nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX'))
1203:
1204: -- AND CONTRACT_ACCRUAL_STATUS like nvl(P_GEN_ACCRUAL, CONTRACT_ACCRUAL_STATUS)
1205: 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))
1206:
1207: AND ( (P_TERMINATE_DATE_FROM IS NULL) OR (chr.DATE_TERMINATED IS NOT NULL AND chr.DATE_TERMINATED >= P_TERMINATE_DATE_FROM) )
1208: AND ( (P_TERMINATE_DATE_TO IS NULL) OR (chr.DATE_TERMINATED IS NOT NULL AND chr.DATE_TERMINATED <= P_TERMINATE_DATE_TO) )
1209:

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

1769: khr.ISG_ID CONTRACT_SALES_REGION_ID,
1770: khr.KHR_ID VENDOR_PROGRAM_ID,
1771: khr.PDT_ID CONTRACT_FINANCIAL_PRODUCT_ID,
1772: --khr.DATE_CONVERSION_EFFECTIVE CONTRACT_DATE_DEAL_ACTIVATED,
1773: OKL_CNTRCT_FIN_EXTRACT_PVT.first_activation_date(khr.id) CONTRACT_DATE_DEAL_ACTIVATED,
1774: khr.DATE_DEAL_TRANSFERRED CONTRACT_DATE_DEAL_TRANSFERD,
1775: khr.TERM_DURATION CONTRACT_TERM_DURATION,
1776: khr.ATTRIBUTE_CATEGORY CONTRACT_HDR_DFF_CATEGORY,
1777: khr.ATTRIBUTE1 CONTRACT_HDR_DFF1,

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

1788: khr.ATTRIBUTE12 CONTRACT_HDR_DFF12,
1789: khr.ATTRIBUTE13 CONTRACT_HDR_DFF13,
1790: khr.ATTRIBUTE14 CONTRACT_HDR_DFF14,
1791: khr.ATTRIBUTE15 CONTRACT_HDR_DFF15,
1792: OKL_CNTRCT_FIN_EXTRACT_PVT.accrual_status_yn(khr.id) CONTRACT_ACCRUAL_STATUS,
1793: khr.GENERATE_ACCRUAL_OVERRIDE_YN CONTRACT_GEN_ACCRUAL_OVRIDE_YN,
1794: khr.CREDIT_ACT_YN CONTRACT_CREDIT_ACT_YN,
1795: khr.CONVERTED_ACCOUNT_YN CONTRACT_CONVERTED_ACCOUNT_YN,
1796: khr.AFTER_TAX_YIELD CONTRACT_AFTER_TAX_YIELD,

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

2027: null CONTRACT_PAST_DUE_AMT_61_90,
2028: null CONTRACT_PAST_DUE_AMT_91_120,
2029: null CONTRACT_PAST_DUE_AMT_120_Plus,
2030:
2031: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
2032: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
2033: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
2034: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
2035: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,

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

2028: null CONTRACT_PAST_DUE_AMT_91_120,
2029: null CONTRACT_PAST_DUE_AMT_120_Plus,
2030:
2031: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
2032: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
2033: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
2034: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
2035: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
2036:

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

2029: null CONTRACT_PAST_DUE_AMT_120_Plus,
2030:
2031: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
2032: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
2033: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
2034: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
2035: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
2036:
2037:

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

2030:
2031: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
2032: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
2033: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
2034: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
2035: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
2036:
2037:
2038: null CONTRACT_TOT_PAST_DUE_AMT,

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

2031: -- NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,1,30),0) CONTRACT_PAST_DUE_AMT_1_30,
2032: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,31,60),0) CONTRACT_PAST_DUE_AMT_31_60,
2033: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,61,90),0) CONTRACT_PAST_DUE_AMT_61_90,
2034: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,91,120),0) CONTRACT_PAST_DUE_AMT_91_120,
2035: --NVL(OKL_CNTRCT_FIN_EXTRACT_PVT.AMOUNT_DUE_REMAINING (chr.CONTRACT_NUMBER,120,12000),0) CONTRACT_PAST_DUE_AMT_120_Plus,
2036:
2037:
2038: null CONTRACT_TOT_PAST_DUE_AMT,
2039: -- null CONTRACT_TOT_BILLED_RECEIVABLE,

Line 2237: 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))

2233: -- P_SALES_CHANNEL -> value set QP_SALES_CHANNEL_CODE -> returns oe_lookups.lookup_code
2234: AND nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX') like nvl(P_SALES_CHANNEL, nvl(cust_accounts.SALES_CHANNEL_CODE,'XXX'))
2235:
2236: -- AND CONTRACT_ACCRUAL_STATUS like nvl(P_GEN_ACCRUAL, CONTRACT_ACCRUAL_STATUS)
2237: 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))
2238:
2239: AND ( (P_TERMINATE_DATE_FROM IS NULL) OR (chr.DATE_TERMINATED IS NOT NULL AND chr.DATE_TERMINATED >= P_TERMINATE_DATE_FROM) )
2240: AND ( (P_TERMINATE_DATE_TO IS NULL) OR (chr.DATE_TERMINATED IS NOT NULL AND chr.DATE_TERMINATED <= P_TERMINATE_DATE_TO) )
2241:

Line 2819: END okl_cntrct_fin_extract_pvt;

2815: RETURN TRUE;
2816:
2817: END delete_report_data;
2818:
2819: END okl_cntrct_fin_extract_pvt;