APPS.PSA_FUNDS_CHECKER_PKG dependencies on XLA_PSA_BC_LINES_V

Line 9550: FROM xla_psa_bc_lines_v;

9546:
9547: CURSOR debug_xla_psa_bc_v IS
9548: SELECT event_id, ae_header_id, ae_line_num, entity_id, ledger_id,
9549: period_name
9550: FROM xla_psa_bc_lines_v;
9551:
9552: CURSOR debug_psa_bc_alloc_gt IS
9553: SELECT hierarchy_id, ae_header_id, ae_line_num, event_id,
9554: status_code

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

9979: 1) We check whether transaction lines are related with allocation attributes or not.
9980: If allocation attributes are NOT used we do the normal processing.
9981: 2) Using allocation attributes we find out the relationship amongst trx lines and
9982: store this information into PSA_BC_ALLOC_GT. Events stored in this table are sampled with
9983: events of XLA_PSA_BC_LINES_V. If any event is missing we disallow the group of related
9984: transaction rows to go in for funds operation. */
9985:
9986: -- Preliminary check for allocation attributes usage.
9987: OPEN c_chk_alloc_used;

Line 10077: FROM xla_psa_bc_lines_v xv

10073:
10074: SELECT
10075: COUNT(DISTINCT(xv.event_id))
10076: INTO l_xla_event_cnt
10077: FROM xla_psa_bc_lines_v xv
10078: WHERE xv.event_id IN
10079: (
10080: (
10081: SELECT

Line 10228: FROM xla_psa_bc_lines_v xv,

10224: psa_bc_xla_pvt.g_application_id,
10225: xv.entity_id,
10226: NULL -- GROUP_ID
10227: BULK COLLECT INTO l_bc_pkts
10228: FROM xla_psa_bc_lines_v xv,
10229: gl_period_statuses ps
10230: WHERE ps.ledger_id = p_ledgerid and
10231: xv.period_name = ps.period_name and
10232: ps.application_id = 101 and

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

10745: ' REFERENCE_NUM_1 = '||z.reference_num_1);
10746: -- ====== FND LOG ======
10747: END LOOP;
10748: -- ====== FND LOG ======
10749: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_PSA_BC_LINES_V DUMP');
10750: psa_utils.debug_other_string(g_error_level,l_full_path,' --------------------------------------- ');
10751: -- ====== FND LOG ======
10752: FOR v in debug_xla_psa_bc_v
10753: LOOP

Line 10780: from xla_psa_bc_lines_v;

10776: END LOOP;
10777:
10778:
10779: select count(*) into l_var_1
10780: from xla_psa_bc_lines_v;
10781: -- ====== FND LOG ======
10782: psa_utils.debug_other_string(g_error_level,l_full_path, ' XLA_PSA_BC_LINES_V returns '||l_var_1||' rows. ');
10783: psa_utils.debug_other_string(g_error_level,l_full_path, ' Error: Populated 0 rows in gl_bc_packets.');
10784: psa_utils.debug_other_string(g_error_level,l_full_path, ' RETURN -> FALSE');

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

10778:
10779: select count(*) into l_var_1
10780: from xla_psa_bc_lines_v;
10781: -- ====== FND LOG ======
10782: psa_utils.debug_other_string(g_error_level,l_full_path, ' XLA_PSA_BC_LINES_V returns '||l_var_1||' rows. ');
10783: psa_utils.debug_other_string(g_error_level,l_full_path, ' Error: Populated 0 rows in gl_bc_packets.');
10784: psa_utils.debug_other_string(g_error_level,l_full_path, ' RETURN -> FALSE');
10785: -- ====== FND LOG ======
10786: p_return_code := 'T';