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.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_UNPOSTED_ITEM_UTIL

Line 5702: x_alloc_amt := ar_unposted_item_util.currRound((x_run_amt/x_applied_amount)

5698: END IF;
5699:
5700: -- Proration of Amounts
5701: x_run_amt := x_run_amt + p_ar_cm_to_rec(j).from_amount;
5702: x_alloc_amt := ar_unposted_item_util.currRound((x_run_amt/x_applied_amount)
5703: * x_sign_value * p_ar_cm_from_rec(i).amount ,p_ar_cm_from_rec(i).CURRENCY_CODE)
5704: - x_run_alloc_amt;
5705: x_run_alloc_amt := x_run_alloc_amt + x_alloc_amt;
5706: p_ar_cm_to_rec(j).from_amount := p_ar_cm_to_rec(j).from_amount + x_alloc_amt;

Line 5711: x_alloc_acctd_amt := ar_unposted_item_util.currRound((x_run_acctd_amt/x_applied_acctd_amount)

5707: x_base_sum := x_base_sum + p_ar_cm_to_rec(j).from_amount;
5708:
5709: -- Proration of Accounted Amounts
5710: x_run_acctd_amt := x_run_acctd_amt + p_ar_cm_to_rec(j).from_acctd_amount;
5711: x_alloc_acctd_amt := ar_unposted_item_util.currRound((x_run_acctd_amt/x_applied_acctd_amount)
5712: * x_sign_value * p_ar_cm_from_rec(i).acctd_amount ,p_ar_cm_from_rec(i).CURRENCY_CODE) - x_run_alloc_acctd_amt;
5713: x_run_alloc_acctd_amt := x_run_alloc_acctd_amt + x_alloc_acctd_amt;
5714: p_ar_cm_to_rec(j).from_acctd_amount := p_ar_cm_to_rec(j).from_acctd_amount + x_alloc_acctd_amt;
5715: x_base_acctd_sum := x_base_acctd_sum + p_ar_cm_to_rec(j).from_acctd_amount;

Line 6299: ar_unposted_item_util.currRound(app.amount_applied-

6295: ,decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.amount, -1*(crh.amount)) crh_amount
6296: ,decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.acctd_amount, -1*(crh.acctd_amount)) crh_acctd_amount
6297: ,crh.crh_line_id CRH_RECORD_ID
6298: ,decode(crh.recp_amount, 0 , 0 , decode(crh.source_type, 'BANK_CHARGES',
6299: ar_unposted_item_util.currRound(app.amount_applied-
6300: ((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.recp_amount-crh.amount, crh.recp_amount+crh.amount)/crh.recp_amount)
6301: * app.amount_applied)
6302: ,app.from_currency_code),
6303: ar_unposted_item_util.currRound((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.amount, -1*(crh.amount))/crh.recp_amount) * app.amount_applied,app.from_currency_code))) ALLOC_AMOUNT

Line 6303: ar_unposted_item_util.currRound((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.amount, -1(crh.amount))/crh.recp_amount) app.amount_applied,app.from_currency_code))) ALLOC_AMOUNT

