[Home] [Help]
503: -- enabled_flag added as a condition to ensure that no disabled elements
504: -- get added to detail region.
505: CURSOR c (p_txn_number NUMBER) IS
506: SELECT 'TRUE'
507: FROM qa_txn_collection_triggers
508: WHERE transaction_number = p_txn_number
509: --AND search_flag = 1
510: AND enabled_flag = 1
511: AND collection_trigger_id = p_element_id;
2313: dummy NUMBER;
2314:
2315: CURSOR c IS
2316: SELECT 1
2317: FROM qa_txn_collection_triggers qtct
2318: WHERE qtct.transaction_number = txn_number
2319: AND qtct.collection_trigger_id = element_id;
2320:
2321: BEGIN