DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on XLA_AE_HEADERS

Line 5969: UPDATE xla_ae_headers aeh

5965: p_calling_sequence => l_curr_calling_sequence
5966: );
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)),

Line 5986: FROM xla_ae_headers aeh

5982: last_update_date = sysdate,
5983: last_updated_by = FND_GLOBAL.user_id
5984: WHERE ael.ae_header_id in (
5985: SELECT aeh.ae_header_id
5986: FROM xla_ae_headers aeh
5987: WHERE aeh.event_id = l_event_ids(i)
5988: AND aeh.application_id = 200
5989: AND aeh.gl_transfer_status_code <> 'Y');
5990:

Line 6076: UPDATE xla_ae_headers aeh

6072: p_calling_sequence => l_curr_calling_sequence
6073: );
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)),

Line 6093: FROM xla_ae_headers aeh

6089: last_update_date = sysdate,
6090: last_updated_by = FND_GLOBAL.user_id
6091: WHERE ael.ae_header_id in (
6092: SELECT aeh.ae_header_id
6093: FROM xla_ae_headers aeh
6094: WHERE aeh.event_id = l_event_ids(i)
6095: AND aeh.application_id = 200
6096: AND aeh.gl_transfer_status_code <> 'Y');
6097:

Line 6336: UPDATE xla_ae_headers aeh

6332: p_calling_sequence => l_curr_calling_sequence
6333: );
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)),

Line 6353: FROM xla_ae_headers aeh

6349: last_update_date = sysdate,
6350: last_updated_by = FND_GLOBAL.user_id
6351: WHERE ael.ae_header_id in (
6352: SELECT aeh.ae_header_id
6353: FROM xla_ae_headers aeh
6354: WHERE aeh.event_id = l_event_ids(i)
6355: AND aeh.application_id = 200
6356: AND aeh.gl_transfer_status_code <> 'Y');
6357:

Line 6438: UPDATE xla_ae_headers aeh

6434: p_calling_sequence => l_curr_calling_sequence
6435: );
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)),

Line 6455: FROM xla_ae_headers aeh

6451: last_update_date = sysdate,
6452: last_updated_by = FND_GLOBAL.user_id
6453: WHERE ael.ae_header_id in (
6454: SELECT aeh.ae_header_id
6455: FROM xla_ae_headers aeh
6456: WHERE aeh.event_id = l_event_ids(i)
6457: AND aeh.application_id = 200
6458: AND aeh.gl_transfer_status_code <> 'Y');
6459: