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_AM_QUOTES_WF dependencies on OKL_AM_UTIL_PVT

Line 377: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',TRQ.qtp_code,'N') quote_type,

373: SELECT TO_CHAR(sysdate, 'MM-DD-YYYY') system_date,
374: TRQ.quote_number quote_number,
375: TRQ.date_effective_to effective_to,
376: QTE.amount quote_total,
377: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',TRQ.qtp_code,'N') quote_type,
378: TRQ.creation_date quote_creation_date,
379: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',TRQ.qrs_code,'N') quote_reason,
380: OKL_AM_UTIL_PVT.get_chr_currency(TRQ.khr_id) currency,
381: TRQ.comments comments,

Line 379: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',TRQ.qrs_code,'N') quote_reason,

375: TRQ.date_effective_to effective_to,
376: QTE.amount quote_total,
377: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',TRQ.qtp_code,'N') quote_type,
378: TRQ.creation_date quote_creation_date,
379: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',TRQ.qrs_code,'N') quote_reason,
380: OKL_AM_UTIL_PVT.get_chr_currency(TRQ.khr_id) currency,
381: TRQ.comments comments,
382: KHR.contract_number contract_number,
383: TRQ.last_updated_by last_updated_by

Line 380: OKL_AM_UTIL_PVT.get_chr_currency(TRQ.khr_id) currency,

376: QTE.amount quote_total,
377: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',TRQ.qtp_code,'N') quote_type,
378: TRQ.creation_date quote_creation_date,
379: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',TRQ.qrs_code,'N') quote_reason,
380: OKL_AM_UTIL_PVT.get_chr_currency(TRQ.khr_id) currency,
381: TRQ.comments comments,
382: KHR.contract_number contract_number,
383: TRQ.last_updated_by last_updated_by
384: FROM OKC_K_HEADERS_B KHR,

Line 1054: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',TRQ.qtp_code,'N') quote_type,

1050: SELECT TO_CHAR(sysdate, 'MM-DD-YYYY') system_date,
1051: TRQ.quote_number quote_number,
1052: TRQ.date_effective_to effective_to,
1053: QTE.amount quote_total,
1054: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',TRQ.qtp_code,'N') quote_type,
1055: TRQ.creation_date quote_creation_date,
1056: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',TRQ.qrs_code,'N') quote_reason,
1057: OKL_AM_UTIL_PVT.get_chr_currency(TRQ.khr_id) currency,
1058: KHR.contract_number contract_number,

Line 1056: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',TRQ.qrs_code,'N') quote_reason,

1052: TRQ.date_effective_to effective_to,
1053: QTE.amount quote_total,
1054: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',TRQ.qtp_code,'N') quote_type,
1055: TRQ.creation_date quote_creation_date,
1056: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',TRQ.qrs_code,'N') quote_reason,
1057: OKL_AM_UTIL_PVT.get_chr_currency(TRQ.khr_id) currency,
1058: KHR.contract_number contract_number,
1059: TRQ.comments comments,
1060: TRQ.last_updated_by last_updated_by

Line 1057: OKL_AM_UTIL_PVT.get_chr_currency(TRQ.khr_id) currency,

1053: QTE.amount quote_total,
1054: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',TRQ.qtp_code,'N') quote_type,
1055: TRQ.creation_date quote_creation_date,
1056: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',TRQ.qrs_code,'N') quote_reason,
1057: OKL_AM_UTIL_PVT.get_chr_currency(TRQ.khr_id) currency,
1058: KHR.contract_number contract_number,
1059: TRQ.comments comments,
1060: TRQ.last_updated_by last_updated_by
1061: FROM OKC_K_HEADERS_B KHR,

Line 1222: OKL_ACCOUNTING_UTIL.format_amount(SUM(NVL(OTL.AMOUNT,0)),OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID))||' '||OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,

