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 4740: 'Projected Gain/Loss:'||okl_accounting_util.format_amount((l_projected_gl),okl_am_util_pvt.get_chr_currency(l_quote_rec.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(l_quote_rec.KHR_ID)||'
'||

4736:
4737: l_message := '

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

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

'||
4743: '

Comments:
'||
4744: l_quote_rec.comments||'

'||

Line 5188: 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,

5184: IS
5185: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
5186: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
5187: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
5188: 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,
5189: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
5190: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
5191: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
5192: AD.CONTRACT_NUMBER CONTRACT_NUMBER,

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

5185: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
5186: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
5187: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
5188: 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,
5189: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
5190: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
5191: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
5192: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
5193: OTQ.COMMENTS COMMENTS,

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

5186: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
5187: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
5188: 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,
5189: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
5190: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
5191: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
5192: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
5193: OTQ.COMMENTS COMMENTS,
5194: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,

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

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

Line 5363: OKL_AM_UTIL_PVT.get_rule_record(

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

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

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

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

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

Line 5647: OKL_AM_UTIL_PVT.get_rule_record(

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

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

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

Line 6747: OKL_AM_UTIL_PVT.get_rule_record(

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

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

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

Line 6793: OKL_AM_UTIL_PVT.get_formula_value (

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

Line 6825: OKL_AM_UTIL_PVT.get_formula_value (

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

Line 6884: okl_am_util_pvt.set_message(

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

Line 6887: ,p_msg_level => OKL_AM_UTIL_PVT.G_DEBUG_LEVEL

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

Line 6926: okl_am_util_pvt.get_formula_value (

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

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

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

Line 8698: l_func_curr_code := okl_am_util_pvt.get_functional_currency;

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

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

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

Line 8756: OKL_AM_UTIL_PVT.get_formula_value (

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