DBA Data[Home] [Help]

APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on IBY_TRXN_ERROR_TOKENS

Line 10492: token_name iby_trxn_error_tokens.token_name%TYPE,

10488: RETURN VARCHAR2 AS
10489: l_error_mes varchar2(4000);
10490:
10491: TYPE l_token_info_rec IS RECORD(
10492: token_name iby_trxn_error_tokens.token_name%TYPE,
10493: token_value iby_trxn_error_tokens.token_value%TYPE,
10494: lookup_type_source iby_trxn_error_tokens.lookup_type_source%TYPE,
10495: meaning fnd_lookups.meaning%TYPE);
10496:

Line 10493: token_value iby_trxn_error_tokens.token_value%TYPE,

10489: l_error_mes varchar2(4000);
10490:
10491: TYPE l_token_info_rec IS RECORD(
10492: token_name iby_trxn_error_tokens.token_name%TYPE,
10493: token_value iby_trxn_error_tokens.token_value%TYPE,
10494: lookup_type_source iby_trxn_error_tokens.lookup_type_source%TYPE,
10495: meaning fnd_lookups.meaning%TYPE);
10496:
10497: TYPE l_token_info_tab IS TABLE OF l_token_info_rec;

Line 10494: lookup_type_source iby_trxn_error_tokens.lookup_type_source%TYPE,

10490:
10491: TYPE l_token_info_rec IS RECORD(
10492: token_name iby_trxn_error_tokens.token_name%TYPE,
10493: token_value iby_trxn_error_tokens.token_value%TYPE,
10494: lookup_type_source iby_trxn_error_tokens.lookup_type_source%TYPE,
10495: meaning fnd_lookups.meaning%TYPE);
10496:
10497: TYPE l_token_info_tab IS TABLE OF l_token_info_rec;
10498:

Line 10503: FROM iby_trxn_error_tokens t, fnd_lookups l

10499: l_token_info l_token_info_tab;
10500:
10501: CURSOR token_info(c_trxn_error_id IN iby_transaction_errors.transaction_error_id%TYPE) IS
10502: SELECT t.token_name, t.token_value, t.lookup_type_source, l.meaning
10503: FROM iby_trxn_error_tokens t, fnd_lookups l
10504: WHERE t.transaction_error_id = (c_trxn_error_id)
10505: AND t.lookup_type_source = l.lookup_type(+)
10506: AND t.token_value = l.lookup_code(+);
10507:

Line 10572: token_name iby_trxn_error_tokens.token_name%TYPE,

10568: trxn_error_id iby_transaction_errors.transaction_error_id%TYPE,
10569: error_code iby_transaction_errors.error_code%TYPE);
10570:
10571: TYPE l_token_info_rec IS RECORD(
10572: token_name iby_trxn_error_tokens.token_name%TYPE,
10573: token_value iby_trxn_error_tokens.token_value%TYPE,
10574: lookup_type_source iby_trxn_error_tokens.lookup_type_source%TYPE,
10575: meaning fnd_lookups.meaning%TYPE);
10576:

Line 10573: token_value iby_trxn_error_tokens.token_value%TYPE,

10569: error_code iby_transaction_errors.error_code%TYPE);
10570:
10571: TYPE l_token_info_rec IS RECORD(
10572: token_name iby_trxn_error_tokens.token_name%TYPE,
10573: token_value iby_trxn_error_tokens.token_value%TYPE,
10574: lookup_type_source iby_trxn_error_tokens.lookup_type_source%TYPE,
10575: meaning fnd_lookups.meaning%TYPE);
10576:
10577: TYPE l_mes_info_tab IS TABLE OF l_mes_info_rec;

Line 10574: lookup_type_source iby_trxn_error_tokens.lookup_type_source%TYPE,

10570:
10571: TYPE l_token_info_rec IS RECORD(
10572: token_name iby_trxn_error_tokens.token_name%TYPE,
10573: token_value iby_trxn_error_tokens.token_value%TYPE,
10574: lookup_type_source iby_trxn_error_tokens.lookup_type_source%TYPE,
10575: meaning fnd_lookups.meaning%TYPE);
10576:
10577: TYPE l_mes_info_tab IS TABLE OF l_mes_info_rec;
10578: TYPE l_token_info_tab IS TABLE OF l_token_info_rec;

Line 10592: FROM iby_trxn_error_tokens t, fnd_lookups l

10588: AND error_status = 'ACTIVE';
10589:
10590: CURSOR token_info(c_trxn_error_id IN iby_transaction_errors.transaction_error_id%TYPE) IS
10591: SELECT t.token_name, t.token_value, t.lookup_type_source, l.meaning
10592: FROM iby_trxn_error_tokens t, fnd_lookups l
10593: WHERE t.transaction_error_id = (c_trxn_error_id)
10594: AND t.lookup_type_source = l.lookup_type(+)
10595: AND t.token_value = l.lookup_code(+);
10596: