DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on XLA_AE_HEADERS

Line 6713: UPDATE xla_ae_headers aeh

6709: p_calling_sequence => l_curr_calling_sequence
6710: );
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)),

Line 6730: FROM xla_ae_headers aeh

6726: last_update_date = sysdate,
6727: last_updated_by = FND_GLOBAL.user_id
6728: WHERE ael.ae_header_id in (
6729: SELECT aeh.ae_header_id
6730: FROM xla_ae_headers aeh
6731: WHERE aeh.event_id = l_event_ids(i)
6732: AND aeh.application_id = 200
6733: AND aeh.gl_transfer_status_code <> 'Y');
6734:

Line 6820: UPDATE xla_ae_headers aeh

6816: p_calling_sequence => l_curr_calling_sequence
6817: );
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)),

Line 6837: FROM xla_ae_headers aeh

6833: last_update_date = sysdate,
6834: last_updated_by = FND_GLOBAL.user_id
6835: WHERE ael.ae_header_id in (
6836: SELECT aeh.ae_header_id
6837: FROM xla_ae_headers aeh
6838: WHERE aeh.event_id = l_event_ids(i)
6839: AND aeh.application_id = 200
6840: AND aeh.gl_transfer_status_code <> 'Y');
6841:

Line 7080: UPDATE xla_ae_headers aeh

7076: p_calling_sequence => l_curr_calling_sequence
7077: );
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)),

Line 7097: FROM xla_ae_headers aeh

7093: last_update_date = sysdate,
7094: last_updated_by = FND_GLOBAL.user_id
7095: WHERE ael.ae_header_id in (
7096: SELECT aeh.ae_header_id
7097: FROM xla_ae_headers aeh
7098: WHERE aeh.event_id = l_event_ids(i)
7099: AND aeh.application_id = 200
7100: AND aeh.gl_transfer_status_code <> 'Y');
7101:

Line 7182: UPDATE xla_ae_headers aeh

7178: p_calling_sequence => l_curr_calling_sequence
7179: );
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)),

Line 7199: FROM xla_ae_headers aeh

7195: last_update_date = sysdate,
7196: last_updated_by = FND_GLOBAL.user_id
7197: WHERE ael.ae_header_id in (
7198: SELECT aeh.ae_header_id
7199: FROM xla_ae_headers aeh
7200: WHERE aeh.event_id = l_event_ids(i)
7201: AND aeh.application_id = 200
7202: AND aeh.gl_transfer_status_code <> 'Y');
7203: