DBA Data[Home] [Help]

APPS.IRC_UTILITIES_PKG dependencies on IRC_XML_UTIL

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

1064: return varchar2
1065: is
1066: cursor c_AMETxnDetails(c_offerId in varchar2) is
1067: SELECT history.transaction_history_id
1068: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMETranType')
1069: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMEAppId')
1070: FROM pqh_ss_transaction_history history,
1071: pqh_ss_trans_state_history histstate
1072: WHERE history.transaction_identifier = 'OFFER'

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

1065: is
1066: cursor c_AMETxnDetails(c_offerId in varchar2) is
1067: SELECT history.transaction_history_id
1068: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMETranType')
1069: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMEAppId')
1070: FROM pqh_ss_transaction_history history,
1071: pqh_ss_trans_state_history histstate
1072: WHERE history.transaction_identifier = 'OFFER'
1073: AND history.transaction_history_id = ( SELECT min(transaction_history_id)