1218: CURSOR l_message_csr ( p_qte_id IN NUMBER) IS
1219: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
1220: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
1221: TO_CHAR(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
1222: OKL_ACCOUNTING_UTIL.format_amount(SUM(NVL(OTL.AMOUNT,0)),OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID))||' '||OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
1223: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
1224: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
1225: TO_CHAR(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
1226: KHR.CONTRACT_NUMBER CONTRACT_NUMBER,

Line 1223: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,

1219: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
1220: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
1221: TO_CHAR(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
1222: OKL_ACCOUNTING_UTIL.format_amount(SUM(NVL(OTL.AMOUNT,0)),OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID))||' '||OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
1223: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
1224: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
1225: TO_CHAR(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
1226: KHR.CONTRACT_NUMBER CONTRACT_NUMBER,
1227: OTQ.comments COMMENTS

Line 1224: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,

1220: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
1221: TO_CHAR(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
1222: OKL_ACCOUNTING_UTIL.format_amount(SUM(NVL(OTL.AMOUNT,0)),OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID))||' '||OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
1223: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
1224: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
1225: TO_CHAR(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
1226: KHR.CONTRACT_NUMBER CONTRACT_NUMBER,
1227: OTQ.comments COMMENTS
1228: FROM OKL_TRX_QUOTES_V OTQ,

Line 1438: l_org_id := OKL_AM_UTIL_PVT.get_chr_org_id(l_contract_id);

1434:
1435: SELECT SYSDATE INTO l_termination_date FROM DUAL;
1436:
1437: -- Get the org id for the contract
1438: l_org_id := OKL_AM_UTIL_PVT.get_chr_org_id(l_contract_id);
1439:
1440: -- Set the contract org id to the application
1441: --DBMS_APPLICATION_INFO.set_client_info (l_org_id);
1442: MO_GLOBAL.set_policy_context ('S', l_org_id); -- Bug 6140786

Line 2071: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);

2067: CLOSE c_qte_csr;
2068:
2069: l_qtev_rec.khr_id := l_contract_id;
2070: l_qtev_rec.qtp_code := l_qtp_code;
2071: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);
2072: IF l_qtp_code LIKE 'TER_RECOURSE%' THEN
2073: l_rgd_code := 'AVTQPR';
2074: ELSE
2075: l_rgd_code := 'AMTQPR';

Line 2079: OKL_AM_UTIL_PVT.get_rule_record(

2075: l_rgd_code := 'AMTQPR';
2076: END IF;
2077:
2078: -- Call the util api to get the rule info for service and maintenance rule
2079: OKL_AM_UTIL_PVT.get_rule_record(
2080: p_rgd_code => l_rgd_code, -- Rule Grp :Termination Quote Process
2081: p_rdf_code => 'AMFBOS', -- Rule Code:AM Bill of Sale Requirement
2082: p_chr_id => l_rule_khr_id,
2083: p_cle_id => NULL,

Line 2090: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);

2086: p_message_yn => FALSE); -- RMUNJULU 11-FEB-03 2797035 Changed TRUE to FALSE
2087:
2088: IF (is_debug_statement_on) THEN
2089: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2090: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);
2091: END IF;
2092:
2093: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
2094: IF NVL (l_rulv_rec.rule_information1, '*') = 'Y' THEN

Line 2585: OKL_AM_UTIL_PVT.get_rule_record(

2581: itemkey => itemkey,
2582: aname => 'CONTRACT_ID');
2583:
2584: -- Call the util api to get the rule info for Title/filing
2585: OKL_AM_UTIL_PVT.get_rule_record(
2586: p_rgd_code => 'LAAFLG', -- Rule Grp
2587: p_rdf_code => 'LAFLTL', -- Rule Code
2588: p_chr_id => l_contract_id,
2589: p_cle_id => NULL,

Line 2596: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

2592: p_message_yn => FALSE); -- RMUNJULU 11-FEB-03 2797035 Changed TRUE to FALSE
2593:
2594: IF (is_debug_statement_on) THEN
2595: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2596: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
2597: END IF;
2598:
2599: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
2600: IF l_rulv_rec.jtot_object1_code IS NOT NULL

