APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_BC_COMMITMENTS

Line 5355: ** pa_bc_packets and pa_bc_commitments to distiguish the lines as ITEM / TAX

5351:
5352: /** Bug fix : if Invoice has Tax lines then api fails with sql error
5353: ** ORA-01427: single-row subquery returns more than one row to avoid this
5354: ** sum() function has been used. For proper fix we need to add few columns to
5355: ** pa_bc_packets and pa_bc_commitments to distiguish the lines as ITEM / TAX
5356: ** the fix required here to add one more condition a.line_type = b.line_type
5357: **/
5358:
5359: CURSOR updEnc(p_bc_pkt_id Number

Line 14840: log_message(p_msg_token1=>'Any_txns_against_project:Baseline/CF Mode-Check if txns. exists in pa_bc_commitments');

14836: p_txn_exists_in_bc_pkt := 'N';
14837: End;
14838:
14839: If g_debug_mode = 'Y' then
14840: log_message(p_msg_token1=>'Any_txns_against_project:Baseline/CF Mode-Check if txns. exists in pa_bc_commitments');
14841: End If;
14842:
14843: Begin
14844: Select 'Y' into p_txn_exists_in_bc_cmt from dual where exists

Line 14845: (select 1 from pa_bc_commitments where project_id = p_project_id);

14841: End If;
14842:
14843: Begin
14844: Select 'Y' into p_txn_exists_in_bc_cmt from dual where exists
14845: (select 1 from pa_bc_commitments where project_id = p_project_id);
14846: Exception
14847: When no_data_found then
14848: p_txn_exists_in_bc_cmt := 'N';
14849: End;