DBA Data[Home] [Help]

APPS.ECE_RULES_PKG dependencies on DUAL

Line 81: select ece_rule_violations_s.nextval into l_seq from dual;

77: xProgress := 'ECERULEB-10-1020';
78: -- insert new violation information into ece_rule_violations table.
79:
80: l_cur_index := g_rule_violation_tbl.count + 1;
81: select ece_rule_violations_s.nextval into l_seq from dual;
82:
83: if SQL%NOTFOUND then
84: ec_debug.pl (0, 'EC', 'ECE_GET_NEXT_SEQ_FAILED',
85: 'PROGRESS_LEVEL', xProgress,

Line 2025: NULL) into l_address_type from dual;

2021: g_bank, ece_trading_partners_pub.g_bank,
2022: g_customer, ece_trading_partners_pub.g_customer,
2023: g_supplier, ece_trading_partners_pub.g_supplier,
2024: g_hr_location, ece_trading_partners_pub.g_hr_location,
2025: NULL) into l_address_type from dual;
2026: end if;
2027:
2028: xProgress := 'ECERULEB-130-1200';
2029: l_transaction_type := ec_utils.g_transaction_type;