6299: ar_unposted_item_util.currRound(app.amount_applied-
6300: ((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.recp_amount-crh.amount, crh.recp_amount+crh.amount)/crh.recp_amount)
6301: * app.amount_applied)
6302: ,app.from_currency_code),
6303: ar_unposted_item_util.currRound((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.amount, -1*(crh.amount))/crh.recp_amount) * app.amount_applied,app.from_currency_code))) ALLOC_AMOUNT
6304: ,decode(crh.recp_acctd_amount, 0 , 0 , decode(crh.source_type, 'BANK_CHARGES',
6305: ar_unposted_item_util.currRound(app.acctd_amount_applied-
6306: ((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.recp_acctd_amount-crh.acctd_amount, crh.recp_acctd_amount+crh.acctd_amount)/crh.recp_acctd_amount)
6307: * app.acctd_amount_applied)

Line 6305: ar_unposted_item_util.currRound(app.acctd_amount_applied-

6301: * app.amount_applied)
6302: ,app.from_currency_code),
6303: ar_unposted_item_util.currRound((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.amount, -1*(crh.amount))/crh.recp_amount) * app.amount_applied,app.from_currency_code))) ALLOC_AMOUNT
6304: ,decode(crh.recp_acctd_amount, 0 , 0 , decode(crh.source_type, 'BANK_CHARGES',
6305: ar_unposted_item_util.currRound(app.acctd_amount_applied-
6306: ((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.recp_acctd_amount-crh.acctd_amount, crh.recp_acctd_amount+crh.acctd_amount)/crh.recp_acctd_amount)
6307: * app.acctd_amount_applied)
6308: ,app.from_currency_code),
6309: ar_unposted_item_util.currRound((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.acctd_amount, -1*(crh.acctd_amount))/crh.recp_acctd_amount) * app.acctd_amount_applied

Line 6309: ar_unposted_item_util.currRound((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.acctd_amount, -1(crh.acctd_amount))/crh.recp_acctd_amount) app.acctd_amount_applied

6305: ar_unposted_item_util.currRound(app.acctd_amount_applied-
6306: ((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.recp_acctd_amount-crh.acctd_amount, crh.recp_acctd_amount+crh.acctd_amount)/crh.recp_acctd_amount)
6307: * app.acctd_amount_applied)
6308: ,app.from_currency_code),
6309: ar_unposted_item_util.currRound((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.acctd_amount, -1*(crh.acctd_amount))/crh.recp_acctd_amount) * app.acctd_amount_applied
6310: ,app.from_currency_code))) ALLOC_ACCTD_AMOUNT
6311: ,decode(crh.dist_line_status, 'REVERSAL', -1*app_max_line.max_line_id, app_max_line.max_line_id)
6312: ,app.mfar_upg_trx
6313: FROM ar_crh_gt crh,

Line 6471: ar_unposted_item_util.currRound((abs(crhlatest.amount)/abs(crhlatest.amount+ nvl(crhlatest.factor_discount_amount,0)))*ra.amount_applied,cr.currency_code)) ALLOC_AMOUNT

6467: ,abs(crhlatest.amount) crh_amount
6468: ,abs(crhlatest.acctd_amount) crh_acctd_amount
6469: ,crhlatest.cash_receipt_history_id CRH_RECORD_ID
6470: ,decode(crhlatest.amount+ nvl(crhlatest.factor_discount_amount,0),0,0,
6471: ar_unposted_item_util.currRound((abs(crhlatest.amount)/abs(crhlatest.amount+ nvl(crhlatest.factor_discount_amount,0)))*ra.amount_applied,cr.currency_code)) ALLOC_AMOUNT
6472: ,decode(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0),0,0,
6473: ar_unposted_item_util.currRound((abs(crhlatest.acctd_amount)/abs(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from,cr.currency_code)) ALLOC_ACCTD_AMOUNT
6474: ,ext.max_line_id MAX_LINE_ID
6475: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx

Line 6473: ar_unposted_item_util.currRound((abs(crhlatest.acctd_amount)/abs(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from,cr.currency_code)) ALLOC_ACCTD_AMOUNT

6469: ,crhlatest.cash_receipt_history_id CRH_RECORD_ID
6470: ,decode(crhlatest.amount+ nvl(crhlatest.factor_discount_amount,0),0,0,
6471: ar_unposted_item_util.currRound((abs(crhlatest.amount)/abs(crhlatest.amount+ nvl(crhlatest.factor_discount_amount,0)))*ra.amount_applied,cr.currency_code)) ALLOC_AMOUNT
6472: ,decode(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0),0,0,
6473: ar_unposted_item_util.currRound((abs(crhlatest.acctd_amount)/abs(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from,cr.currency_code)) ALLOC_ACCTD_AMOUNT
6474: ,ext.max_line_id MAX_LINE_ID
6475: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6476: FROM xla_events_gt gt,
6477: ar_receivable_applications_all ra,

Line 6588: ar_unposted_item_util.currRound((abs(crh.amount)/abs(crh.amount+ nvl(crh.factor_discount_amount,0)))*ra.amount_applied,cr.currency_code)) ALLOC_AMOUNT

6584: ,abs(crh.amount) crh_amount
6585: ,abs(crh.acctd_amount) crh_acctd_amount
6586: ,crh.cash_receipt_history_id CRH_RECORD_ID
6587: ,decode(crh.amount+ nvl(crh.factor_discount_amount,0),0,0,
6588: ar_unposted_item_util.currRound((abs(crh.amount)/abs(crh.amount+ nvl(crh.factor_discount_amount,0)))*ra.amount_applied,cr.currency_code)) ALLOC_AMOUNT
6589: ,decode(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0),0,0,
6590: ar_unposted_item_util.currRound((abs(crh.acctd_amount)/abs(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from,cr.currency_code)) ALLOC_ACCTD_AMOUNT
6591: ,ext.max_line_id MAX_LINE_ID
6592: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx

Line 6590: ar_unposted_item_util.currRound((abs(crh.acctd_amount)/abs(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from,cr.currency_code)) ALLOC_ACCTD_AMOUNT

6586: ,crh.cash_receipt_history_id CRH_RECORD_ID
6587: ,decode(crh.amount+ nvl(crh.factor_discount_amount,0),0,0,
6588: ar_unposted_item_util.currRound((abs(crh.amount)/abs(crh.amount+ nvl(crh.factor_discount_amount,0)))*ra.amount_applied,cr.currency_code)) ALLOC_AMOUNT
6589: ,decode(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0),0,0,
6590: ar_unposted_item_util.currRound((abs(crh.acctd_amount)/abs(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from,cr.currency_code)) ALLOC_ACCTD_AMOUNT
6591: ,ext.max_line_id MAX_LINE_ID
6592: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6593: FROM xla_events_gt gt,
6594: ar_receivable_applications_all ra,

Line 6701: ar_unposted_item_util.currRound(ra.amount_applied-((abs(crhlatest.amount)/abs(crhlatest.amount+ nvl(crhlatest.factor_discount_amount,0)))*ra.amount_applied),cr.currency_code)) ALLOC_AMOUNT

6697: ,abs(crhlatest.factor_discount_amount) crh_amount
6698: ,abs(crhlatest.acctd_factor_discount_amount) crh_acctd_amount
6699: ,crhlatest.cash_receipt_history_id CRH_RECORD_ID
6700: ,decode(crhlatest.amount+ nvl(crhlatest.factor_discount_amount,0),0,0,
6701: ar_unposted_item_util.currRound(ra.amount_applied-((abs(crhlatest.amount)/abs(crhlatest.amount+ nvl(crhlatest.factor_discount_amount,0)))*ra.amount_applied),cr.currency_code)) ALLOC_AMOUNT
6702: ,decode(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0),0,0,
6703: ar_unposted_item_util.currRound(ra.acctd_amount_applied_from-((abs(crhlatest.acctd_amount)/abs(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from),cr.currency_code)) ALLOC_ACCTD_AMOUNT
6704: ,ext.max_line_id MAX_LINE_ID
6705: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx

Line 6703: ar_unposted_item_util.currRound(ra.acctd_amount_applied_from-((abs(crhlatest.acctd_amount)/abs(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from),cr.currency_code)) ALLOC_ACCTD_AMOUNT

6699: ,crhlatest.cash_receipt_history_id CRH_RECORD_ID
6700: ,decode(crhlatest.amount+ nvl(crhlatest.factor_discount_amount,0),0,0,
6701: ar_unposted_item_util.currRound(ra.amount_applied-((abs(crhlatest.amount)/abs(crhlatest.amount+ nvl(crhlatest.factor_discount_amount,0)))*ra.amount_applied),cr.currency_code)) ALLOC_AMOUNT
6702: ,decode(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0),0,0,
6703: ar_unposted_item_util.currRound(ra.acctd_amount_applied_from-((abs(crhlatest.acctd_amount)/abs(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from),cr.currency_code)) ALLOC_ACCTD_AMOUNT
6704: ,ext.max_line_id MAX_LINE_ID
6705: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6706: FROM xla_events_gt gt,
6707: ar_receivable_applications_all ra,

Line 6821: ar_unposted_item_util.currRound(ra.amount_applied-((abs(crh.amount)/abs(crh.amount+ nvl(crh.factor_discount_amount,0)))*ra.amount_applied),cr.currency_code)) ALLOC_AMOUNT

6817: ,abs(crhgt.amount) crh_amount
6818: ,abs(crhgt.acctd_amount) crh_acctd_amount
6819: ,crh.cash_receipt_history_id CRH_RECORD_ID
6820: ,decode(crh.amount+ nvl(crh.factor_discount_amount,0),0,0,
6821: ar_unposted_item_util.currRound(ra.amount_applied-((abs(crh.amount)/abs(crh.amount+ nvl(crh.factor_discount_amount,0)))*ra.amount_applied),cr.currency_code)) ALLOC_AMOUNT
6822: ,decode(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0),0,0,
6823: ar_unposted_item_util.currRound(ra.acctd_amount_applied_from-((abs(crh.acctd_amount)/abs(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from),cr.currency_code)) ALLOC_ACCTD_AMOUNT
6824: ,ext.max_line_id MAX_LINE_ID
6825: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx

Line 6823: ar_unposted_item_util.currRound(ra.acctd_amount_applied_from-((abs(crh.acctd_amount)/abs(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from),cr.currency_code)) ALLOC_ACCTD_AMOUNT

6819: ,crh.cash_receipt_history_id CRH_RECORD_ID
6820: ,decode(crh.amount+ nvl(crh.factor_discount_amount,0),0,0,
6821: ar_unposted_item_util.currRound(ra.amount_applied-((abs(crh.amount)/abs(crh.amount+ nvl(crh.factor_discount_amount,0)))*ra.amount_applied),cr.currency_code)) ALLOC_AMOUNT
6822: ,decode(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0),0,0,
6823: ar_unposted_item_util.currRound(ra.acctd_amount_applied_from-((abs(crh.acctd_amount)/abs(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from),cr.currency_code)) ALLOC_ACCTD_AMOUNT
6824: ,ext.max_line_id MAX_LINE_ID
6825: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6826: FROM xla_events_gt gt,
6827: ar_receivable_applications_all ra,

Line 8681: x_alloc_amt := ar_unposted_item_util.currRound((x_run_amt/p_crh_mfar_extract_record(i).recp_acctd_amount)

8677: x_CRH_RECORD_ID := p_crh_mfar_extract_record(i).CRH_RECORD_ID;
8678:
8679: -- Proration of Amounts
8680: x_run_amt := x_run_amt + p_crh_mfar_extract_record(i).crh_acctd_amount;
8681: x_alloc_amt := ar_unposted_item_util.currRound((x_run_amt/p_crh_mfar_extract_record(i).recp_acctd_amount)
8682: * p_crh_mfar_extract_record(i).amount,p_crh_mfar_extract_record(i).FROM_CURRENCY_CODE)
8683: - x_run_alloc_amt;
8684: x_run_alloc_amt := x_run_alloc_amt + x_alloc_amt;
8685:

Line 8688: x_alloc_acctd_amt := ar_unposted_item_util.currRound((x_run_acctd_amt/p_crh_mfar_extract_record(i).recp_acctd_amount)

8684: x_run_alloc_amt := x_run_alloc_amt + x_alloc_amt;
8685:
8686: -- Proration of Accounted Amounts
8687: x_run_acctd_amt := x_run_acctd_amt + p_crh_mfar_extract_record(i).crh_acctd_amount;
8688: x_alloc_acctd_amt := ar_unposted_item_util.currRound((x_run_acctd_amt/p_crh_mfar_extract_record(i).recp_acctd_amount)
8689: * p_crh_mfar_extract_record(i).acctd_amount,p_crh_mfar_extract_record(i).BASE_CURRENCY_CODE) - x_run_alloc_acctd_amt;
8690: x_run_alloc_acctd_amt := x_run_alloc_acctd_amt + x_alloc_acctd_amt;
8691:
8692: -- Proration of From Amounts

Line 8694: x_alloc_from_amt := ar_unposted_item_util.currRound((x_run_from_amt/p_crh_mfar_extract_record(i).recp_acctd_amount)

8690: x_run_alloc_acctd_amt := x_run_alloc_acctd_amt + x_alloc_acctd_amt;
8691:
8692: -- Proration of From Amounts
8693: x_run_from_amt := x_run_from_amt + p_crh_mfar_extract_record(i).crh_acctd_amount;
8694: x_alloc_from_amt := ar_unposted_item_util.currRound((x_run_from_amt/p_crh_mfar_extract_record(i).recp_acctd_amount)
8695: * p_crh_mfar_extract_record(i).from_amount,p_crh_mfar_extract_record(i).FROM_CURRENCY_CODE)
8696: - x_run_alloc_from_amt;
8697: x_run_alloc_from_amt := x_run_alloc_from_amt + x_alloc_from_amt;
8698:

Line 8701: x_alloc_from_acctd_amt := ar_unposted_item_util.currRound((x_run_from_acctd_amt/p_crh_mfar_extract_record(i).recp_acctd_amount)

8697: x_run_alloc_from_amt := x_run_alloc_from_amt + x_alloc_from_amt;
8698:
8699: -- Proration of From Accounted Amounts
8700: x_run_from_acctd_amt := x_run_from_acctd_amt + p_crh_mfar_extract_record(i).crh_acctd_amount;
8701: x_alloc_from_acctd_amt := ar_unposted_item_util.currRound((x_run_from_acctd_amt/p_crh_mfar_extract_record(i).recp_acctd_amount)
8702: * p_crh_mfar_extract_record(i).from_acctd_amount,p_crh_mfar_extract_record(i).BASE_CURRENCY_CODE) - x_run_alloc_from_acctd_amt;
8703: x_run_alloc_from_acctd_amt := x_run_alloc_from_acctd_amt + x_alloc_from_acctd_amt;
8704:
8705:

Line 8950: x_alloc_from_acctd_amt := ar_unposted_item_util.currRound((x_run_from_acctd_amt/NVL(p_extract_record(i).AMOUNT_APPLIED_FROM,p_extract_record(i).AMOUNT_APPLIED))

8946: x_APP_RECORD_ID := p_extract_record(i).SOURCE_ID;
8947:
8948: -- Proration of From Accounted Amounts
8949: x_run_from_acctd_amt := x_run_from_acctd_amt + p_extract_record(i).FROM_AMOUNT;
8950: x_alloc_from_acctd_amt := ar_unposted_item_util.currRound((x_run_from_acctd_amt/NVL(p_extract_record(i).AMOUNT_APPLIED_FROM,p_extract_record(i).AMOUNT_APPLIED))
8951: * p_extract_record(i).ACCTD_AMOUNT_APPLIED_FROM,p_extract_record(i).BASE_CURRENCY_CODE) - x_run_alloc_from_acctd_amt;
8952: x_run_alloc_from_acctd_amt := x_run_alloc_from_acctd_amt + x_alloc_from_acctd_amt;
8953:
8954: -- Assign the values to extract table