APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_BC_COMMITMENTS

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

5251:
5252: /** Bug fix : if Invoice has Tax lines then api fails with sql error
5253: ** ORA-01427: single-row subquery returns more than one row to avoid this
5254: ** sum() function has been used. For proper fix we need to add few columns to
5255: ** pa_bc_packets and pa_bc_commitments to distiguish the lines as ITEM / TAX
5256: ** the fix required here to add one more condition a.line_type = b.line_type
5257: **/
5258:
5259: CURSOR updEnc(p_bc_pkt_id Number

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

14414: p_txn_exists_in_bc_pkt := 'N';
14415: End;
14416:
14417: If g_debug_mode = 'Y' then
14418: log_message(p_msg_token1=>'Any_txns_against_project:Baseline/CF Mode-Check if txns. exists in pa_bc_commitments');
14419: End If;
14420:
14421: Begin
14422: Select 'Y' into p_txn_exists_in_bc_cmt from dual where exists

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

14419: End If;
14420:
14421: Begin
14422: Select 'Y' into p_txn_exists_in_bc_cmt from dual where exists
14423: (select 1 from pa_bc_commitments where project_id = p_project_id);
14424: Exception
14425: When no_data_found then
14426: p_txn_exists_in_bc_cmt := 'N';
14427: End;