Line 2885: OKL_AM_UTIL_PVT.get_rule_record(

2881: resultout := 'COMPLETE:NOTIFY_OUTSTANDING';
2882: END IF;
2883:
2884: -- Call the util api to get the rule info for Title/filing
2885: OKL_AM_UTIL_PVT.get_rule_record(
2886: p_rgd_code => 'LAAFLG', -- Rule Grp
2887: p_rdf_code => 'LAFLTL', -- Rule Code
2888: p_chr_id => l_contract_id,
2889: p_cle_id => null, -- ansethur 26-jul-2007 XMLP passed null in place of l_cle_id,

Line 2896: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);

2892: p_message_yn => FALSE);
2893:
2894: IF (is_debug_statement_on) THEN
2895: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2896: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);
2897: END IF;
2898:
2899:
2900: --12/20/06 rkuttiya changed recipient type to LESSEE,VENDOR as appropriate for XMLP Project

Line 3772: l_org_id := OKL_AM_UTIL_PVT.get_chr_org_id(l_contract_id);

3768: -- quote line exists which has invoices need to be created
3769: IF nvl(l_invoice_needed_yn,'N') = 'Y' THEN
3770:
3771: -- gboomian Bug 5265083 - Start
3772: l_org_id := OKL_AM_UTIL_PVT.get_chr_org_id(l_contract_id);
3773: -- Set the contract org id to the application
3774: --DBMS_APPLICATION_INFO.set_client_info (l_org_id);
3775: MO_GLOBAL.set_policy_context ('S', l_org_id); -- Bug 6140786
3776: -- gboomian Bug 5265083 - End

Line 4347: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,

4343: IS
4344: SELECT to_char(sysdate, 'DD-MON-RRRR') system_date,
4345: OTQ.quote_number quote_number,
4346: to_char(OTQ.date_effective_to, 'DD-MON-RRRR') effective_to,
4347: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
4348: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
4349: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
4350: to_char(OTQ.creation_date, 'DD-MON-RRRR') quote_creation_date,
4351: nvl2 (qp.cpl_id, okl_am_util_pvt.get_jtf_object_name (pr.jtot_object1_code, pr.object1_id1, pr.object1_id2), okl_am_util_pvt.get_jtf_object_name (qp.party_jtot_object1_code, qp.party_object1_id1,qp.party_object1_id2)) recipient_name,

Line 4348: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,

4344: SELECT to_char(sysdate, 'DD-MON-RRRR') system_date,
4345: OTQ.quote_number quote_number,
4346: to_char(OTQ.date_effective_to, 'DD-MON-RRRR') effective_to,
4347: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
4348: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
4349: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
4350: to_char(OTQ.creation_date, 'DD-MON-RRRR') quote_creation_date,
4351: nvl2 (qp.cpl_id, okl_am_util_pvt.get_jtf_object_name (pr.jtot_object1_code, pr.object1_id1, pr.object1_id2), okl_am_util_pvt.get_jtf_object_name (qp.party_jtot_object1_code, qp.party_object1_id1,qp.party_object1_id2)) recipient_name,
4352: to_char(qp.date_sent, 'DD-MON-RRRR') recipient_date,

Line 4349: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,

4345: OTQ.quote_number quote_number,
4346: to_char(OTQ.date_effective_to, 'DD-MON-RRRR') effective_to,
4347: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
4348: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
4349: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
4350: to_char(OTQ.creation_date, 'DD-MON-RRRR') quote_creation_date,
4351: nvl2 (qp.cpl_id, okl_am_util_pvt.get_jtf_object_name (pr.jtot_object1_code, pr.object1_id1, pr.object1_id2), okl_am_util_pvt.get_jtf_object_name (qp.party_jtot_object1_code, qp.party_object1_id1,qp.party_object1_id2)) recipient_name,
4352: to_char(qp.date_sent, 'DD-MON-RRRR') recipient_date,
4353: AD.CONTRACT_NUMBER CONTRACT_NUMBER,

