APPS.PSA_FUNDS_CHECKER_PKG dependencies on XLA_PSA_BC_LINES_V

Line 9729: FROM xla_psa_bc_lines_v l

9725: psa_utils.debug_other_string(g_state_level,l_full_path, 'Checking for Events Not Processed');
9726: FOR events_rec IN (SELECT *
9727: FROM xla_events_gt e
9728: WHERE NOT EXISTS (SELECT 1
9729: FROM xla_psa_bc_lines_v l
9730: WHERE l.event_id = e.event_id)) LOOP
9731: l_message := 'Event '||events_rec.event_id||' is not processed.';
9732: Fnd_message.set_name('PSA','PSA_GL_BC_PACKETS_EMPTY');
9733: Fnd_Message.Set_Token('PARAM_NAME',l_message);

Line 9821: FROM xla_psa_bc_lines_v;

9817:
9818: CURSOR debug_xla_psa_bc_v IS
9819: SELECT event_id, ae_header_id, ae_line_num, entity_id, ledger_id,
9820: period_name
9821: FROM xla_psa_bc_lines_v;
9822:
9823: CURSOR debug_psa_bc_alloc_gt IS
9824: SELECT hierarchy_id, ae_header_id, ae_line_num, event_id,
9825: status_code

Line 10271: events of XLA_PSA_BC_LINES_V. If any event is missing we disallow the group of related

10267: 1) We check whether transaction lines are related with allocation attributes or not.
10268: If allocation attributes are NOT used we do the normal processing.
10269: 2) Using allocation attributes we find out the relationship amongst trx lines and
10270: store this information into PSA_BC_ALLOC_GT. Events stored in this table are sampled with
10271: events of XLA_PSA_BC_LINES_V. If any event is missing we disallow the group of related
10272: transaction rows to go in for funds operation. */
10273:
10274: -- Preliminary check for allocation attributes usage.
10275: OPEN c_chk_alloc_used(p_ledgerid);

Line 10377: FROM xla_psa_bc_lines_v xv

10373:
10374: SELECT
10375: COUNT(DISTINCT(xv.event_id))
10376: INTO l_xla_event_cnt
10377: FROM xla_psa_bc_lines_v xv
10378: WHERE xv.event_id IN
10379: (
10380: (
10381: SELECT

Line 10528: FROM xla_psa_bc_lines_v xv,

10524: psa_bc_xla_pvt.g_application_id,
10525: xv.entity_id,
10526: NULL -- GROUP_ID
10527: BULK COLLECT INTO l_bc_pkts
10528: FROM xla_psa_bc_lines_v xv,
10529: gl_period_statuses ps
10530: WHERE ps.ledger_id = p_ledgerid and
10531: xv.period_name = ps.period_name and
10532: ps.application_id = 101 and

Line 11051: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_PSA_BC_LINES_V DUMP');

11047: ' REFERENCE_NUM_1 = '||z.reference_num_1);
11048: -- ====== FND LOG ======
11049: END LOOP;
11050: -- ====== FND LOG ======
11051: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_PSA_BC_LINES_V DUMP');
11052: psa_utils.debug_other_string(g_error_level,l_full_path,' --------------------------------------- ');
11053: -- ====== FND LOG ======
11054: FOR v in debug_xla_psa_bc_v
11055: LOOP

Line 11082: from xla_psa_bc_lines_v;

11078: END LOOP;
11079:
11080:
11081: select count(*) into l_var_1
11082: from xla_psa_bc_lines_v;
11083: -- ====== FND LOG ======
11084: psa_utils.debug_other_string(g_error_level,l_full_path, ' XLA_PSA_BC_LINES_V returns '||l_var_1||' rows. ');
11085: psa_utils.debug_other_string(g_error_level,l_full_path, ' Error: Populated 0 rows in gl_bc_packets.');
11086: psa_utils.debug_other_string(g_error_level,l_full_path, ' RETURN -> FALSE');

Line 11084: psa_utils.debug_other_string(g_error_level,l_full_path, ' XLA_PSA_BC_LINES_V returns '||l_var_1||' rows. ');

11080:
11081: select count(*) into l_var_1
11082: from xla_psa_bc_lines_v;
11083: -- ====== FND LOG ======
11084: psa_utils.debug_other_string(g_error_level,l_full_path, ' XLA_PSA_BC_LINES_V returns '||l_var_1||' rows. ');
11085: psa_utils.debug_other_string(g_error_level,l_full_path, ' Error: Populated 0 rows in gl_bc_packets.');
11086: psa_utils.debug_other_string(g_error_level,l_full_path, ' RETURN -> FALSE');
11087: -- ====== FND LOG ======
11088: END IF;