APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_JE_VALIDATION_PKG

Line 165: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int

161: FUNCTION populate_sequence_numbers
162: (p_info IN t_je_info
163: ,p_je_source_name IN VARCHAR2
164: ,p_completed_date IN DATE
165: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int
166: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int
167: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar
168: ,p_seq_version_ids IN OUT NOCOPY t_array_int
169: ,p_seq_values IN OUT NOCOPY t_array_int

Line 166: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int

162: (p_info IN t_je_info
163: ,p_je_source_name IN VARCHAR2
164: ,p_completed_date IN DATE
165: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int
166: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int
167: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar
168: ,p_seq_version_ids IN OUT NOCOPY t_array_int
169: ,p_seq_values IN OUT NOCOPY t_array_int
170: ,p_seq_assign_ids IN OUT NOCOPY t_array_int)

Line 167: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar

163: ,p_je_source_name IN VARCHAR2
164: ,p_completed_date IN DATE
165: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int
166: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int
167: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar
168: ,p_seq_version_ids IN OUT NOCOPY t_array_int
169: ,p_seq_values IN OUT NOCOPY t_array_int
170: ,p_seq_assign_ids IN OUT NOCOPY t_array_int)
171: RETURN VARCHAR2;

Line 201: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

197: PROCEDURE create_mrc_reversal_entry
198: (p_info IN t_je_info
199: ,p_reversal_method IN VARCHAR2
200: ,p_orig_event_id IN NUMBER
201: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
202: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
203: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar);
204:
205:

Line 202: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

198: (p_info IN t_je_info
199: ,p_reversal_method IN VARCHAR2
200: ,p_orig_event_id IN NUMBER
201: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
202: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
203: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar);
204:
205:
206: FUNCTION create_mrc_entries

Line 203: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar);

