APPS.QA_CHAR_UPDATE_PKG dependencies on QA_PLAN_COLLECTION_TRIGGERS

Line 518: UPDATE QA_PLAN_COLLECTION_TRIGGERS

514: )
515: IS
516: l_api_name CONSTANT VARCHAR2(30) := 'update_plan_coll_trig';
517: BEGIN
518: UPDATE QA_PLAN_COLLECTION_TRIGGERS
519: SET low_value = p_new_value
520: WHERE collection_trigger_id = p_char_id
521: AND low_value = p_old_value
522: AND plan_transaction_id IN

Line 536: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_COLLECTION_TRIGGERS.low_value for char_id: ' || p_char_id

532: FND_LOG.string
533: (
534: FND_LOG.level_statement,
535: g_pkg_name || '.' || l_api_name,
536: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_COLLECTION_TRIGGERS.low_value for char_id: ' || p_char_id
537: );
538: END IF;
539:
540: UPDATE QA_PLAN_COLLECTION_TRIGGERS

Line 540: UPDATE QA_PLAN_COLLECTION_TRIGGERS

536: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_COLLECTION_TRIGGERS.low_value for char_id: ' || p_char_id
537: );
538: END IF;
539:
540: UPDATE QA_PLAN_COLLECTION_TRIGGERS
541: SET high_value = p_new_value
542: WHERE collection_trigger_id = p_char_id
543: AND high_value = p_old_value
544: AND plan_transaction_id IN

Line 558: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_COLLECTION_TRIGGERS.high_value for char_id: ' || p_char_id

554: FND_LOG.string
555: (
556: FND_LOG.level_statement,
557: g_pkg_name || '.' || l_api_name,
558: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_COLLECTION_TRIGGERS.high_value for char_id: ' || p_char_id
559: );
560: END IF;
561: END update_plan_coll_trig;
562: