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.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_UTILITIES_PKG

Line 6471: WHERE AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469

6467: AI.legal_entity_id,
6468: AID.set_of_books_id ledger_id
6469: FROM ap_invoice_distributions_all AID,
6470: ap_invoices_all AI
6471: WHERE AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469
6472: = p_period_name
6473: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699
6474: AND aid.org_id = ai.org_id
6475: AND AID.org_id IN

Line 6541: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469

6537: ap_payment_history_all APH,
6538: ap_checks_all AC
6539: WHERE
6540: APH.check_id = AC.check_id
6541: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469
6542: = p_period_name
6543: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699
6544: and ac.org_id = aph.org_id
6545: AND APH.org_id IN

Line 6715: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(

6711:
6712: --Bug 6874970
6713: UPDATE xla_ae_headers aeh
6714: SET aeh.accounting_date = p_sweep_to_date,
6715: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(
6716: p_sweep_to_date,
6717: l_org_ids(i)),
6718: last_update_date = SYSDATE,
6719: last_updated_by = FND_GLOBAL.user_id

Line 6822: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(

6818:
6819: --Bug 6874970
6820: UPDATE xla_ae_headers aeh
6821: SET aeh.accounting_date = p_sweep_to_date,
6822: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(
6823: p_sweep_to_date,
6824: l_org_ids(i)),
6825: last_update_date = SYSDATE,
6826: last_updated_by = FND_GLOBAL.user_id

Line 6968: AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469

6964: WHERE ( ( p_period_name IS NULL AND
6965: AID.accounting_date BETWEEN p_from_date AND p_to_date)
6966: OR
6967: ( p_period_name IS NOT NULL AND
6968: AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469
6969: = p_period_name
6970: )
6971: )
6972: AND AID.posted_flag <> 'Y'

Line 6990: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469

6986: FROM ap_payment_history_all APH,
6987: ap_checks_all AC
6988: WHERE APH.check_id = AC.check_id
6989: AND APH.org_id = AC.org_id
6990: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469
6991: = p_period_name
6992: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699
6993: AND APH.accounting_event_id is not NULL;--Bug6320053
6994:

Line 7082: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(

7078:
7079: --Bug 6874970
7080: UPDATE xla_ae_headers aeh
7081: SET aeh.accounting_date = p_sweep_to_date,
7082: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(
7083: p_sweep_to_date,
7084: l_org_ids(i)),
7085: last_update_date = SYSDATE,
7086: last_updated_by = FND_GLOBAL.user_id

Line 7184: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(

7180:
7181: --Bug 6874970
7182: UPDATE xla_ae_headers aeh
7183: SET aeh.accounting_date = p_sweep_to_date,
7184: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(
7185: p_sweep_to_date,
7186: l_org_ids(i)),
7187: last_update_date = SYSDATE,
7188: last_updated_by = FND_GLOBAL.user_id