APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_JE_VALIDATION_PKG

Line 164: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int

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

Line 165: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int

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

Line 166: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar

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

Line 199: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

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

Line 200: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

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

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

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

Line 207: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

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

Line 208: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

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

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

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

Line 2312: l_ae_header_ids xla_je_validation_pkg.t_array_int;

2308: ,p_rev_orig_event_id IN NUMBER DEFAULT -1)
2309: IS
2310:
2311: l_info t_je_info;
2312: l_ae_header_ids xla_je_validation_pkg.t_array_int;
2313: l_ledger_ids xla_je_validation_pkg.t_array_int;
2314: l_status_codes xla_je_validation_pkg.t_array_varchar;
2315: l_seq_values t_array_int;
2316: l_seq_version_ids t_array_int;

Line 2313: l_ledger_ids xla_je_validation_pkg.t_array_int;

2309: IS
2310:
2311: l_info t_je_info;
2312: l_ae_header_ids xla_je_validation_pkg.t_array_int;
2313: l_ledger_ids xla_je_validation_pkg.t_array_int;
2314: l_status_codes xla_je_validation_pkg.t_array_varchar;
2315: l_seq_values t_array_int;
2316: l_seq_version_ids t_array_int;
2317: l_seq_assign_ids t_array_int;

Line 2314: l_status_codes xla_je_validation_pkg.t_array_varchar;

2310:
2311: l_info t_je_info;
2312: l_ae_header_ids xla_je_validation_pkg.t_array_int;
2313: l_ledger_ids xla_je_validation_pkg.t_array_int;
2314: l_status_codes xla_je_validation_pkg.t_array_varchar;
2315: l_seq_values t_array_int;
2316: l_seq_version_ids t_array_int;
2317: l_seq_assign_ids t_array_int;
2318: l_orig_status_code VARCHAR2(30);

Line 2450: l_result := xla_je_validation_pkg.balance_manual_entry

2446: END IF;
2447:
2448: -----------------------------------------------------------------------------
2449: -- Perform more validation and balance entries
2450: l_result := xla_je_validation_pkg.balance_manual_entry
2451: (p_application_id => l_info.application_id
2452: ,p_balance_flag => CASE WHEN p_retcode = C_COMPLETION_SUCCESS
2453: THEN TRUE
2454: ELSE FALSE END

Line 2769: (p_array_je_header_id IN xla_je_validation_pkg.t_array_int

2765: /* Bug 7011889 - Modified to handle array of header ids instead of variable */
2766:
2767:
2768: PROCEDURE reverse_journal_entry
2769: (p_array_je_header_id IN xla_je_validation_pkg.t_array_int
2770: ,p_application_id IN INTEGER
2771: ,p_reversal_method IN VARCHAR2
2772: ,p_gl_date IN DATE
2773: ,p_completion_option IN VARCHAR2

Line 4020: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

4016: PROCEDURE create_mrc_reversal_entry
4017: (p_info IN t_je_info
4018: ,p_reversal_method IN VARCHAR2
4019: ,p_orig_event_id IN NUMBER
4020: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4021: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4022: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
4023: IS
4024: l_event_source_info xla_events_pub_pkg.t_event_source_info;

Line 4021: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

4017: (p_info IN t_je_info
4018: ,p_reversal_method IN VARCHAR2
4019: ,p_orig_event_id IN NUMBER
4020: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4021: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4022: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
4023: IS
4024: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4025: l_entity_id INTEGER;

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

4018: ,p_reversal_method IN VARCHAR2
4019: ,p_orig_event_id IN NUMBER
4020: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4021: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4022: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
4023: IS
4024: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4025: l_entity_id INTEGER;
4026: l_period_name VARCHAR2(30);

Line 5044: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int

5040: FUNCTION populate_sequence_numbers
5041: (p_info IN t_je_info
5042: ,p_je_source_name IN VARCHAR2
5043: ,p_completed_date IN DATE
5044: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int
5045: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int
5046: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar
5047: ,p_seq_version_ids IN OUT NOCOPY t_array_int
5048: ,p_seq_values IN OUT NOCOPY t_array_int

Line 5045: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int

5041: (p_info IN t_je_info
5042: ,p_je_source_name IN VARCHAR2
5043: ,p_completed_date IN DATE
5044: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int
5045: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int
5046: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar
5047: ,p_seq_version_ids IN OUT NOCOPY t_array_int
5048: ,p_seq_values IN OUT NOCOPY t_array_int
5049: ,p_seq_assign_ids IN OUT NOCOPY t_array_int)

Line 5046: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar

5042: ,p_je_source_name IN VARCHAR2
5043: ,p_completed_date IN DATE
5044: ,p_ledger_ids IN xla_je_validation_pkg.t_array_int
5045: ,p_ae_header_ids IN xla_je_validation_pkg.t_array_int
5046: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar
5047: ,p_seq_version_ids IN OUT NOCOPY t_array_int
5048: ,p_seq_values IN OUT NOCOPY t_array_int
5049: ,p_seq_assign_ids IN OUT NOCOPY t_array_int)
5050: RETURN VARCHAR2

Line 5131: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

5127: --=============================================================================
5128: FUNCTION create_mrc_entries
5129: (p_info IN OUT NOCOPY t_je_info
5130: ,p_je_source_name IN VARCHAR2
5131: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5132: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5133: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
5134: RETURN VARCHAR2
5135: IS

Line 5132: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int

5128: FUNCTION create_mrc_entries
5129: (p_info IN OUT NOCOPY t_je_info
5130: ,p_je_source_name IN VARCHAR2
5131: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5132: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5133: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
5134: RETURN VARCHAR2
5135: IS
5136: CURSOR c_trx_ledger (p_trx_ledger_id INTEGER, p_application_id INTEGER) IS

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

5129: (p_info IN OUT NOCOPY t_je_info
5130: ,p_je_source_name IN VARCHAR2
5131: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5132: ,p_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
5133: ,p_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
5134: RETURN VARCHAR2
5135: IS
5136: CURSOR c_trx_ledger (p_trx_ledger_id INTEGER, p_application_id INTEGER) IS
5137: SELECT gl.name, gl.currency_code, gl.ledger_category_code, xlo.rounding_rule_code