APPS.IBY_AR_UTILS dependencies on IBY_AR_UTILS

Line 1: PACKAGE BODY IBY_AR_UTILS AS

1: PACKAGE BODY IBY_AR_UTILS AS
2: /* $Header: ibyarutb.pls 120.19.12020000.5 2012/11/20 11:37:51 dhati ship $*/
3:
4:
5: --

Line 47: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_document_receivable(2)';

43: p_source_view IN VARCHAR2
44: )
45: RETURN XMLType
46: IS
47: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_document_receivable(2)';
48: l_doc_rec XMLType;
49:
50: /*
51: Bug Number: 9397208

Line 202: -- IBY_AR_UTILS.get_document_receivable() will be invoked from two views (ibyxmlv.odf)

198: RETURN null;
199: END IF;
200:
201: -- Bug # 8301765 : Performance issue
202: -- IBY_AR_UTILS.get_document_receivable() will be invoked from two views (ibyxmlv.odf)
203: -- IBY_XML_FNDCPT_ORDER_1_0_V and IBY_XML_FNDCPT_ORDER_PN_1_0_V
204: -- If either Pcard level is 0 or invoking view is IBY_XML_FNDCPT_ORDER_1_0_V then return NULL
205: IF((p_source_view = 'IBY_XML_FNDCPT_ORDER_1_0_V') AND ( p_instrument_type <> 'BANKACCOUNT' )
206: AND (NVL(p_card_data_level,'0') = '0')) THEN

Line 246: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_document_receivable(3)';

242: p_source_view IN VARCHAR2
243: )
244: RETURN XMLType
245: IS
246: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_document_receivable(3)';
247: l_doc_rec XMLType;
248: l_exclude_flag VARCHAR2(1);
249:
250: /*

Line 490: x_msg_data := 'IBY_AR_UTILS.CALL_GET_PAYMENT_INFO ERROR: ' || x_msg_data;

486: EXCEPTION
487: WHEN others THEN
488: x_msg_count := 1;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: x_msg_data := 'IBY_AR_UTILS.CALL_GET_PAYMENT_INFO ERROR: ' || x_msg_data;
491: END;
492:
493: FUNCTION call_get_payment_info
494: (p_payment_server_order_num IN

Line 712: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_trxn_ref_number2';

708: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
709: RETURN VARCHAR2
710: IS
711: l_trxn_ref_number2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
712: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_trxn_ref_number2';
713:
714: CURSOR c_trxn_ref_number2
715: (ci_trxn_ext_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
716: IS

Line 751: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_authorization_status';

747: PROCEDURE get_authorization_status
748: (p_trxn_extension_id IN iby_fndcpt_tx_operations.trxn_extension_id%TYPE,
749: x_auth_flag OUT NOCOPY VARCHAR2)
750: IS
751: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_authorization_status';
752:
753: CURSOR c_auth_status(c_extension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
754: IS
755: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG

Line 799: END IBY_AR_UTILS;

795:
796: x_auth_flag:='N';
797: END;
798:
799: END IBY_AR_UTILS;