DBA Data[Home] [Help]

APPS.IRC_UTILITIES_PKG dependencies on IRC_XML_UTIL

Line 1083: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMETranType')

1079: return varchar2
1080: is
1081: cursor c_AMETxnDetails(c_offerId in varchar2) is
1082: SELECT history.transaction_history_id
1083: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMETranType')
1084: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMEAppId')
1085: FROM pqh_ss_transaction_history history,
1086: pqh_ss_trans_state_history histstate
1087: WHERE history.transaction_identifier = 'OFFER'

Line 1084: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMEAppId')

1080: is
1081: cursor c_AMETxnDetails(c_offerId in varchar2) is
1082: SELECT history.transaction_history_id
1083: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMETranType')
1084: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMEAppId')
1085: FROM pqh_ss_transaction_history history,
1086: pqh_ss_trans_state_history histstate
1087: WHERE history.transaction_identifier = 'OFFER'
1088: AND history.transaction_history_id = ( SELECT min(transaction_history_id)