Line 4351: nvl2 (qp.cpl_id, okl_am_util_pvt.get_jtf_object_name (pr.jtot_object1_code, pr.object1_id1, pr.object1_id2), okl_am_util_pvt.get_jtf_object_name (qp.party_jtot_object1_code, qp.party_object1_id1,qp.party_object1_id2)) recipient_name,

4347: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
4348: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
4349: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
4350: to_char(OTQ.creation_date, 'DD-MON-RRRR') quote_creation_date,
4351: nvl2 (qp.cpl_id, okl_am_util_pvt.get_jtf_object_name (pr.jtot_object1_code, pr.object1_id1, pr.object1_id2), okl_am_util_pvt.get_jtf_object_name (qp.party_jtot_object1_code, qp.party_object1_id1,qp.party_object1_id2)) recipient_name,
4352: to_char(qp.date_sent, 'DD-MON-RRRR') recipient_date,
4353: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
4354: OTQ.COMMENTS COMMENTS,
4355: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,

Line 4378: nvl2 (qp.cpl_id, okl_am_util_pvt.get_jtf_object_name (pr.jtot_object1_code, pr.object1_id1, pr.object1_id2), okl_am_util_pvt.get_jtf_object_name (qp.party_jtot_object1_code, qp.party_object1_id1,qp.party_object1_id2)),

4374: OTQ.QST_CODE,
4375: OTQ.creation_date,
4376: OTQ.qrs_code,
4377: OTQ.qtp_code,
4378: nvl2 (qp.cpl_id, okl_am_util_pvt.get_jtf_object_name (pr.jtot_object1_code, pr.object1_id1, pr.object1_id2), okl_am_util_pvt.get_jtf_object_name (qp.party_jtot_object1_code, qp.party_object1_id1,qp.party_object1_id2)),
4379: qp.date_sent,
4380: AD.CONTRACT_NUMBER,
4381: OTQ.COMMENTS,
4382: OTQ.LAST_UPDATED_BY,

Line 4686: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,

4682: IS
4683: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
4684: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
4685: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
4686: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
4687: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
4688: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
4689: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
4690: AD.CONTRACT_NUMBER CONTRACT_NUMBER,

Line 4687: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,

4683: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
4684: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
4685: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
4686: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
4687: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
4688: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
4689: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
4690: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
4691: OTQ.COMMENTS COMMENTS,

Line 4688: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,

4684: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
4685: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
4686: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
4687: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
4688: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
4689: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
4690: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
4691: OTQ.COMMENTS COMMENTS,
4692: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,

