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 5727: WHERE AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469

5723: AI.legal_entity_id,
5724: AID.set_of_books_id ledger_id
5725: FROM ap_invoice_distributions_all AID,
5726: ap_invoices_all AI
5727: WHERE AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469
5728: = p_period_name
5729: AND aid.posted_flag IN ('N', 'S') -- Bug 6869699
5730: AND aid.org_id = ai.org_id
5731: AND AID.org_id IN

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

5793: ap_payment_history_all APH,
5794: ap_checks_all AC
5795: WHERE
5796: APH.check_id = AC.check_id
5797: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469
5798: = p_period_name
5799: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699
5800: and ac.org_id = aph.org_id
5801: AND APH.org_id IN

Line 5971: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(

5967:
5968: --Bug 6874970
5969: UPDATE xla_ae_headers aeh
5970: SET aeh.accounting_date = p_sweep_to_date,
5971: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(
5972: p_sweep_to_date,
5973: l_org_ids(i)),
5974: last_update_date = SYSDATE,
5975: last_updated_by = FND_GLOBAL.user_id

Line 6078: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(

6074:
6075: --Bug 6874970
6076: UPDATE xla_ae_headers aeh
6077: SET aeh.accounting_date = p_sweep_to_date,
6078: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(
6079: p_sweep_to_date,
6080: l_org_ids(i)),
6081: last_update_date = SYSDATE,
6082: last_updated_by = FND_GLOBAL.user_id

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

6220: WHERE ( ( p_period_name IS NULL AND
6221: AID.accounting_date BETWEEN p_from_date AND p_to_date)
6222: OR
6223: ( p_period_name IS NOT NULL AND
6224: AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(AID.accounting_date), aid.org_id) --bug5956469
6225: = p_period_name
6226: )
6227: )
6228: AND AID.posted_flag <> 'Y'

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

6242: FROM ap_payment_history_all APH,
6243: ap_checks_all AC
6244: WHERE APH.check_id = AC.check_id
6245: AND APH.org_id = AC.org_id
6246: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469
6247: = p_period_name
6248: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699
6249: AND APH.accounting_event_id is not NULL;--Bug6320053
6250:

Line 6338: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(

6334:
6335: --Bug 6874970
6336: UPDATE xla_ae_headers aeh
6337: SET aeh.accounting_date = p_sweep_to_date,
6338: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(
6339: p_sweep_to_date,
6340: l_org_ids(i)),
6341: last_update_date = SYSDATE,
6342: last_updated_by = FND_GLOBAL.user_id

Line 6440: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(

6436:
6437: --Bug 6874970
6438: UPDATE xla_ae_headers aeh
6439: SET aeh.accounting_date = p_sweep_to_date,
6440: aeh.period_name = AP_UTILITIES_PKG.get_gl_period_name(
6441: p_sweep_to_date,
6442: l_org_ids(i)),
6443: last_update_date = SYSDATE,
6444: last_updated_by = FND_GLOBAL.user_id