APPS.MSC_RP_PUB dependencies on MSC_RP_SELECTION_CRITERIA

Line 125: criteria_id, table_name,criteria_condition,criteria_value,saved_query_keys from msc_rp_selection_criteria

121: from msc_plans where plan_id=arg_plan_id;
122:
123: cursor get_criteria(arg_plan_id number) is
124: select
125: criteria_id, table_name,criteria_condition,criteria_value,saved_query_keys from msc_rp_selection_criteria
126: where
127: plan_id=arg_plan_id and criteria_condition=2 and saved_query_keys is not null;
128:
129: l_criteria_changed number;

Line 330: update msc_rp_selection_criteria

326: BEGIN
327: EXIT WHEN l_Counter > l_max_tries;
328: l_Counter := l_Counter + 1;
329: rp_Debug(l_counter || ' -- attempt to update ');
330: update msc_rp_selection_criteria
331: set key_values= l_key_values_xml_clob
332: where criteria_id= l_criteria_id;
333: rp_Debug(l_counter || ' -- after attempt to update ');
334: exit;