APPS.CN_RULESETS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

    SELECT *
      FROM cn_rulesets
     WHERE ruleset_id = x_ruleset_id_in and
     org_id=x_org_id;

Line: 34

    cn_syin_rulesets_pkg.update_row(x_ruleset_id_in,
                                   l_get_ruleset_data_rec.object_version_number,
                                   x_ruleset_status_in,
                                   l_get_ruleset_data_rec.destination_column_id,
                                   l_get_ruleset_data_rec.repository_id,
				   l_get_ruleset_data_rec.start_date,
				   l_get_ruleset_data_rec.end_date,
                                   l_get_ruleset_data_rec.name,
				   l_get_ruleset_data_rec.module_type,
                                   null,
                                   null,
                                   null,
				   x_org_id);

Line: 61

    SELECT *
      FROM cn_rulesets
     WHERE ruleset_id = x_ruleset_id_in and org_id=x_org_id;

Line: 76

    cn_syin_rulesets_pkg.update_row(x_ruleset_id_in,
                                   l_get_ruleset_data_rec.object_version_number,
                                   x_ruleset_status_in,
                                   l_get_ruleset_data_rec.destination_column_id,
                                   l_get_ruleset_data_rec.repository_id,
				   l_get_ruleset_data_rec.start_date,
				   l_get_ruleset_data_rec.end_date,
                                   l_get_ruleset_data_rec.name,
				   l_get_ruleset_data_rec.module_type,
                                   null,
                                   null,
                                   null,
				   x_org_id);