DBA Data[Home] [Help]

APPS.PSA_BC_XLA_PVT dependencies on PSA_XLA_ACCOUNTING_ERRORS_S

Line 114: SELECT psa_xla_accounting_errors_s.nextval

110: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
111: BEGIN
112: l_psa_xla_accounting_errors := p_psa_xla_accounting_errors;
113: IF (p_psa_xla_accounting_errors.accounting_error_id IS NULL) THEN
114: SELECT psa_xla_accounting_errors_s.nextval
115: INTO l_psa_xla_accounting_errors.accounting_error_id
116: FROM DUAL;
117: END IF;
118:

Line 158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,

154: l_psa_xla_accounting_errors.EVENT_ID,
155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,
156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,

Line 159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,

155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,
156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,

Line 160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,

156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,

Line 161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,

157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,

Line 162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,

158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,

Line 163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,

159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,

Line 164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,

160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,
168: l_psa_xla_accounting_errors.ENCODED_MSG,

Line 165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,

161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,
168: l_psa_xla_accounting_errors.ENCODED_MSG,
169: l_psa_xla_accounting_errors.AUDSID,

Line 217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;

213: l_psa_xla_accounting_errors.created_by := g_user_id;
214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;
215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;

Line 218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;

214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;
215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;

Line 219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;

215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;

Line 220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;

216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;

Line 221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;

217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;

Line 222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;

218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;

Line 223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;

219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;
227: l_psa_xla_accounting_errors.event_date := event_rec.event_date;

Line 224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;

220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;
227: l_psa_xla_accounting_errors.event_date := event_rec.event_date;
228: l_psa_xla_accounting_errors.ledger_id := event_rec.ledger_id;

Line 282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;

278: l_psa_xla_accounting_errors.audsid := g_audsid;
279: l_psa_xla_accounting_errors.creation_date := SYSDATE;
280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;

Line 283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;

279: l_psa_xla_accounting_errors.creation_date := SYSDATE;
280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;

Line 284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;

280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;

Line 285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;

281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;

Line 286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;

282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;

Line 287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;

283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;

Line 288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;

284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;
292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;

Line 289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;

285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;
292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;
293: l_psa_xla_accounting_errors.event_date := error_rec.event_date;