Line 4742: 'Projected Gain/Loss:'||okl_accounting_util.format_amount((l_quote_rec.gain_loss),okl_am_util_pvt.get_chr_currency(l_quote_rec.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(l_quote_rec.KHR_ID)||'
'||

4738:
4739: l_message := '

Quote Number:'||l_quote_rec.quote_number||'
'||
4740: 'Quote Effective To Date:'||l_quote_rec.effective_to||'
'||
4741: 'Total:'||l_quote_rec.quote_total||'
'||
4742: 'Projected Gain/Loss:'||okl_accounting_util.format_amount((l_quote_rec.gain_loss),okl_am_util_pvt.get_chr_currency(l_quote_rec.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(l_quote_rec.KHR_ID)||'
'||
4743: '

A Quote of type '||l_quote_rec.quote_type||' was requested for Contract '||l_quote_rec.contract_number||' on
'||
4744: l_quote_rec.quote_creation_date||' for the following reason: '||l_quote_rec.quote_reason||'.

'||
4745: '

Comments:
'||
4746: l_quote_rec.comments||'

'||

Line 5190: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,

5186: IS
5187: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
5188: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
5189: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
5190: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
5191: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
5192: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
5193: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
5194: AD.CONTRACT_NUMBER CONTRACT_NUMBER,

Line 5191: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,

5187: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
5188: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
5189: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
5190: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
5191: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
5192: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
5193: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
5194: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
5195: OTQ.COMMENTS COMMENTS,

Line 5192: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,

5188: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
5189: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
5190: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
5191: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
5192: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
5193: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
5194: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
5195: OTQ.COMMENTS COMMENTS,
5196: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,

Line 5356: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);

5352: CLOSE c_qte_csr;
5353:
5354: l_qtev_rec.khr_id := l_khr_id;
5355: l_qtev_rec.qtp_code := l_qtp_code;
5356: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);
5357: IF l_qtp_code LIKE 'TER_RECOURSE%' THEN
5358: l_rgd_code := 'AVTPAR';
5359: ELSE
5360: l_rgd_code := 'AMTPAR';

Line 5365: OKL_AM_UTIL_PVT.get_rule_record(

5361: END IF;
5362:
5363: IF l_partial_yn = 'Y' THEN
5364:
5365: OKL_AM_UTIL_PVT.get_rule_record(
5366: p_rgd_code => l_rgd_code,
5367: p_rdf_code => 'AMAPRE',
5368: p_chr_id => l_rule_khr_id,
5369: p_cle_id => NULL,

Line 5376: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

5372: p_message_yn => FALSE);
5373:
5374: IF (is_debug_statement_on) THEN
5375: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
5376: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
5377: END IF;
5378:
5379: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
5380:

Line 5642: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);

5638: CLOSE c_qte_csr;
5639:
5640: l_qtev_rec.khr_id := l_khr_id;
5641: l_qtev_rec.qtp_code := l_qtp_code;
5642: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);
5643: IF l_qtp_code LIKE 'TER_RECOURSE%' THEN
5644: l_rgd_code := 'AVTGAL';
5645: ELSE
5646: l_rgd_code := 'AMTGAL';

Line 5649: OKL_AM_UTIL_PVT.get_rule_record(

5645: ELSE
5646: l_rgd_code := 'AMTGAL';
5647: END IF;
5648:
5649: OKL_AM_UTIL_PVT.get_rule_record(
5650: p_rgd_code => l_rgd_code,
5651: p_rdf_code => 'AMAPRE',
5652: p_chr_id => l_rule_khr_id,
5653: p_cle_id => NULL,

Line 5660: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

5656: p_message_yn => FALSE);
5657:
5658: IF (is_debug_statement_on) THEN
5659: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
5660: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
5661: END IF;
5662:
5663:
5664: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

Line 6749: OKL_AM_UTIL_PVT.get_rule_record(

6745: -- ***************************************
6746: -- Check tolerance calculation options for Gain/Loss
6747: -- ***************************************
6748:
6749: OKL_AM_UTIL_PVT.get_rule_record(
6750: p_rgd_code => p_rgd_code,
6751: p_rdf_code => 'AMGALO',
6752: p_chr_id => p_khr_id,
6753: p_cle_id => NULL,

Line 6760: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);

6756: p_message_yn => TRUE);
6757:
6758: IF (is_debug_statement_on) THEN
6759: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6760: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);
6761: END IF;
6762:
6763:
6764: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

Line 6795: OKL_AM_UTIL_PVT.get_formula_value (

6791:
6792: l_gain_loss_approval := 'COMPLETE:YES';
6793:
6794: -- Get tolerance amount from tolerance formula
6795: OKL_AM_UTIL_PVT.get_formula_value (
6796: p_formula_name => l_formula_name,
6797: p_chr_id => p_khr_id, -- RMUNJULU Changed
6798: p_cle_id => NULL,
6799: p_additional_parameters => l_params, -- RMUNJULU 2794685 Added

Line 6827: OKL_AM_UTIL_PVT.get_formula_value (

6823:
6824: l_gain_loss_approval := 'COMPLETE:YES';
6825:
6826: -- Get Approval Processing Formula value : this will be the net gain loss for the quote
6827: OKL_AM_UTIL_PVT.get_formula_value (
6828: p_formula_name => l_approval_formula,
6829: p_chr_id => p_khr_id, -- RMUNJULU Changed
6830: p_cle_id => NULL,
6831: p_additional_parameters => l_params,

Line 6886: okl_am_util_pvt.set_message(

6882: l_line_formula_yn := TRUE;
6883:
6884: ELSE
6885: -- Invalid combination of values for RULE rule in GROUP group
6886: okl_am_util_pvt.set_message(
6887: p_app_name => 'OKL'
6888: ,p_msg_name => 'OKL_AM_INVALID_RULE_FORMULA'
6889: ,p_msg_level => OKL_AM_UTIL_PVT.G_DEBUG_LEVEL
6890: ,p_token1 => 'GROUP'

Line 6889: ,p_msg_level => OKL_AM_UTIL_PVT.G_DEBUG_LEVEL

6885: -- Invalid combination of values for RULE rule in GROUP group
6886: okl_am_util_pvt.set_message(
6887: p_app_name => 'OKL'
6888: ,p_msg_name => 'OKL_AM_INVALID_RULE_FORMULA'
6889: ,p_msg_level => OKL_AM_UTIL_PVT.G_DEBUG_LEVEL
6890: ,p_token1 => 'GROUP'
6891: ,p_token1_value => l_rgd_code
6892: ,p_token2 => 'RULE'
6893: ,p_token2_value => 'AMGALO');

Line 6928: okl_am_util_pvt.get_formula_value (

6924:
6925: FOR l_rec in c_qtl_csr(l_id) LOOP
6926:
6927: l_formula_value := 0;
6928: okl_am_util_pvt.get_formula_value (
6929: p_formula_name => l_formula_name,
6930: p_chr_id => l_khr_id,
6931: p_cle_id => l_rec.kle_id,
6932: x_formula_value => l_formula_value,

Line 8515: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(l_quote_rec.khr_id);

8511: FETCH l_quote_amt_csr INTO l_quote_amt_rec;
8512: CLOSE l_quote_amt_csr;
8513:
8514: -- Get the Currency Code
8515: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(l_quote_rec.khr_id);
8516:
8517: -- The termination quote approval process for Contract Number, Quote Number has resulted in error.
8518: -- The quote base amount is amount which is less than or equal to 0.
8519: -- Please verify and change the quote amounts and re-submit the quote for approval.

Line 8700: l_func_curr_code := okl_am_util_pvt.get_functional_currency;

8696: IF (is_debug_procedure_on) THEN
8697: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
8698: END IF;
8699:
8700: l_func_curr_code := okl_am_util_pvt.get_functional_currency;
8701:
8702: IF funcmode = 'RUN' THEN
8703: l_id := wf_engine.GetItemAttrText(itemtype => itemtype,
8704: itemkey => itemkey,

Line 8711: l_org_id := OKL_AM_UTIL_PVT.get_chr_org_id(l_contract_id);

8707: OPEN c_khr_csr(l_id);
8708: FETCH c_khr_csr INTO l_contract_id;
8709: CLOSE c_khr_csr;
8710:
8711: l_org_id := OKL_AM_UTIL_PVT.get_chr_org_id(l_contract_id);
8712:
8713: FOR l_assets IN c_quote_assets_csr(l_id) LOOP
8714: OPEN c_asset_return_csr(l_assets.kle_id);
8715: FETCH c_asset_return_csr INTO l_count;

Line 8758: OKL_AM_UTIL_PVT.get_formula_value (

8754: p_contract_id => l_contract_id,
8755: p_line_id => l_assets.kle_id,
8756: x_value => l_asset_return_value); */
8757:
8758: OKL_AM_UTIL_PVT.get_formula_value (
8759: --p_formula_name => 'ASSET_RETURN_AMOUNT',
8760: p_formula_name => l_formula_name,
8761: p_chr_id => l_contract_id,
8762: p_cle_id => l_assets.kle_id,