199: ,p_reversal_method IN VARCHAR2
200: ,p_orig_event_id IN NUMBER
201: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
202: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
203: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar);
204:
205:
206: FUNCTION create_mrc_entries
207: (p_info IN OUT NOCOPY t_je_info

Line 209: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

205:
206: FUNCTION create_mrc_entries
207: (p_info IN OUT NOCOPY t_je_info
208: ,p_je_source_name IN VARCHAR2
209: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
210: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
211: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
212: RETURN VARCHAR2;
213:

Line 210: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

206: FUNCTION create_mrc_entries
207: (p_info IN OUT NOCOPY t_je_info
208: ,p_je_source_name IN VARCHAR2
209: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
210: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
211: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
212: RETURN VARCHAR2;
213:
214: PROCEDURE delete_mrc_entries

Line 211: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)

207: (p_info IN OUT NOCOPY t_je_info
208: ,p_je_source_name IN VARCHAR2
209: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
210: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
211: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
212: RETURN VARCHAR2;
213:
214: PROCEDURE delete_mrc_entries
215: (p_event_id IN INTEGER

Line 2340: l_ae_header_ids xla_je_validation_pkg.t_array_int;

2336:
2337: IS
2338:
2339: l_info t_je_info;
2340: l_ae_header_ids xla_je_validation_pkg.t_array_int;
2341: l_ledger_ids xla_je_validation_pkg.t_array_int;
2342: l_status_codes xla_je_validation_pkg.t_array_varchar;
2343: l_seq_values t_array_int;
2344: l_seq_version_ids t_array_int;

Line 2341: l_ledger_ids xla_je_validation_pkg.t_array_int;

2337: IS
2338:
2339: l_info t_je_info;
2340: l_ae_header_ids xla_je_validation_pkg.t_array_int;
2341: l_ledger_ids xla_je_validation_pkg.t_array_int;
2342: l_status_codes xla_je_validation_pkg.t_array_varchar;
2343: l_seq_values t_array_int;
2344: l_seq_version_ids t_array_int;
2345: l_seq_assign_ids t_array_int;

Line 2342: l_status_codes xla_je_validation_pkg.t_array_varchar;

2338:
2339: l_info t_je_info;
2340: l_ae_header_ids xla_je_validation_pkg.t_array_int;
2341: l_ledger_ids xla_je_validation_pkg.t_array_int;
2342: l_status_codes xla_je_validation_pkg.t_array_varchar;
2343: l_seq_values t_array_int;
2344: l_seq_version_ids t_array_int;
2345: l_seq_assign_ids t_array_int;
2346: l_orig_status_code VARCHAR2(30);

Line 2496: l_result := xla_je_validation_pkg.balance_manual_entry

2492: END IF;
2493:
2494: -----------------------------------------------------------------------------
2495: -- Perform more validation and balance entries
2496: l_result := xla_je_validation_pkg.balance_manual_entry
2497: (p_application_id => l_info.application_id
2498: ,p_balance_flag => CASE WHEN p_retcode = C_COMPLETION_SUCCESS
2499: THEN TRUE
2500: ELSE FALSE END

Line 2865: (p_array_je_header_id IN xla_je_validation_pkg.t_array_int

2861: /* Bug 7011889 - Modified to handle array of header ids instead of variable */
2862:
2863:
2864: PROCEDURE reverse_journal_entry
2865: (p_array_je_header_id IN xla_je_validation_pkg.t_array_int
2866: ,p_application_id IN INTEGER
2867: ,p_reversal_method IN VARCHAR2
2868: ,p_gl_date IN DATE
2869: ,p_completion_option IN VARCHAR2

Line 4144: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

4140: PROCEDURE create_mrc_reversal_entry
4141: (p_info IN t_je_info
4142: ,p_reversal_method IN VARCHAR2
4143: ,p_orig_event_id IN NUMBER
4144: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4145: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4146: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
4147: IS
4148: l_event_source_info xla_events_pub_pkg.t_event_source_info;

Line 4145: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

4141: (p_info IN t_je_info
4142: ,p_reversal_method IN VARCHAR2
4143: ,p_orig_event_id IN NUMBER
4144: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4145: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4146: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
4147: IS
4148: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4149: l_entity_id INTEGER;

Line 4146: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)

4142: ,p_reversal_method IN VARCHAR2
4143: ,p_orig_event_id IN NUMBER
4144: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4145: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4146: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
4147: IS
4148: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4149: l_entity_id INTEGER;
4150: l_period_name VARCHAR2(30);

Line 5240: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int

5236: FUNCTION populate_sequence_numbers
5237: (p_info IN t_je_info
5238: ,p_je_source_name IN VARCHAR2
5239: ,p_completed_date IN DATE
5240: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int
5241: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int
5242: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar
5243: ,p_seq_version_ids IN OUT NOCOPY t_array_int
5244: ,p_seq_values IN OUT NOCOPY t_array_int

Line 5241: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int

5237: (p_info IN t_je_info
5238: ,p_je_source_name IN VARCHAR2
5239: ,p_completed_date IN DATE
5240: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int
5241: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int
5242: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar
5243: ,p_seq_version_ids IN OUT NOCOPY t_array_int
5244: ,p_seq_values IN OUT NOCOPY t_array_int
5245: ,p_seq_assign_ids IN OUT NOCOPY t_array_int)

Line 5242: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar

5238: ,p_je_source_name IN VARCHAR2
5239: ,p_completed_date IN DATE
5240: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int
5241: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int
5242: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar
5243: ,p_seq_version_ids IN OUT NOCOPY t_array_int
5244: ,p_seq_values IN OUT NOCOPY t_array_int
5245: ,p_seq_assign_ids IN OUT NOCOPY t_array_int)
5246: RETURN VARCHAR2

Line 5327: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

5323: --=============================================================================
5324: FUNCTION create_mrc_entries
5325: (p_info IN OUT NOCOPY t_je_info
5326: ,p_je_source_name IN VARCHAR2
5327: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5328: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5329: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
5330: RETURN VARCHAR2
5331: IS

Line 5328: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

5324: FUNCTION create_mrc_entries
5325: (p_info IN OUT NOCOPY t_je_info
5326: ,p_je_source_name IN VARCHAR2
5327: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5328: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5329: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
5330: RETURN VARCHAR2
5331: IS
5332: CURSOR c_trx_ledger (p_trx_ledger_id INTEGER, p_application_id INTEGER) IS

Line 5329: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)

5325: (p_info IN OUT NOCOPY t_je_info
5326: ,p_je_source_name IN VARCHAR2
5327: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5328: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5329: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
5330: RETURN VARCHAR2
5331: IS
5332: CURSOR c_trx_ledger (p_trx_ledger_id INTEGER, p_application_id INTEGER) IS
5333: SELECT gl.name, gl.currency_code, gl.ledger_category_code, xlo.rounding_rule_code